Indigo DRS Data Reporting System Indigo DRS
Report Data Pivot Tables Indigo DRS Help

Report Data Pivot Tables represent a summary of a Data Table in a Data Set of the Report Data Source. The Pivot Table summarizes Data in another Table, and is made by applying operations such as sorting, averaging, summing or counting.

To Add or Edit a Report Data Pivot Table click on the Report Treeview and click Add or Edit from the Edit Menu.

Example of a Pivot Data Table

 
ACME SOFTWARE
TOMMY SYSTEMS
DAC SOLUTIONS
OCCUPATION
2010
2011
2012
2010
2011
2012
2010
2011
2012
Administration         £633,226.75 £333,174.71   £289,011.14 £266,929.36
Business Analyst £7,079,479.00                
Chartered Accountant   £116,591.03       £178,602.21     £200,684.00
HR Analyst £121,111.50 £121,764.71 £145,479.53       £561,009.00    
HR Manager £194,755.00 £233,806.68       £666,349.43     £311,092.93
Project Manager       £266,929.36          
Sales Representative £337,059.00         £355,256.50   £255,888.46 £277,970.25
Software Engineer £1,875,584.75 £243,529.42 £804,683.92     £189,643.10 £522,817.82 £300,052.03  
Team Leader £211,724.89 £37,356.85     £366,297.39        
  £9,819,714.14 £753,048.69 £950,163.45 £266,929.36 £999,524.14 £1,723,025.95 £1,083,826.82 £844,951.63 £1,056,676.54

Data Pivot Function

The Data Pivot Function determines how Data is summarized in the Pivot Table. The Functions for summarising Data include Sum, Average, Count, Max, Min, First, Last and Exists. Choose the relevant Function for the Data Pivot Table according to how the Data needs to be summarised or presented.

Data Filtering and Sorting

A Data Filter can be applied to the Report Data Pivot Table for Filtering and Sorting. To Enable Data Filtering click the Data Filter button on the property page to open the Filter properties.

Select and Sort Filters can be applied to the Data Table to return even more specific results. For example, if a Select Filter is applied for Name = 'Cool Doc Fee' then only the Fees with this Name will be output in the Data Table.

Data Table Row Limit

The number of Rows in the Data Table can be limited by specifying a Row Limit. Open the Property Page for the Data Filter and enter a limit for the Data Rows.

Data Filter Designer

The Data Filter Designer can be used to design Data Filters and Sorting on Data Columns.

Select the Data Columns to Filter and / or Sort from the Dropdown lists in the Column Headers.

Click Run Filter to view the Filtered Data output and then OK to apply to the Report Data Pivot Table.

Data Column Properties

The Data Column style and format can be configured by applying settings in the properties page. For example a column can be specified as having a currency format with rounding and decimal places.

Data Column Formatting

There are many options for formatting Field Data. Select the best formatting option to display the Field Data according to your requirements. Data can be formatted for Time, Date, Number, Currency and Strings.

Regular Expressions and Inbuilt Functions can also be applied to Data Formats to manipulate and extract Data.

Data Formats can also be declared globally in the Report and used throughout the Report to apply common Data Formatting options. If a global Data Format is available it will be shown in the dropdown for Field Formatting under Format Name.

Data Row and Alternate Row Styling

Data Rows and Alternate Rows in the Data Pivot Table can styled with Fonts, Fore Color, Back Color, Borders and various other styling properties to customise the appearance of the Pivot Table. Expand the Column properties and configure the styling on the Property Page.

Data Table Context and XSLT

The Report Data Pivot Table can use the Report Data Context or a custom Context specified by the Context Property.

In addition XSLT Reporting features Extensible Stylesheet Language Transformations which is a language for transforming XML documents into other XML documents or other formats such as HTML for web pages or plain text.

To specify an XSLT to Transform the Report Table Data click the Button on the XSLT Property to Open the XSLT Editor.

Value Types

The URI Query for the Context and XSLT can be a series of XQuery or Python statements to specify the location of the File URI. If the Value Type is a literal the URI location will be determined from the URI property. If the Value Type is Query the URI location will be determined from the URI Query.

Report Rules

Report Conditional Rules can also be applied to Data Pivot Tables to determine if the Table is displayed or not. Report Rules are XQuery or Python statements that return True or False and determine if Content is Enabled. By Default if empty the Rule will always be True.

Namespaces

XML namespaces are used for providing uniquely named elements and attributes. If the Data Source contains Namespaces they can be applied to the XQuery Processor.