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

Refine your report

Parent article
You have created a report in the previous exercise but now you need to make the report more descriptive so that users can understand the content in the report. Follow these instructions to refine your report.

Procedure

  1. Click and drag a label (Label) from the tools palette in the left panel to the Page Header band.

    The Structure tab updates, as shown in the following figure:Structure tab
  2. Click inside the Label item and type Order Report

  3. Double-click inside the Order Report label to select the text, then select a larger font size (18 point) and apply boldface, as shown below.

    Font resizing

    The changes are applied to the text. However, now that the text is bigger you may not see all of it, so use your resizing handles and enlarge the label until you can see all of the text. Alternatively, you can stretch the resizing handles all the way to each edge of the workspace and click the align center icon in the toolbar so that the text is automatically placed in the center of the report page.
  4. With the Order Report label still selected, click down arrow of the font color icon in the toolbar. Select a color for your label.

    The font color changes. This page header will appear on every page of your report.
  5. Now, create column headers by clicking the Details Header icon under the Structure tab in the right panel.

    The Style and Attributes tabs appear under the Structure tab.
  6. Under common in the Attributes tab, change the Value of the hide-on-canvas option to False.

    The Details Header band appears in your workspace.
  7. In the toolbar, click the Select Objects icon (Select objects) .

    Notice that the icon changes to a cross hair as you move into the workspace.
  8. Move your mouse to the far right of the Details pane. Now, drag your mouse to the far left, over all your column objects to select them, as shown in the following example:

    Selected objects
  9. Click CTRLC to copy your objects and CTRLV to paste them into the Details Header pane.

    NoteAlternatively, you can choose Copy from the right-click menu.
  10. Under Format in the Report Designer menu bar, select Morph label.

    The column objects are changed to labels.
  11. Type the correct heading names for each of your columns: Order No., Order Date, Product Name, Quan., and Price Each.

    Your headers will align correctly over your columns.
  12. Click the Preview icon (Preview) to display your report.

    The following image shows an example of how the report might appear. The report looks good but you may want to make it even easier to read by applying some banding. Report example
  13. In the toolbar, go to Format Row Banding.

  14. In the Row Banding dialog box, choose Yellow from the drop-down list next to Visible Color and click OK.

  15. Click the Preview icon (Preview) to display your report.

    The following figure shows an example of how the report might appear:Report with row banding
  16. In the menu bar, go to File Save to save your report in the .../report-designer/samples folder. Enter Orders into the File Name text box.

    NoteSee More about row banding, data formatting, and alignment for additional information about refining your report.

Results

Now that your report is easier to read, you can consider adding a chart.