Changes

Report Builder Column Settings

159 bytes added, 19:35, 12 September 2013
no edit summary
* '''Group By''' - Used in [[Creating Summary Reports|summary reports]] to group by, sum, count, or calculate the average of the field.
* '''Sort By''' - Determines the display order of the report results, '''Ascending''' or '''Descending'''.
* '''Align''' - Determines the alignment of the column header and the column values. Options are ''Left'' (the default setting), ''Center'' and ''Right''.
* '''[[Calculated Field]]''' - 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]].
* '''Show''' - 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.
Initially, the report will be configured for 15 columns, but you can increase the number of columns in increments of 15 by clicking the '''more columns''' button.
8,849
edits