Other Data Sources

Pentaho Report Designer

Version
9.4.x
Audience
anonymous
Part Number
MK-95PDIA008-01

The following data sources require additional knowledge and skills:

JDBC Custom
This is much like a standard JDBC connection, except you create a formula-based query through the Master Report's Attributes pane instead. See the Query attribute reference for more information.
Scriptable
Select your language, then add a query by clicking the round green + button, give your query a name, then type in your script in the Query field.
External
This data source is used when a report (.prpt - simple reporting component) is used in an .xaction. In the report, you must specify the result-set name for the query name attribute on the report. Also, you must add a report parameter using the same name as the result-set name and set the parameter to the tablemodel parameter type. The .xaction result-set can be MQL, SQL, MDX or JavaScript.
org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.​StaticDataFactorySample#createSubQuery(${Var1})