A report can define a number of sub-datasets. A sub-dataset is used to describe data
that then can be used to feed data to charts and crosstabs. JasperAssistant groups these
definitions under a single SubDatasets
node in the Outline
View
. New sub-datasets can be added by using the context menu associated
to this node.
A sub-dataset can define a number of variables, parameters, fields and groups, in the same way as it's done at report level. For more details please see Section 6.8, “Variables”, Section 6.6, “Parameters”, Section 6.7, “Fields” and Section 6.11, “Groups”.
Sub-dataset Properties
Name
Name of the report sub-dataset definition as it is used to refer to the sub-dataset throughout the report.
Query
The query that will be used to retrieve the data for the sub-dataset. The query is executed against a data source that must support the language the query is written in. For more on data sources see Section 3.2, “Data Sources”
Query Language
The language the query is written in. Accepted values are:
SQL
- SQL query language that can be used with
JDBC data sources.
HBM
- Hibernate query language that can be used
with Hibernate data sources.
XPath
- XPath query language that can be used
with XML data sources.
EJBQL
- EJBQL query language that can be used
with data sources that support Java Persistence API.
MDX
- MDX query language that can be used
with Mondrian data sources.
Filter Expression
Specifies a boolean expression that controls which rows are included or excluded from the data source.
Resource Bundle
The base name of the resource bundle that provides localized strings for the sub-dataset. Localized strings can be referred to in report expressions using the $R{key} syntax. For more information on resource bundles see:
http://java.sun.com/j2se/1.4.2/docs/api/java/util/ResourceBundle.html
When Resource Missing Print
Allows to customize the way the engine deals with missing resources in the resource bundle. For more information on resource bundles see:
Null
- Null is printed for the missing
resource.
Empty
- Nothing is printed for the missing
resource.
Key
- The key as specified using the $R{key}
syntax is printed.
Error
- The report execution is interrupted with
an error.
http://java.sun.com/j2se/1.4.2/docs/api/java/util/ResourceBundle.html
Scriptlet Class
A fully qualified name of the class implementing the scriptlets functionality for this sub-dataset. The specified class must be a subclass of JRAbstractScriptlet class. If omitted, an instance of JRDefaultScriptlet will be created.
Sort Fields
A list of fields that determine the ordering of the data source.