Purpose
This report …
Information Structure
The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within:
- Top level (table)
- Sub level (table)
- sub-sub level (table)
- sub-sub level (table)
- Sub level (table)
Tables Accessed
| ~ Purpose | ~ Table | ~ Linkage Information | ~ Filter Information | ||||
Notes:
* .
Parameters and Filter Options
The following options need to be implemented to filter the data and/or provide information to reconfigure the report display.
||~ Description ||~ Parameter Name ||~ Type ||~ Default ||~ Data Filter ||~ Notes ||
| Report Title | ?ReportTitle | String | used in header | ||||||||
| Report Path | ?ReportPath | String | show on bottom of report | ||||||||
The value selected for following parameters should be shown in the top header:
* DivisionName - shown only if DivisionID -1
* .
Display and Group Fields
Group Header #1
||~ Category ||~ Item ||~ Field ||~ Notes ||
| Group Header #1 | Division Name | Division: Division.DivisionName | ||||||
| Group Header #2 | ||||||||
| Detail | ||||||||
| Group Footer #2 | Total | Sum(x) | ||||||
| Group Footer #1 | Total | Sum(x) | ||||||
Group By
The following group by options should be supported:
||~ Description ||~ Level ||~ Optional ||~ Group ID Field ||~ Group Display Field ||~ Notes ||
| Division | 1 | No | ???.DivisionID | Division.DivisionName | |||||||
| 2 |
Sort Options
The data within a group will always be sorted by these fields if they in the group by:
||~ Description ||~ Sort Text ||~ Level ||~ Optional ||~ Notes ||
| Division | Division.DivisionName | 1 | No | ||||||
| 2 |
The user may optionally select to sort by their fields:
||~ Description ||~ Sort Text ||~ Level ||~ Optional ||~ Notes ||
| 3 | Yes |
Export
The report data should export into clean comma-delimited/Excel data.
Test Cases
Backlinks