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 select 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 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 Table Group and expand out the Properties for the Table and enter a limit for the Data Rows.
Select and Sort Filters
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 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.
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, Currency and various Functions applied to manipulate Data including Format Strings, Mathematical Expressions, Equations and Regular Expressions.
Data Group Properties
Data can be grouped together and the style and formatting controlled by applying settings to the group using the properties page.
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 expressions 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 an XQuery expression to specify the location of the URI. If the Value Type is a literal the URI location will be determined from the URI property. If the Value Type is XQuery 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.