The design

  1. Open a new or existing report in Report Designer.
  2. If you are creating a new report, specify the data schema to be used for the report.
  3. From the Tool Box view, drag and drop the desired Business Graph (Map Chart, Category Chart, XY Chart, or Pivot Table) into a container on the report design.

    The Design Window will contain a Chart object and its related Item object (shown as a price tag). If you cannot view the entire chart in the Report Design window, you can re-size the display of the report in the window: point the mouse at the report and scroll the mouse scroll button while holding down the keyboard Control key.


    This figure is a screenshot of a chart object in the work area.

    Figure 1. Chart object in the work area

  4. Select the chart object and enter the values for its properties in the Properties View. The properties vary depending on the graph chosen:
  5. Select the chart's price tag, which represents the item object, and enter values for its properties. The specific properties vary depending on the graph type.
    • keys - the data items that are used to group values, These data items must be Strings. You are not limited to existing String data items, however. You can define a custom string for the key, using the data items in a expression.
    • values - the data item that contains the numbers to be charted. These data items must be Numeric.
  6. Modify the tree in the Structure view as needed:
    • The item object for the chart ( Map Chart Item, Category Chart item, XY Chart item) must be a child of the OnEveryRow trigger node.
    • The location of the chart object ( Map Chart, Category Chart, XY Chart) specifies how many different charts will be created, based on the resulting subsets of the data.

Drag and drop the nodes in the Structure view to create the correct hierarchy. If you drop a container or trigger on a different node, it will be a child of that node. Use alt-drag and it will become the parent of that node.

Examples

With Figure 2, the Structure View that resulted from the creation of a new report containing a chart. It will create a new page and chart for each data row passed to the report, and therefore needs to be modified:


This figure shows a Mapchart Item under the Mapchart object node under PageRoot. See the surrounding text for information on modifying the Structure View.

Figure 2. One chart per each row

With Figure 3, the Structure view will result in a page containing one chart; the item node is a child of OnEveryRow:


This figure shows a Mapchart Item under the OnEveryRow trigger node in the Report Structure View. This structure results in a single page report with one chart.

Figure 3. One chart, one page

With Figure 4, the Structure View will result in one chart for every unique userid, since the Map Chart is a child of the userid trigger node; the item node is a child of OnEveryRow:


This figure shows a Mapchart object under the userid trigger node, and a Mapchart Item under the OnEveryRow trigger node in the Report Structure View. This structure results in a Map Chart for each userid.

Figure 4. One chart for each unique userid