Skip to main content
Version Data Integration and Analytics
Hitachi Vantara Lumada and Pentaho Documentation

Customize an Interactive Report

  1. Last updated
  2. Save as PDF

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.

Parent Topic
Child Topics

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.

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.

Parent Topic
Child Topics

Change a column header name
You can customize your column headers to make them more descriptive or simple.

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.

Parent Topic

Design report headers and footers
Double-click the upper or lower corners of the report to design your 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.
Parent Topic

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.
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.
Parent Topic
Child Topics

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.

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

Parent Topic

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.

Parent Topic
Child Topics

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.

Parent Topic

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.

Parent Topic

Use a different report template
You can select a different template for your report using the 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.
Parent Topic