Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Pentaho Reporting Output

Parent article

The Pentaho reporting output step renders a Pentaho Report Design file (.prpt), allowing you to produce it using a selected reporting engine type.

General

Pentaho reporting output

The following fields and button are general to this transformation step:

FieldDescription
Step nameSpecify the unique name of the Pentaho reporting output step on the canvas. You can customize the name or leave it as the default.
Report definition fileSpecify the field that will contain the name of the .prpt file during step execution.
Output fileSpecify the field that will contain the name of the output file. Also, specify the output file path. Otherwise, the file will be created in the PDI client's home folder (/data-integration/output.pdf for example).
Create Parent FolderSelect this checkbox and specify the full file path in the Output file field, if you want to create a parent folder for placement of the output file.
Parameter nameSpecify the name of the parameter (if the report being generated supports parameters for input), to pass values from an input field to the report.
Field name

Specify the name of the field (if the report being generated supports parameters for input) to stream fields to provide the values. If you specify a field to use, the static input value is not used.

To pass data to String arrays, make sure the data items are separated using tabs as a delimiter.

Output processorSpecify the reporting engine used for the generation of the output file type (for example, .pdf, .csv, .xml, etc.).
Get Report Parameters(button)Click this button to import the defined parameters from an existing report.

NoteTo view a sample transformation in the PDI client, open the Pentaho/design-tools/data-integration/samples/transformations/Pentaho Reporting Output Example.ktr sample file.

Metadata injection support

All fields of this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.