Employee Report Writer Detail
User can define and generate reports for Master Details from this module. This is a very important Tool and can help in generating of any number of master related reports as per the users requirement. The defined report can be saved and can be used any time whenever required.
It consists of Filter, Fields, Title and Preview options.
1. Filter
In this module user can select the necessary grouping required for generating report. e.g. Grade wise, Branch wise, Department wise, Division wise, Unit wise, Category wise, Project wise, Sponsor or for any single employee selection. User can also select the grouping for All, Current or Left employees.

User can view report in Full Screen by option provided in Right Hand corner of screen, as shown in above figure.
User can Add and Save created Template for further use. As per requirement user can Select saved Template in Future.

If their is any template in Database then while user open screen find Pop-up “Select Report Template”. User can select or Close screen as per requirement.
User can Create New, Select or Delete Template through option provided in below figure.
Last Modified Date and Time will also being shown to user.

2. Fields
Fields tab consist of Master and Other Fields which is present in Add Field option. User can Add “N” Number of field from there.


For E.g. If user has selected family Detail fields then will not be allowed to select any other Employee Detail from Other tab.


Working with Custom Filter :
- Select Join which will be Add/OR.
- Field Name need to be selected by which filtration need to be done or can select Actual Field Name system will pick other name automatically.
- Select the Operator which will fulfill user requirement. (Operator may vary as per Field Selected) For Text Field operator will be Equals, Not Equals, Contain and not Contain where as for Logical/Numeric/Date field operator will be Equal to, Not Equal to, Greater than, Less than, Greater than Equal to and Less than Equal to.
- Provide the value on which output will depend.
For E.g. User want to check data of employee whose Service Month is more then 10 month and Employee Status is other then Active.
Then Filter Condition will be :
AND empinfo.no_years > 10 AND empinfo.EmpStatus != 'Active'
User can Add condition and Preview data.
3. 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 Font Size, Freeze Column and Print Serial number.

4. Preview
After Selecting above setup or after Add field user can view report form Preview tab.
User can export data in CSV, Excel and PDF through Export button.
