Cross Tab Report Description

A Cross Tab Report is a Summary Report Writer that combines and compares large amounts of data with two masters together. User can assign different masters to its rows and columns to see different summaries of the data and display the details for areas of interest. It consists of Filter, Fields, Title and Preview options.

Report Writer -> Cross Tab

CrossTab1

  1. User has to select period for which the Report needs to be generated.
  2. Then the necessary grouping required for generating of report E.g. Grade wise, Branch wise, Department wise, Division wise, Unit wise, Category wise, Project wise or for any single employee selection can be selected. If no masters are selected it will generate report for all the employees.
  3. Freezed / UnFreezed / All Employees.
  4. Pay Mode i.e Bank, Cheque, DD and Cash.
  5. Report as per Latest or Actual Master.
  6. Status as per Left, current or All employee.
  7. Report Amount Inclusive or Exclusive Report for Arrears and Supplementary.

Note:

Configuration -> Report Setting -> Display checked on Pay Slips/Registers/Report Writer with Supplementary/Arrears -> save.

Template option on the top Right corner of the Detailed Report Writer has some more settings Add, Save as, Select in which modify and delete template can be done.

CrossTab2

Please Note that User has to first do the necessary selection for “Fields, Filter, Custom Filter and Title” then save the settings from option “Template -> Save as”. This report can be selected from “Template -> Select” option.

CrossTab3

Field Caption : In this field user can update the Name of the heads required in the Report for the selected head.

CrossTab4

Remove : User can remove any of the selected head from this option.

The main function of Cross tab Report is to provide details of Processed Records on the basis of Selected Row and Column which is mandatory for Preview. we require Selection of Row and Column to view data on the basis processed data, here sub Row can also be selected and data will be shown as per selection.

CrossTab7

  1. Join : User can select “AND” / “OR”.
  2. Field Name : User can select field name for which the filter condition needs to be written from the list given.
  3. Actual Name : If user remembers actual name instead of field name he can search the list and select Actual Name instead of Field Name for which the filter condition needs to be written. Once the Actual Name is selected the respective “Field Name” is displayed in the “Field Name” Column.
  4. Operator : The operator such as Equals, Greater than, Less than (=, > , >=, <, <=, <>) are available for selection. User can select the necessary operator required for writing the filter condition.
  5. Value : User can provide the Value required for the Filter condition from “Existing Values” in “Value” field.
  6. Add : After all the above fields are selected user has to click on “Add” button. This will display the condition selected in “Existing Filter Condition” window.
  7. Clear : if user clicks on “Clear” button this will clear all the condition displayed in “Existing Filter Condition” window.

Note:

User Can also select multiple selection for single report by using Join “AND” / “OR”.

User can define the title required in the report. Various different settings for the report can be managed from this option such as setting the Decimal Places, Number Separator, serial number, etc.

CrossTab8

  1. Print Serial Number : By selecting this option user will find column as Serial Number (First Column in preview) i.e. 1,2,3,4...
  2. Print Decimal Places : By selecting this option user will find Decimal Places to be printed in Preview in All amount fields i.e. 54378.12
  3. Print Number Separator : By selecting this option user will find Decimal Places to be printed in Preview in All amount fields i.e. 1,000
  4. Print Column Total : System will display Column total in preview.
  5. Print Row Total : System will display Row total in preview.
  6. Print Sub Total : System will display Sub total in preview, if any.
  7. Do Not Print Selected Month - Year : By selecting this option user will not find the “For Month” in Preview provided in Filter. (By Default For Month Selected in Filter shown in Preview)
  8. Print Run Date : System will print Run Date on Preview i.e. Date provided in “Date” Field.

After above selection when user move to Preview tab find Preview of data as shown below.

CrossTab9

User can Copy,Export data in CSV and Excel through “Export” Button.