Report Writer Detailed Description
This Report Writer will help to define and generate detail Report for processed records. It consists of Select, Fields, Sort & Group, Filter and Title options.
Report Writer -> Detailed
- Filter : In this module following selections can be done depending on users requirement.

- User has to select period for which the Report needs to be generated.
- 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.
- Freezed / UnFreezed / All Employees.
- Pay Mode i.e Bank, Cheque, DD and Cash.
- Report as per Latest or Actual Master.
- Status as per Left, current or All employee.
- Report Amount Inclusive or Exclusive Report for Arrears and Supplementary.
Note:
- Inclusive Amount with selection of Supplementary/Arrears will include the amount of Supplementary/Arrears. In net salary paid.
- Exclusive Amount will show exclusively only Supplementary/Arrears. Batch filter displayed for selection of Exclusive (Supplementary and arrears). Batch filter provided in all Salary process reports and Bank statement.
- Make the default setting to show the pay slip, report writer with supplementary/Arrears.
Configuration -> Report Setting -> Display checked on Pay Slips/Registers/Report Writer with Supplementary/Arrears -> save.
- Template :
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.

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.
- Fields : Fields related to Employee Master Details such as Ticket Number, Employee Code, Employee Name, Date of Birth, Date of Joined, etc and fields related to salary details (Processed Records Only) such as Earned Basic, HRA, Total Earned, PF, PT, Total Deduction, Net Paid, etc can be selected from this option through Add Fields button.

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

Col. Total : User can choose this option for those selected salary heads where he requires total of the particular head.
Row Total : User can choose this option to get total for those selected salary heads in one record (row).
At Row : User can input the row number where he requires the head to be displayed or printed.
Sort By : User can sort any of the Row data.
Group By : User can group data by any of the master of head.
Remove : User can remove any of the selected head from this option.
Text Fields : There are 15 Text Fields provided in Report Writer - Detailed. i.e. Text Field 1 to Text Field 15.

Calculated Fields : There are 15 Calculated Fields provided in Report Writer - Detailed. i.e. Calculated Field 1 to Calculated Field 15.

The main function of the detailed Report Writer is to provide details of Processed Records. User can use these fields for getting the records calculated as per his requirement. This field will allow defining necessary formula for calculation and as per the formula the result will be calculated at run time without again processing the salary.
For E.g. we require total of heads “Basic and HRA”, user has to follow below procedure.
- Select the necessary “Calculated Field” Column.
- Select the Column Total of the Selected Column if the total is required.
- Rename the Field Name for the particular column as per the requirement.
- Right Click on any cell in the particular field's row, module for defining formula will be evoked.
- User has to Select Fields Name or Actual Name whichever is remembered by user and
- Click on Add Fields.
- Select the Operators {+, -, /, *, (, or )} which needs to be used and click on Add Operator.
- Select another Fields Name or Actual Name whichever is remembered by user and click on Add Fields.
- Once the necessary formula is defined click on close.
- Custom Filter Condition : User can write the condition by which only those record will be displayed as per the filter condition.

- Join : User can select “AND” / “OR”.
- Field Name : User can select field name for which the filter condition needs to be written from the list given.
- 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.
- 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.
- Value : User can provide the Value required for the Filter condition from “Existing Values” in “Value” field.
- 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.
- 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”.
- Title :
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.

- Print Serial Number : By selecting this option user will find column as Serial Number (First Column in preview) i.e. 1,2,3,4...
- 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
- 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
- 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)
- Print Selection (Select Criteria) : system will display Master selection in Preview, if any.
- Print Run Date : System will print Run Date on Preview i.e. Date provided in “Date” Field.
- Reset Sr. No while grouping : By selecting this option system will Reset the Sr. Number as per Group.
- Date : Run Date need to be provided, by default today’s date is shown.
- Calculate Fields Rounding : User find three option for Calculate Fields rounding i.e. Round Off, Round Up and None.
- Show Grand Total : User can choose this option for Grand total of all selected field.
- Do Not Show Column If The All Values Is Equal To Zero : By selecting this option system will not display columns which have column total Zero in selected fields.
- Preview :
After above selection when user move to Preview tab find Preview of data as shown below.

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