526
edits
Changes
no edit summary
* '''Column Heading''' - The text you wish to appear above each column in the report.
* '''Date/Time Translation''' - Used to “extract” the day, month, week, or year from a date field for comparison purposes.
* '''Group ByOptions''' - Used in [[Creating Summary Reports|summary reports]] to group by, sum, count, or calculate the average of the field. Also provides [[Using Total Group Options in Report Builder| Total Group options]] for configuration of report groupings and easier retrieval of total rows.
* '''Sort By''' - Determines the display order of the report results, '''Ascending''' or '''Descending'''.
* '''Alignment''' - Determines the alignment of the column header and the column values. Options are ''Left'' (the default setting), ''Center'' and ''Right''.
* '''[[Calculated Field]]Formula''' - Allows you to build out further complexity such as mathematical operators, concatenation, and supports MySQL syntax. For additional information, please see the '''Calculated Field''' tab in the Report Builder or [[Calculated Field|this article]].* '''ShowDisplay''' - This flag is used to suppress the display of a field that you may need to use for criteria, but not display in the reports. For example, you may wish to produce a list of salaries over 100,000 per year and use the salary as criteria, but not show the result.* '''[[Changing the Column Display Order in a Report|Move Icons]]''' - '''Move Left''' and '''Move Right''' icons are displayed to the left and right of each '''Show''' check box. [[Image:Reps7.png]] These buttons are used to change the column order.
* '''[[Criteria]]''' - Sets the criteria for the records to be displayed in the report. There are ten rows for criteria.
'''Note''': If you have many custom fields, access the reports tab within the application you are creating the report from. If you are creating a report from a particular UTA, access the reports tab from that UTA.
