Hitachi Vantara Pentaho Community Wiki
Child pages
  • 3a. Report Wizard (version 1.8 or higher)
Skip to end of metadata
Go to start of metadata

The Report Design Wizard allows you to step through the process of creating a report easily and quickly.

Step 1

Select a template that has the type of formatting (font, font style, colors) you want.


Step 2

Select your connection or add one.  For more information about data sources see 4. Data Sources. Then, add your query. If querying a relational connection (JDBC/JNDI), use the Query Builder to help you construct your query.


Step 3

Data fields from the Available Items list box can be moved into the Group Items By or Selected Items.


Step 4

The Format step is not required but it is the step where you can really make a report take shape.  Each field can be configured.

Display Name allows you to enter an "easy to recognize" name for a column.

Null String is a text replacement which is used when there is no data available.  The default is to use the string null.

Expression is used to create a row of summarized data for a group in its footer.  If no expressions are selected, the group footer will be blank and not take up any report real estate.  The available expressions are based on the metadata pulled for the column.

Data Formatting is used to defined how numeric or data field data is represented.  For a detailed explanation of legal format strings see for an explanation of each type of formatting.

Format widths are only valid for details, not for groups.  The widths are percent based out of a maximum of 100%, you do not have to worry about the page type or margins.  Auto defaults the column widths by dividing the space evenly by the number of details that are set to Auto. Fixed assigns a defined column width for a field.

Use Item Hide Function allows repeating data in a field to be displayed once.  This is mostly used on data fields that are sorted.


Post Wizard Steps

After you use the wizard, you can modify any of the elements within Design Mode

In previous releases (1.6 and 1.7), a mapping step allowed you map variables to text or data fields.  This step has been removed and is now handled directly in Design Mode.  The templates contain pre-defined message field elements (mapping variables), $(data-source-field).   To change the the default values for these elements, edit them in the Data Source properties of the report under Data Source section.  Also, these elements can be removed by deleting them from the report.

In addition, row banding has moved from the Report Wizard into the Report Designer.  Select the Item Band from the Structure panel and choose the Row Banding


  • No labels