The Report Data Source can be queried using XQuery / XPath or Python statements. Queries are associated with Report Fields and the output of a Query will be substituted in place of the Report Field Name.
To Add or Edit a Report Query click on the Report Treeview and select the Queries node.
Report Query using XQueries / XPath
XQuery is a query and functional programming language that is designed to query and transform collections of structured and unstructured data, usually in the form of XML (Extensible Markup Language).
If the Report Query Type is XQuery the XQuery Designer will be used to Edit the Report Query.
XQuery provides the means to extract and manipulate data from a data source. XQuery contains a superset of XPath expression syntax to address specific parts of an XML document.
Click OK to Add or Edit the Query expression.
Report Query using Python
If the Report Query Type is Python then Python Scripting will be used. The Report Item Context will be passed into the Python Editor for Querying using Python.
IronPython can use the .NET Framework and Python libraries, and other .NET languages can use Python code just as easily. Python Scripting can be used to Query Report Data and create Report Contexts.
The Python Editor allows Python Functions to be Inserted and the Script to be Validated and Executed displaying the Output as it will be used in the Report.
The Report Query Content Type can be either a Literal or a File. If the Content Type is a File the Content for the Report Query is read from the specified URI or URI Query.
The URI Query for the Report Query 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 File location will be determined from the URI property. If the Value Type is Query the File location will be determined from the URI Query.
Report Queries can also contain Fields within Fields which can be used to substitute Content in the Report Query. XQuery and / or XSLT, Python can be used in Report Fields and provides the means to extract and manipulate data from a report data source.
XML namespaces are used for providing uniquely named elements and attributes. If the Data Source contains Namespaces they be applied to the XQuery Processor.