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