RU 🇷🇺
In the Table Report, configure a list of records (fields) that will represent a number of columns containing the schedule data.
Use Table Reports to create and export a CSV file containing custom header names to match a specified format.
Adding Table Report
Table type reports can be added by choosing “Table Report” option from Add Report dropdown.
Once added, a blue icon with a table and the name “New Table Report” will appear in the list of reports. Rename it clearly.
Configuring Table Report
The Table Reports consists of two interconnecting tabs: Setup and Result. In the Setup tab you can add and give an export caption the Data Fields required to be displays in the Result tab.
In the Data Field column add fields you want to report on.
Use the dropdown menu provided in each row to find a field required, or
Drag and drop fields available in the Fields panel.
Use the Search tool to simplify searching for the field needed.
Empty rows in the Data Field column are not critical, they will not be present in the Result and Export.
2. In the Export Caption column, edit the field captions to be displayed as custom header names.
This feature distinguishes Table Reports from other types, and gives user the ability to export the report with custom column headings.
Export captions cannot duplicate, otherwise you’ll get an error message, preventing you from moving to the Result tab.
Rows containing duplicated names will be flagged with a red circle, as shown below:
Applying filters to the Table Report
It is now possible to apply a filter to a table report in APS and ATS. The filter can be created in the code editor that appears when the “Use Filter” check box is toggled on. Two formula helpers are located at the bottom of the editor, which assists in retrieving values used in the filter logic.
After you have populated all Data fields required, go to the Table tab and review the results. All columns will be displayed in the same order you set them in the Setup tab.
