Category: Jaspersoft

Why use DataStage?

Datastage is an ETL tool which extracts, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. The reasons for using DataStage • DataStage Module helps in reducing the workload and business rules management. It optimizes hardware utilization and control job activities • It provides user interaction with administrative projects. It also keeps interaction with systems and can manage global settings. The administrator’s responsibility varies from setting up projects, properties, adding, deleting and moving projects. A command interface is given to DataStage Repository administrators. • DataStagerepository can be viewed and edited, the main interface of DataStage repository is DataStage Manager. To search or Store DataStage repository and manage to reuse Metadata, the Manager loads all the services. It plays an important role in organizing all tasks to the DataStage Repository. • It helps in creating jobs on DataStage or app by giving the design interface. Each job from outside view specifies the instinct of data, possible transformations, and the target as well. The designer will also provide user graphical interface which is easy. The server will take care of loading the executable data. […]

Read More +

Jaspersoft Report Built-in Charts

Jaspersoft report has a built-in support for charts using the new chart component. Using a new chart component, user needs to apply only the visual settings and define expressions that will help build the chart dataset. JasperReports uses JFreeChart as the underlying charting library. When configuring a new chart component, following three components are involved – • The overall chart component • The chart dataset (which groups chart data-related settings). • The chart plot (which groups visual settings related to the way the chart items are rendered). Jaspersoft Reports offers built-in support for a variety of chart types as listed below: • pieChart: A combination of a Pie dataset and a Pie plot. • pie3DChart: Groups a Pie dataset and a Pie 3D plot. • barChart: A basic combination of a Category dataset and a Bar plot. • bar3DChart: Wraps a Category dataset and a Bar 3D plot. • xyBarChart: Supports Time Period datasets, Time Series datasets, and XY datasets, and uses a Bar plot to render the axis and the items. • stackedBarChart: Uses data from a Category dataset and renders its content using a Bar plot. • stackedBar3DChart: Uses data from a Category dataset and renders its content […]

Read More +

Jasper Reports Global Scriptlets

When complex functionality cannot be achieved easily using report expressions or variables, JasperReports provides us with a simple and powerful means of doing this with Scriptlets. Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. User can associate scriptlets by declaring the scriptlets globally. The global scriptlets apply to all reports being filled in the given JasperReports deployment. This is made easy by the fact that scriptlets can be added to JasperReports as extensions. The scriptlet extension point is represented by thenet.sf.jasperreports.engine.scriptlets.ScriptletFactory interface. Jasper Reports will load all scriptlet factories available through extensions at runtime. Then, it will ask each one of them for the list of scriptlets instances that they want to apply to the current report that is being run. When asking for the list of scriptlet instances, the engine gives some context information that the factory could use in order to decide, which scriptlets actually applied to the current report. Data Terrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We […]

Read More +

Jaspersoft Report creation phases

The main purpose of Jasper-Reports is to create page-oriented, ready to print documents in a simple and flexible manner. The creation life cycle has the following distinct phases: • Designing the report: User creates the JRXML file, which is an XML document that contains the definition of the report layout. • Compiling the report: JRXML is compiled in a binary object called a Jasper file (*. jasper). This compilation is done for performance reasons. Jasper files are what user need to ship with their application in order to run the reports. • Executing the report: Data from the application is filled in the compiled report. The specified Jasper class provide necessary functions to fill the data in the reports. A Jasper print file (*. jrprint) is created, which can be used either to print or export the report. • Exporting the report to the desired format: User can export the Jasper print file created in the previous step to any format using JasperExportManager. As Jasper provides various forms of exports, hence with the same input, we can create multiple representations of the data. Data Terrain with years of experience and reliable experts is ready to assist. We have served more […]

Read More +

Data Grouping in Jaspersoft Crosstab

Crosstab reports contains tables that arrange data across rows and columns in a tabular form. Crosstabs can be used with any level of data (nominal, ordinal, interval, or ratio). Data Grouping in Jaspersoft Crosstab: The crosstab calculation engine aggregates data by iterating through the associated dataset records. In order to aggregate data, one needs to group them first. In a crosstab, rows and columns are based on specific group items, called buckets. A bucket definition should contain: • bucketExpression − The expression to be evaluated in order to obtain data group items. • comparatorExpression–The expression is to use for ordering the values. If no expression is present, the default ordering for the data type is used • orderByExpression− Indicates the value used to sort data. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Jaspersoft Crosstab Attributes

