Adding or editing charts from the report definition rule form

You can add a chart to a summarized report by launching the Chart Editor from the report definition rule form. To include a chart, a report must have at least one summarized column.

  1. Create a report definition rule, or open an existing report definition rule form by navigating to the rule in the Application Explorer.
  2. On the Query tab, verify that the report contains at least one summarized column.
  3. On the Chart tab, click Include chart.
  4. From the Chart Editor toolbar, use the following options to specify the chart type and subtype, the title, and format:
    • All chart types – If the chart type you want is not displayed in the toolbar, click this option to select a chart type and its subtype from a list of all available charts.
    • Title – Specify the chart title and text formatting in the Chart title modal dialog box.
    • Color settings – Display and define the color options for the chart.

      Options include:

      • General color settings – Define general color settings for the chart, such as the background color, whether to use solid colors or gradients in 2D charts, and the palette of available colors.
      • Conditional colors – Define colors that conditionally apply to chart elements based on numeric values and group by column values. For example, you can specify that columns in a column chart with values over 100 display as red. Each conditional color consists of a condition, a value, and a HEX value color code.
      • Threshold colors – Define colored lines or regions that display on the chart grid. For example, on a line or column chart, you can display a red line that is parallel to the X-axis at a value of 100 on the Y-axis. Each color threshold consists of a condition, a value or range of values, a HEX value color code, and an optional label.
    • General settings – Display and define general settings for the chart.

      Options include:

      • Format options – Specify the font size and weight for labels, the chart size, the chart version, and if applicable, whether to display the chart in 3D.
      • Legend/Slider options – Select the check boxes to specify whether to include a legend and slider control with the chart.
      • Enable user commands – Select the check boxes to specify the chart options that are available to users when the chart displays in the Report Viewer. You can enable users to switch between 2D and 3D charts, maximize the chart size in the window, show detailed data in an embedded chart, and save the chart as a .png file.
  5. In the Data pane, specify which columns to include in the chart by dragging and dropping columns from the Available columns list to the drop zone.
  6. In the drop zone, click the Gear icon to set column-specific format settings on the Data settings form.
  7. To preview the chart, save your changes and run the report.
Tip: To preview a chart while you are designing it, use the Chart Editor from the Report Editor.