Category: Jaspersoft

Jaspersoft Community vs Professional Editions

Jaspersoft provides Community and Professional editions by which customers can choose one based on the requirement. The following are major feature differences of Jaspersoft Community and Professional editions, which will help to determine which software edition is right for you • Customers can take advantage of the Jaspersoft Community Support Forum with a discussion on various topics and with patches and software updates. Professional edition offers Commercial license and guaranteed support with issue troubleshooting. • Jaspersoft Community edition provides software updates as soon as they are available. Commercial edition can be upgraded based on the management release cycle. • Jaspersoft allows numerous ways for database connectivity through JDBC drivers. In Professional edition apart from connecting to direct database, a metadata layer called Domain is available. Domains can be created from Jaspersoft Professional edition server and reports can be generated on top of domains. • With respect to Charts, Community edition supports JFree Charting with support on the properties and rendering via the Community forum. In addition to the JFree Charts, Professional edition supports HTML5 charts, Maps Pro, Charts Pro, Widgets Pro and Tibco Maps. HTML5 charts are more attractive and can be used to create interactive reports. They are designed […]

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 Core Benefits Over Other BI Platforms

OBIEE migration

Jaspersoft has various benefits and features that are helpful in real-world reporting and analytics. The following are some of the Jaspersoft Core features: • Pixel-perfect reporting: Jaspersoft offers very advanced control of page size and typography for the users to generate pixel-perfect invoices, forms and receipts reports which are to be printed. • Native Barcode support: Barcode plays a vital role in Business intelligence reports in the retail and manufacturing sector globally and contains key information including manufacturer data, cost price, retail price and unique identifiers. Jaspersoft supports Barcode functionality by simple drag and drag approach of the Barcode component from the palette. It supports Barcode4J and Barbecue libraries. • Subreports with highly complex layouts: Subreports can be designed with complex layouts and mapped in the main report with parameters passed from the main report to the subreport. In complex scenarios where there is a requirement to return values from another layout, return values feature from the subreports can be used. • Style Template libraries: In BI Reporting, there is a common requirement for using the same style across a lot of reports that falls under the same category. For example, using Bold and Italics styles for all Invoice reports. […]

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 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 +

Auditing & Monitoring in Jaspersoft

In the world of Business Intelligence, that deals with a huge amount of data, Auditing and Monitoring are necessary in order to analyze who is using the data, how much data is used and frequency of usage. Jaspersoft Server licensed edition provides Auditing and Monitoring features in the built-in form of domains, views and reports. Users can turn on and off auditing and monitoring from Config level. The following are some of the Jaspersoft Auditing and Monitoring features and usage. • Auditing and monitoring settings can be configured from the file,applicationContext-audit.xmllocated in the WEB-INF. By default, the auditing and monitoring subsystem is off. • The audit data can be moved to separate database tables through a mechanism called “Archiving”. • Adhoc views can be created using Audit Domain and Audit Reports, Audit Archive Domain and Archived Audit Reports that are available in the Jaspersoft Server. • Audit reports contain information about general and repository events, user events, role events, as well as report events. • Monitoring reports only contain information about report events. Monitoring can be done using the Domain, views and reports available in Jaspersoft server under /Public/Monitoring folder. Views and reports can be created on top of Monitoring […]

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 +