Work with Report Control (Desktop Client)

For Web Client, visit Work with Report Control (Web Client)

The Report Control controls the reporting contents of all the reports. In the Report Control, you can define the sorting order and the filter conditions:

The AND/OR column that can be suppressed to uncheck the Disable "OR" in Report Control in Company Setup.

When the AND/OR column is available, and if more than one logical operator is used in a statement, AND is evaluated first, and then OR.

From the Field Column, select the Field Name that you wish to filter. All the Field Name in the Report is available to select.

From the Operator Column, select the Operator for comparison.

Operators:

Equal Show the data that is exactly equal the given value

Not Equal Show the data that is not equal the given value

Contains Show the data that contains in the given value

Not Contains Show the data that does not contain in the given value

Begin with Show the data that is begin with the given value

Between Show the data that is between 2 given values (use .. to separate the values)

In Show the data that is in one of the given list of values

Not In Show the data that is not in one of the given list of values

> or = Show the data that is greater than or equal to the given value

< or = Show the data that is less than or equal to the given value

> Show the data that is greater than the given value

< Show the data that is less than the given value

Select “And/or” when multiple conditions is given.

Select the Order by combo box to control the sorting sequence of the result (This is only valid in Excel Reporting)

Select the Output To option to let the output go to Email, Windows, Excel, Screen, PDF or Printer. (Depended on the design of the report, not all options are available to select).

Output to Window is to display the raw information in a Table Format for easy reference.

Upper Right Menu

Report > Excel Autofilter - when available and checked, will add the Excel Autofilter feature to each column heading.

Report > Print with Gridlines - print grid lines on report when print to printer

Report > Column Selection - If the report is an Excel Report, use can select which column are required to display on the report

Report > Open Condition Template - You can retrieve the conditions you already saved

Report > Save Condition Template - You can save the conditions for later use

Help > Report Format Sample - display the sample report layout in HRPro Help Center

Help > Report Control Help - display this Work with Report Control web page

Format

Some reports may have different formats to select. Click the combo box to select if available.

Notes:

Report Control can only filter rows!. i.e. whether to print 1000 rows or 10 rows on the report (filer by the given Conditions)

If each row is a specific employee, Report Control can filter employees, e.g. Employee Name begin with Chan

If each row is a specific Leave Date, Report Control can filter dates e.g. Leave Date >= 2014/01/01 and Leave Date <= 2014/06/30

The default printer on the printer drop down list is the printer that selected to print that report last time. Unless there is no last time printing, it is the Windows Default Printer. (i.e. if the printer for printing pay slip is a dot matrix printer, the default printer for pay slip will always the dot matrix printer).