Category: Jaspersoft

An Overview of Jasper Reports Scriptlet Class

Scriplets in Jaspersoft

Scriptlets are sequences of Java code that are executed every time a report event occurs. Values of report variables can be affected through scriptlets. A scriptlet is a java class, which must extend either of the following classes: • net.sf.jasperreports.engine.JRAbstractScriptlet − This class contains a few abstract methods that must be overridden in every implementation. These methods are called automatically by JasperReports at the appropriate moment. The developer must implement all the abstract methods. • net.sf.jasperreports.engine.JRDefaultScriptlet − This class contains default empty implementations of every method in JRAbstractScriptlet. A developer is only required to implement those methods depends upon the needs of their project. The following table lists some of the methods in the above class. These methods will be called by the report engine at the appropriate time, during the report filling phase. Method Description public void beforeReportInit() Called before report initialization public void afterReportInit() Called after report initialization. public void beforePageInit() Called before each page is initialized. public void afterPageInit() Called after each page is initialized. public void beforeColumnInit() Called before each column is initialized. Any number of scriptlets can be specified per report. If no scriptlet is specified for a report, the engine still creates a single […]

Read More +

Jaspersoft Report–Basic Element Properties and Palette

Jaspersoft studio

All elements have a set of common properties. Other properties are specific to the element type. An element’s properties determine its appearance and position on the page. Users can access the properties of a selected element in the Properties view (by default in the upper right area of the UI). In Jaspersoft Studio user place elements within bands (containers). Depending on the elements it contains, the user can change the vertical size of a band. The Palette: Elements appear in the Palette, located by default in the top right of the UI. The palette contains three sub-palettes: Basic Elements: It contains the elements and components available in all editions of Jaspersoft Studio Composite Elements: It contains elements created as combinations of other elements, such as Page Number and Time. Users can add their own composite elements to any palette. Components Pro: contains elements only available in commercial versions of Jaspersoft Studio. This subpalette is not visible in the community edition. 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 […]

Read More +

How to create Alternate Row backgroundcolor in Jaspersoft reports

Scriplets in Jaspersoft

Conditional styles combined with some specific report built-in variables can be used to generate alternate row colors in the detail section of Jaspersoft reports. As known, the detail section is repetitive and contains common layout information for records in the dataset. For each record in the dataset, a detail section filling process is called at fill time. Being related to records, one of the most common layouts used for the detail section is the table row layout. And like in any other table, alternate row colors might be needed. To obtain alternate row colors, two things are necessary: 1. To know the current record number in order to determine if it’s odd or even. 2. A conditional style with specific style properties for odd or even rows. The first requirement is accomplished with the help of report built-in counting variables: • REPORT_COUNT – If the row color alternation does not depend on the page, column or group breaks. • PAGE_COUNT – If each new detail page should start with the same row color. • COLUMN_COUNT – If each new detail page column should start with the same row color • <group_name>_COUNT – If each new group of records should start […]

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 – Feature rich Open source BI tool

Jaspersoft is a leader among open source business intelligence (BI) and reporting tools. This is primarily due to the rich set of features which comes as part of the Jaspersoft platform. • Jaspersoft reports Server embeds the Jaspersoft Reports engine and provides a user-friendly, web-based interface for end-users to run and view reports. • Jaspersoft has an in-built report scheduler wizard through which we can set up a schedule and define the recurrence and frequency. • Different types of export options are available such as PDF, XLS, CSV, DOCX, RTF, ODT, ODS, etc. • Reports can be viewed seamlessly in desktop screen and mobile devices. • Jaspersoft server supports a variety of datastores including Oracle, PostgreSQL, and NoSQL. • Jaspersoft handles a large volume of data with ease. Jaspersoft displays the initial page of a large report quickly and then loads the subsequent pages in the background, hence the output appears to be rendered fast. • Charts, visual text rotation and graphs can be created perfectly with some in-build properties such as appearance, borders, hyperlink, chart and chart plot. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in […]

Read More +

Properties view in Jaspersoft Report

The Properties view in Jaspersoft Report helps the user to configure a selected element. If more than one element is selected, only the properties of those elements have in common are shown. If the Properties view is not visible, open the context menu for the selected elements and find the Show Properties menu item, which shows and brings to the front the Properties view. Properties are organized into tabs and sections for a better organization and usability. Tabs can include the following: Appearance tab, which contains all the properties responsible for element size, position, colors, style and flags when the element is shown in the runtime. Borders tab, where user can configure how borders of the element are painted. An element tab allows the user to set evaluation time along with properties specific to the element type. For example: The Static Text tab allows the user to define unchangeable text for a field and control its appearance. The Text Field tab allows the user to format and position a text field element. The Image tab allows the user to set image alignment, fill, and scale properties. Advanced tab, which contains all the properties for the report element in the form […]

Read More +