Category: Jaspersoft

Steps to create Jaspersoft Sub-reports

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 Built-in Variables

Variables can be used to store partial results and do complex calculations with the data extracted from data source. These values can then be used in other parts of the report, including other variables. Jaspersoft offers some built-in variables which are displayed as light grey color and the properties of these variables cannot be edited. The built-in variable’s value changes during the report execution. The following are the most used built-in variables in Jaspersoft: PAGE_NUMBER: It contains the current number of pages in the jasper report at report running time. COLUMN_NUMBER: It contains the current number of columns. REPORT_COUNT: It contains the number of records processed. PAGE_COUNT: It contains the current number of records processed in the current page. COLUMN_COUNT: It contains the current number of records processed during the current column creation. 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 +

Jaspersoft built-in fonts and Font extensions

Jaspersoft built-in or system Fonts can be viewed in the Report viewer provided the fonts are supported by the Operating system. The best way to use a font in JasperReports Library is to use a font extension. • Jaspersoft fonts can be configured in Studio and Server and displayed in the PDF view. Fonts can be referred from an URL and from the file system using the Preferences dialog window from the Jaspersoft Studio. • The fonts .ttf files (True Type Font) can be downloaded and can be configured using the font mapping option available in the Jaspersoft studio. There are different types of font attribute such as font name, size, isBold, italic and so on. • JasperReports fonts can be categorized as logical fonts, physical fonts and font extensions. The logical fonts recognized by Java library are Serif, SansSerif, Monospaced, Dialog, and DialogInput. • The default font type offered by Jaspersoft is SansSerif with font size, 10. And the default pdf font is Helvetica. The default font name and size can be changes in report level and server level. • Font extensions force JasperReports to work with external TTF, SVG, WOFF, or EOT fonts. This ensures that a specific […]

Read More +

Benefits of using Jaspersoft with AWS

Jaspersoft supports business intelligence reporting and analytics on the AWS cloud platform. The following are the major features and benefits of Jaspersoft with AWS. • AWS offers a secure cloud services platform, offering to compute power, database storage, content delivery that enable the business scale and grow. • Users can create interactive reports, dashboards and data visualizations and capable to quickly connect to Amazon RDS, Redshift and EMR data sources. • There is no data or user limits and no additional fees. • Jaspersoft for AWS is quick and easy to set up and offers a cost-efficient cloud analytics platform. • Provides a straightforward approach for installation and reports and dashboards can be created by a few clicks in less amount of time. 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 +

Salient Features of Jaspersoft Server

Jaspersoft Server (also called JasperReports server), is the core of the Jaspersoft BI Suite. It builds on the JasperReports Library to provide a fully functional and stand-alone report server. Jaspersoft Server provides many important features such as security, a repository, and scheduling. • Jaspersoft server can be downloaded and installed separately. Once installed it can be accessed via the URL andfrom Jaspersoft studio. • Jaspersoft Server commercial edition offers a complete user-friendly web-based drag and drop Adhoc reporting feature. Users can build interactive charts, tables and cross tab analytics. • Jaspersoft server supports all datasource connectors that are available in Jaspersoft library. • Jaspersoft server provides flexible, modern and embeddable server architecture such as data caching and storage architecture, REST and SOAP based web services for simplified integration, mobile application and multi touch capability and so on. • Report scheduling based on a calendar can be performed for the deployed reports from the Jaspersoft server. • Security setup can be done by Administrators from Jaspersoft server by providing user based and role-based access to reports, dashboards, resources and folders. • Jaspersoft server Commercial edition also has the capability to design a metadata layer called Domain with business logic and joins. […]

Read More +

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 +

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 +

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 +

Multi-tenancy in Jaspersoft

Jaspersoft supports Multi-tenancy configuration in Server level. The following are some major features and benefits of Jaspersoft Multi-tenancy. • Multi-tenancy in Business Intelligence offers various advantages to a customer like easy updates and upgrades, Shared infrastructure, lower cost and maintenance, optimized performance efficiency, development and deployment cost reduction, etc. • Jaspersoft allows achieving Multi-tenancy in Professional Server edition. • Customers can create multiple organization, assign roles, row level and column level security (in the meta-data layer called Domain) in order to achieve a multi-tenant environment. • In Jaspersoft Multi-tenant mode which comprises of users using the application from multiple organizations, information from one organization cannot be viewed by other organization users. • Multi-tenancy offers users from multiple organization with mechanisms to protect data privacy. • Jaspersoft helps users to design a Multi-tenant environment from Jaspersoft server to provide better security and data privacy in a few configuration steps. 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 +