|
|
| (45 intermediate revisions by 8 users not shown) |
| Line 1: |
Line 1: |
| − | The '''report builder''' window consists of two panels.
| + | #REDIRECT [[Reports#Launching the Report Builder]] |
| − | | |
| − | The top panel is used to construct the report by selected the required fields and setting the way the field should be used within the report.
| |
| − | | |
| − | [[Image:Reps5.png]] | |
| − |
| |
| − | Each report column consists of the following settings:
| |
| − | | |
| − | * '''Column Heading''' - The text you wish to appear above each column in the report. Initially, this will be set to the same name as the field, but you can edit the text if required. If you wish to change the text back to the '''Field''' name, then click the button to the right of the column heading. [[Image:Reps6.png]]
| |
| − | * '''Field''' - The field you wish to display in this column. All fields from all selected tables will be displayed in the field list. Fields are sorted alphabetically by table name, and by field name.
| |
| − | * '''Date/Time Translation''' - Used to “extract”, the day, month, week, or year from a date field for comparison purposes.
| |
| − | * '''Group By''' - Used in 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'''.
| |
| − | * '''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.
| |
| − | * '''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.
| |
| − | | |
| − | [[Image:Reps8.png]]
| |
| − |
| |
| − | There is a fixed limit of '''30 columns''' in any report. If more columns are required you will need to use two reports linked together.
| |
| − | | |
| − | [[Category:Reports]][[Category:System Management]][[Category:Applications]]
| |
