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 * [[include_componentbacklinks|include component"backlinks"]]