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

Customize an Interactive Report

Parent article

You can adjust columns, formats, and templates of your interactive report. The columns in the report can be reordered along with the changing of headers and footers. Use the Formatting and General tabs to apply specific formats and templates as well as page layout.

Reorder and adjust columns

To change the order of columns in your report, choose the column you want to move, then drag it to the desired location. Alternatively, choose the column you want to move, click the down-arrow, and choose Move (Left or Right) from the menu.Move Interactive Reports columns

To adjust a column's width, choose the column, then click the vertical line that divides the column headers. Move the line left or right to adjust the column width.

Change Interactive Reports column widths

Change a column header name

You can customize your column headers to make them more descriptive or simple.Change Column Header Names

Perform the following steps to change a column header name:

Procedure

  1. Double-click the column header.

  2. Type the new header name in the dialog box and press Enter.

Design report headers and footers

Double-click the upper or lower corners of the report to design your report headers and footers.Design Report Headers and Footers

Use the dialog box to adjust any of the following options:

  • Delete any existing words, or enter a new header and press Enter.
  • Click Date and press Enter to insert a date and time stamp in the page header. You can customize the date and page count by adding your own text, such as Today: $(report.date), instead of using the default $(report.date).
  • Click #/Pages and press Enter to insert the number of pages in the report.

Change the format of the data values

You can change the format of the data in each column. Click inside a column to apply a format, then click the Formatting tab to choose the appropriate format for the values in your column.Change Data Formats
NoteIn some instances, you might notice that your data is already formatted. For example, money symbols are already included in sales figures. Such formatting is inherited from metadata associated with the data source. However, you can override inherited formats whenever you want.

Copy and paste formatting

Once you have one column formatted the way that you want, you can use the Copy formatting and Paste formatting options on the Formatting tab to copy the formatting to other columns in your report.Copy and Paste Formatting

If you want to remove the formatting that you applied to a column, click to select that column, then Remove Formatting.

Customize page format and orientation

Interactive Reports creates a portrait mode page in Letter format (8.5" x 11") by default. You may want to change the page orientation or format.Change Page Format and Orientation

Change page format

Perform the following steps to change the page format:

Procedure

  1. Click the General tab, then click Page Setup.

  2. In the Page Setup dialog box, choose the correct page format for your report. Page margin measurements are displayed in the lower part of the dialog box. You can adjust the measurements as needed.

  3. Click OK to save your changes.

Change page orientation

Perform the following steps to change the page orientation:

Procedure

  1. Click the General tab, then click Page Setup.

  2. In the Page Setup dialog box, click the appropriate icon.

  3. Click OK to save your changes.

Use a different report template

You can select a different template for your report using the General tab.Report Template General tab

Perform the following steps to select a different template:

Procedure

  1. Click the General tab, then use the left and right arrows to scroll through available templates.

  2. Chose a template by double-clicking on it.

  3. Click Yes or No when prompted whether to keep that formatting display.

Results

The report display is updated to reflect the new template.