Category: Business Intelligence

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 +

Prebuilt HCM report to reconcile PayCheck Details

Oracle has seeded reports such as Payslip and Paycheck but at times Users would like to have a report which will have a summarized information of the data that is available on the Payslip/Paycheck so that they can reconcile this report’s data with Oracle’s report in order to confirm the amounts produced are correct in all these reports. Users can run this pre-built report when they would want to see, 1. The total amount processed for a particular paycheck date 2. To confirm if the amounts produced for a paycheck date is correct in the Oracle’s seeded reports. 3. To check the total amounts processed for each paycheck date separately in a huge check date range that they run. DataTerrain’s Prebuilt report: The Prebuilt report Paycheck Detail will provide the Users with data such as employee number, employee name, pay period start/end date, element name, element description, the sum of earnings and sum of earnings hours. Users can run this report with the below parameters, 1. For a single Check Date/For a range as Start Check Date and End Check Date 2. For a single Person 3. For a Payroll This report is built as an HCM Extract in order […]

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 +