Building a report by replacing the hyperblock query

Most templates use hyperblocks to provide sample values for the templates. You can replace the content of the hyperblocks to change the chart output.

  1. Create a copy of, for example, the Single Series column chart template. .
  2. In Design view, drag a relational list onto the existing hyperblock.
  3. In the relational list designer, modify the SQL query that defines the relational list.
  4. Define output cells to replace the random functions.
  5. Adjust the labels of the columns.
    The labels are displayed in the chart's legend. We recommend that you use TRANSLATEUNIQUESTRING to translate the labels.