Category: Report Conversion

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 +

Creating Queries in Jaspersoft Reports

Jaspersoft reports

Jaspersoft Studio provides tools to help user define report fields and create a proper query if a query language is used to acquire the data for the report. These tools are presented in the Dataset and Query dialog. It also provides an easy way to build SQL queries by using a drag-and-drop query builder. This allows users who don’t know SQL or just are not sure about the syntax to quickly join tables and produce complex data filters and where conditions. SQL Builder also provides a way for skilled users to explore the database and list the metadata such as schemas and available tables. Using Dataset and Query Dialog: The dataset and query dialog allows a user to: • Select a data adapter with which to configure the dataset. Usually, a data adapter is selected, but it is possible to change it if necessary. • Select a query language for the dataset being edited (which can be the main dataset or a sub-dataset used to populate a chart or a table). • Specify the query by typing text or by using a tool, if available, designed for the selected language. A tool is available for several languages including SQL, XPath […]

Read More +

Frames in Jaspersoft Reports

Jaspersoft reports

A frame is an element that can contain other elements and optionally draw a border around them. Since a frame is a container of other elements, in the document outline view the frame is represented as a node containing other elements. A frame can contain other frames, and so on recursively. To add an element to a frame, just drag the new element from the palette inside the frame. Alternatively, the user can use the outline view and drag elements from a band into the frame and so on. The position of an element is always relative to the container position. If the container is a band, the element position is relative to the top of the band and to the left margin. If the container is a frame, the element coordinates are relative to the top left corner of the frame. Since an element dragged from a container to another does not change its top/left properties, when moving an element from a container to another its position is recalculated based on the new container location. Advantages of using a frame: • When the user moves a frame, all the elements contained in the frame move. • While using a […]

Read More +

Difference between Authors and Readers in Amazon Quicksight

Quicksight Authors Readers

Authors and Readers are just a user type that cannot change account permissions or invite users. Both the users can be upgraded to admin at any time. Authors● An author is a user who can connect to data sources● Authors can create interactive dashboards using advanced QuickSight capabilities and publish dashboards with other users in the account.Readers● A reader is a user who uses interactive dashboards and they can view a shared dashboard, filter data and export as CSV files.● Readers can be upgraded to authors via user management options.● Readers with pay per session pricing exist only in enterprise edition DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Jaspersoft reporting with JSON (JavaScript Object Notation) Datasource

Jaspersoft Reports

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 +

How to view Employee Roster Register in Oracle HCM

Oracle HCM

DataTerrain’s prebuilt report provides the list of roster employees along with position and demographic data and assignment information. This report can be run for the below parameters • Person Type • Segment • Organization • Division • Department • Region • Country • Assignment StatusThis Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have department classifications, Job details, Annual Salary, Work Schedule of each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: HR Team can also schedule the report and use it for a regular audit.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 contr

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 +

How to view Element Entry Details in Oracle HCM

Prebuilt Oracle

DataTerrain’s prebuilt Oracle HCM report provides all element entry values for a given payroll relationship. Element Entries associated with an employee which is used to display a specific element of each employee.   This report can be run for the below parameters Start Date End Date This Prebuilt report is available as a BI Publisher Data model report. Output: The output data will have Employee record, Audit action, Field Name, Old and New value for each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +