Report parameterization allows end users to customize results of Pentaho reports, by entering values that limit report datasets or trigger rendering decisions. Using the DataFactory
API, Pentaho Reporting provides a mechanism to provide parameters to data sources. As presented in Chapter 5, there are many different options for providing data to Pentaho Reporting. Each data source type uses its underlying method for parameterizing queries. For instance, the default syntax for XPATH, Kettle, MDX, and Hibernate Query Language are supported through their respective DataFactory
implementations. Each data source query syntax defines how to specify parameters, and Pentaho Reporting provides those parameters via the DataRow
API.
The two exceptions from the default management of parameters include SQL and static data. When specifying a SQL statement in JDBC, you would normally specify a question mark to denote which parameters should be specified. Pentaho Reporting requires...