Category: Business Intelligence

Pluggable Custom Visualizations in Jaspersoft

Jaspersoft provides a remarkable feature for users to Create and deploy their own Custom Visualization component. The following are some of the Jaspersoft Custom Visualization component features and usage. • Jaspersoft offers an extensive feature allowing users to create their own Custom Visualization component. Users can take advantage of creating Custom Visualization component provided they have coding knowledge in Javascript, CSS and HTML. • Basically, Custom Visualization Component renders a SVG (Scalable Vector Graphics) image file. Once the component is created and deployed, it will be available in the element palette from where it can be drag and dropped in to the report. • Custom Visualization Component requires few configuration steps. Once these steps are done, users can develop their own visualization component to enrich their reports and to make the reports more flexible depending on the requirements. • Custom Visualization component in Jaspersoft can also be created using JSON that allows users to add their own Component UI (Property name , type and data items) , thumb nail image (image that appear in the design view when the component is drag and dropped from the palette) and location of the script and reference files used for the creation of […]

Read More +

Steps to integrate Jaspersoft Studio with Server

Jaspersoft reporting

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

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 +

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 +

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 +

4 Ways Advanced Onboarding Can Increase Productivity

Advanced Onboarding and Productivity: Why You Need to Rethink Your Current HCM Approach There is a plethora of information regarding onboarding and its consequent benefits. In fact, most companies thrive through onboarding. According to reports, companies that do not apply onboarding process in their business strategy end up using up 150 percent of their revenue to retain unproductive employees.

Read More +