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