Category: Jaspersoft

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 +

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 +

Jaspersoft reporting with JSON (JavaScript Object Notation) Datasource

Jaspersoft business intelligence reporting can be done using a JSON data source. The following are some features and benefits of Jaspersoft with JSON data source. • In the BI world, time is taken for data retrieval and memory consumption are the key factors in determining efficiency and performance. With JSON data source, Jaspersoft offers to transport data between a server and a client (web) application provided with increased efficiency and performance. • A JSON file with the actual report data can be passed to the report either from a file location or from a remote location. Once a data-adapter is created using a JSON file, the fields from the JSON can be used in the report layout. • The data-adapter from the Jaspersoft studio can be downloaded and uploaded to the Jaspersoft Server and the same report can be run from the server also. • The JSON data source can also be passed as a parameter from the main report to the sub-report in the sub-report connection expression properties. • JSON data-source offers a lightweight syntax and ease of use. Reports can be created quickly once the data are populated in the JSON file. • JSON data-source has wide advantages […]

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 +

Steps to integrate Jaspersoft Studio with Server

Jaspersoft studio and Jaspersoft server are separate applications which can be installed separately and integrated together. Jaspersoft Studio can be integrated with Jaspersoft server and allows to access and modify the resources. The following are steps to integrate Jaspersoft studio with Jaspersoft server: • In the Repository Explorer section of Jaspersoft Studio Server can be added by clicking on “Create JasperReports Server Connection” which displays the “Server Profile Wizard”. • Server name, URL, username and password can be entered, and the connection can be tested and created. • The server setup from the Jaspersoft studio is a onetime process and once done reports, subreports and other resources like images can be published from the Jaspersoft studio. Integrating Jaspersoft studio and Jaspersoft server provides the following benefits: • The same data source used in the Jaspersoft studio can be created in the server also and can be mapped when publishing the report. • For LOV parameters, corresponding Input controls with respect to the parameters can be created in the server and can be mapped to the reports once published. Similarly, all the resource files like images, fonts, JAR files, Style sheet templates, Resource bundle files and input controls can be created […]

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

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 +