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

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

Report Tables need Rows and Columns adding. Click the Rows Collection Editor to Add Rows.

Define a Name for the Row along with any styling and conditional Rules. Add Columns / Cells to the Row by clicking the Columns Collection Editor.

Report Table Cells can contain Text Content, Images, Charts, Data Tables, Includes and other Report Tables. Fields can be used in Report Cells for XQueries to display Report Data. XQuery can be used in the report to display data in the form of Report Fields.

To Add a Report Field click the Fields Collection Editor for the Table Cell.

Specify a Name for the Field, Formatting and XQuery using the Property Grid. Clicking the Query button will open the XQuery designer.

Field 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, Currency and various Functions applied to manipulate Data.

Field XQuery Designer

Creating an XQuery using the Field XQuery Designer.

Report XML Data can be queried using XQuery / XPath. Queries are associated with Report Fields and the output of a Query will be shown in place of the Report Field Name. A Field Name must be specified to be recognized by the Content Editor and the Query parser.

Retrieving the Name of a Fee from the report Data and displaying its output.

To display the Report Field in the Table Cell it needs to be added to the Cell using the HTML Content Editor.

Click the Content button to Add Content to the Table Cell.

Report Tables can also contain Report Conditional Rules to determine if the Content 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.

Report Table Context

The Report Context is the Data Context of the current XML Data Node. The default Context is the Report Data XML Root Node. Data Contexts can be applied to Sections, Groups, Paragraphs, Tables and other Report Items and can be used to drive and build Report Content if the Context Data Nodes can be enumerated.

To apply a Context to a Report Item expand the Context property and specify the Content Type as either a Literal (Constant) or a File. Then define the Context Type as either an XQuery, XML, JSon or HTML.

Context Types can be either an XQuery as applied to the current Data Context, XML, JSon or HTML. If the Context Type is an XQuery then an XQuery / XPath expression is Evaluated in the current Report Data Context. If the Context Types are XML, JSon or HTML then Data is read from these Contexts allowing Data to be used and read into the Report Context from other Data Sources such as API's etc.