Report Data Tables represent a Data Table in a Data Set of the Report Data Source. To Add or Edit a Report Data Table click on the Report Treeview and click Add or Edit from the Edit Menu.
Report Data Table Designer
Click the Designer button to open the Report Data Table Designer. Report Data Tables represent a Data Table in the Data Set of the Report Data Source.
Select the Table Name from the Drop Down list and then Add the Data Columns to include in the Report and the order in which they should be presented. Data can be grouped into sections by adding columns to the 'Data Group By' list.
Use the Up and Down buttons to move the order in which the Columns appear in the Data Table.
Data Filtering and Sorting
A Data Filter can be applied to the Report Data 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 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 Table can styled with Fonts, Fore Color, Back Color, Borders and various other styling properties to customise the appearance of the Table. Expand the Column properties and configure the styling on the Property Page.
Data Group Properties
Data can be grouped together and the style and formatting controlled by applying settings to the group using the properties page. Click the arrow button to Add the Data Column to Data Group.
Click the Data Tab to specify the Data Group properties and Data Charts.
Include a chart in the report with the Data Group by expanding the properties and Enabling the Chart. Click the Chart Designer button to setup the Chart for the Data Group.
Data Tables can also contain Report Conditional Rules to determine if the Data Table or Column 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.
Data Table Context and XSLT
The Report Data 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.
The URI Query for the Context and XSLT can be a series of a 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.
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.