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.

EReportwriter1_UAE

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.

EReportwriter2

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.

EReportwriter3

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.

EReportwriter4_UAE

  • Master Fields : Fields related to Employee Master Details such as Ticket Number, Employee Code, Employee Name, Date of Birth, Date of Joined, etc can be selected from this option.
  • EReportwriter5_UAE

  • Other Fields : Selection for Employee Detail related to Passport, Family, Bank, Policies, Sureties, Liabilities, Social Responsibilities and Relative in Organization, Qualification Details, Previous Job Experience, Previous Job Salary, Salary Structure details, Salary Structure History, Salary Structure Log and Custom Field Details etc can be done. At a time user can only select any one type of Detail tab data.
  • For E.g. If user has selected family Detail fields then will not be allowed to select any other Employee Detail from Other tab.

    EReportwriter6

  • Custom Filter Condition : User can also provide specific filtration / condition for specific requirements of reports. It is Additional Filter provided. User can provide data in operator, Field name, value etc and click on add button which will display Filter condition by this report data will be shown as per filter provided.

    EReportwriter7

    Working with Custom Filter :

    1. Select Join which will be Add/OR.
    2. 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.
    3. 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.
    4. 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.

    EReportwriter8

    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.

    EReportwriter9