Differences

This shows you the differences between two versions of the page.

Link to this comparison view

space.template.report_template [2019/01/17 09:04] (current)
Line 1: Line 1:
 +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"]]