Category: Report Conversion

SaaS connectors in Amazon Quicksight

Amazon Quicksight

SaaS connectors can be used to access data directly from Amazon QuickSight for analysing and reporting. ● The SaaS connectors simplify accessing third-party application sources using OAuth, without any need to export the data to an intermediate data store.● SaaS applications can be used on either cloud-based or server-based instances.● If Amazon QuickSight can’t access the application, it will generate an unknown host error.● Organizations can integrate with Adobe Analytics to build consolidated dashboards to visualize their online and web marketing data.● The SaaS source must support REST API operations for Amazon QuickSight to connect to it. `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 +

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 +

PreBuilt HCM Report to view HCM Privileged Roles Audit Report

BIP Reports

Report Description:DataTerrain’s Prebuilt report is designed to display the details of the function and data security privileges granted to specific users or roles. This information is equivalent to the information that you can see for a user or role on the Security Console. This Prebuilt report is available as a BIP report.Output: The output data will have Roles of each employee.The output format of this report is Excel.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 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 +

PreBuilt HCM Report to View Tax Errors

Report Description: DataTerrain’s Prebuilt report is designed to capture Tax related error conditions such as • Invalid SSN • Negative Gross amounts • The conditions that were available in the Oracle HRMS report “Unacceptable Tax Balance report” to list out the employees with issues in their balances. This report can be run for the below parameters • Effective Date • Person • Organization This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Effective Date is a mandatory parameter. Output: The output data will have Employee number, Employee Name, SSN and the reason for the errorThe output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule : HR/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 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 +

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 +

Oracle HCM Report to view HCM Access and User Profile Access

Prebult parameter

Report Description: DataTerrain’s Prebuilt report provides user permissions and access settings that controls what Users can do within their Organization. Also, this pulls the user roles and actions performed by the users. This report can be run for the “Effective Date” parameter. This Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have Roles and Action details of each Users.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 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 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 +