Crosstab reports contain tables that arrange data across rows and columns in a tabular form. Crosstab object is used for inserting a crosstab report within the main report. Crosstabs can be used with any level of data (nominal, ordinal, interval, or ratio), and usually display the summarized data, contained in the report variables, in the form of a dynamic table. Variables are used to display aggregate data such as sums, counts, average values. Crosstab attributes: JRXML element <crosstab> is used to insert a crosstab into a report. Following is a list of attributes of an <crosstab>element: • isRepeatColumnHeaders: Indicates whether the column headers should be reprinted after a page break. The default value is true. • isRepeatRowHeaders: Indicates whether the row headers should be reprinted after a crosstab column break. The default value is true. • columnBreakOffset: When a column break occurs, indicates the amount of vertical space, measured in pixels, before the subsequent crosstab piece to be placed below the previous one on the same page. The default value is 10. • rundirection: Indicates whether the crosstab data should be filled from left to right (LTR) or from right to left (RTL). The default value is LTR. • ignoreWidth: […]

Read More +

Properties of Jaspersoft Sub-Report Element

Subreport element is similar to a place holder defining the position of the top-left corner to which the subreport is aligned. The following properties are available in the Properties to view in the Subreport tab. • Run To Bottom: When true, the sub-report element will consume the entire vertical space available on the report page. • Expression: Expression that can be used to load the Jasper object to use when filling the sub-report portion of the document. Evaluated at run time to retrieve the Jasper object for the sub-report. • Using Cache: Specifies whether the sub-report’s report object is kept in memory or reloaded each time it’s used. It is common for a sub-report element to be printed more than once. • Connection Expression/Data source Expression: At the run time, returns a JDBC connection or a JRDataSource used to fill in the sub-report. Only one of these expression types can be used. If there is no connection or data source expression, no data is passed to the sub-report. • Parameters Map Expression: The expression must contain a set of coupled names/objects that are passed to the sub-report to set a value for its parameters. • Edit Return Values: It allows […]

Read More +

Steps to create Jaspersoft Sub-reports

OBIEE migration

A sub-report is simply a report composed of its own JRXML source and compiled in a Jasper file. Creating a sub-report is very similar to creating any other report. The margins of a sub-report are usually set to zero for sub-reports because a sub-report is meant to be a portion of a page, not an entire document. The horizontal dimension of the sub-report should be as large as the element into which it is placed in the parent report. There are three steps to creating and adding a sub-report: • Create a report – Create a parent or master report that will contain the sub-report. • Create a sub-report – Create and compile a sub-report. Optionally create a dynamic connection to filter the records of the sub-report based on the parent’s data. • Add the sub-report to the parent report – Insert a sub-report element and specify the following: o The data adapter or data source for the sub-report. o The location of the sub-reports compiled Jasper file. o An optional parameters map (it can be empty) to set the report parameters used in the dynamic connection. DataTerrain with years of experience and reliable experts is ready to assist. We […]

Read More +

Jaspersoft Built-in Variables

Variables can be used to store partial results and do complex calculations with the data extracted from data source. These values can then be used in other parts of the report, including other variables. Jaspersoft offers some built-in variables which are displayed as light grey color and the properties of these variables cannot be edited. The built-in variable’s value changes during the report execution. The following are the most used built-in variables in Jaspersoft: PAGE_NUMBER: It contains the current number of pages in the jasper report at report running time. COLUMN_NUMBER: It contains the current number of columns. REPORT_COUNT: It contains the number of records processed. PAGE_COUNT: It contains the current number of records processed in the current page. COLUMN_COUNT: It contains the current number of records processed during the current column creation. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +

Jaspersoft Built-in System Parameters

Report parameters are used in many different ways inside a report. They can be used in the where condition of an SQL query, or to provide additional data to the report. Parameters are the best communication channel between the report engine and the execution environment. Jaspersoft Reports provides some built-in parameters that the user may read but cannot modify or delete. The following are some of the major built-in parameters of Jaspersoft: • REPORT_PARAMETERS_MAP – it contains the parameter values defined by the user. • REPORT_CONNECTION – holds the JDBC connection used to run the SQL query. • REPORT_MAX_COUNT – allows the users to limit the records from the data source. • REPORT_LOCALE – contains the resource bundle desired locale • REPORT_TIME_ZONE – Sets the time zone used to fill the report. • REPORT_TEMPLATES – This is an optional collection of styles (JRTemplate) that can be used in addition to those defined in the report. • IS_IGNORE_PAGINATION – User can switch the pagination system on and off with this parameter. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible […]

Read More +