Category: Report Conversion

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 +

HCM in the Cloud Drives Customer Success

Data driven tasks such as BI support and automated reporting are driven by advancements in OBIEE and HCM Cloud applications. Utilizing these resources has become a large part of business intelligence. See how BI report support in the cloud helps businesses to succeed.

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

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 +

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 +