Category: Report Conversion

How to view Employee Roster Register in 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 +

Prebuilt HCM Report to view New Hires or Terminations

One of the crucial tasks of HR Team is to maintain a clear track of the new hires and terminations of an Organization. It is necessary for the HR Team to have reports which provide an answer to important questions such as: 1. How many employees are newly hired in the last quarter? 2. How many are terminated within a particular period? 3. In which Business Unit/Location/Department, the most or least hires/terminations occurred? 4. Newly hired/terminated employee count in a particular Payroll DataTerrain’s Prebuilt report provides details related to the new hired/terminated employees. This prebuilt report can be run for the below parameters 1. Start Date/End Date (To get employees in a date range/Quarter) 2. Payroll Name (To filter hire/terminations in a payroll) 3. Organization (Display hire/terminations in an Organization) 4. State/Location/Department (To list hire/termination by State/Loc/Dept) This report can also be run for a default period such as for capturing the hire/terminations in the past 30 days/15 days instead of passing any parameter. This report is built both as an HCM Extract and a BIP report, hence it can be run from the ‘CheckList’ section or from the BI Publisher Catalog, Users can use either Extracts or BIP report […]

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