Chart with Static Series

Chart with Static Series

This topic describes how to create a report with a Chart control bound to data, so that a particular series has its own data source, and other settings. You can add more than one series which can obtain their data from the same or different data sources if necessary.

  1. Create a new report.
  2. From the Control Toolbox, drop the Chart control onto the report's Detail band.
  3. To bind the Chart to a data source, click its Smart Tag, and in the invoked actions list, expand the Data Source drop-down selector and select the NewDataSet. Its Data Member property defines from which table or view of your dataset the chart obtains its data. The Data Adapter property is also auto-defined.
  4. Click the Chart's Smart Tag, and in the invoked actions list, click the .. link.
  5. In the invoked Series Collection Editor, create a series of the required view type (e.g. Bar).
  6. Switch to the Properties tab at the right of the editor's window, and assign the existing data set object to the Data Source property of the series. Assign the required data fields to the Argument Data Member and Value Data Member properties, which determine the coordinates for series points.
  7. In addition, you can filter the series data. To do this, click the ellipsis button for its Data Filters property, and in the invoked dialogue, create and adjust the filtering criteria.
  8. To save the changes and quit the dialogue, click Close.
  9. Back in the Series Collection Editor, click Copy, to create a similar series, but change its View to Point.
  10. To improve your Chart's appearance, you can make the following adjustments.

- Remove the Chart's legend, as it shows the same data for both series. To do this, click the Legend, and in the Property Grid, set its Visible property to No.

- Remove point labels from Series1. To do this, select the label and set its Visible property to No.

- Customise the appearance of the Series2 markers (e.g. replace the default circle with the upside-down triangle by the View.Point Marker Options.Kind property and set its Size to 12).

- Rotate the X-axis labels for better readability. To do this, select the AxisX item in the chart by mouse click, and adjust properties for its labels (via the Label property). For instance, if the Angle property is 20 and the Antialiasing property is set to Yes, the labels look neat.

  1. It is possible to customise many other properties for the Chart.
  2. Switch to the Preview Tab, and view the result.

Note

After these steps, the report's Data Source property must be set to None. Otherwise, the chart will be blank at the preview and repeated as many times as there are records in the data source.

 

    • Related Articles

    • Chart Series

      A chart series is the style (such as bar, points or line etc.) used to visualise data on the chart. Choosing a series for a chart will very much depend on your own requirements for the chart. There are occasions however, when due to the number of ...
    • Chart with Dynamic Series

      This topic describes how to create a report with a Chart control bound to data, so that all series are auto-created based on a common template, which specifies universal options for all series. This is possible when the data for all series (their ...
    • Empty level dropdown lists in chart series filters

      Reported: March 22, 2017. Version(s) affected: DataSight 3.0 and above Issue: Level dropdown lists appear empty when added to a chart series filter tab. Workaround: This issue is usually presented if the chart has been built by dragging and dropping ...
    • Chart Editor Sections

      Chart Section The Chart Section allows you to: Refine Chart display parameters including the type of chart and its display characteristics. Open the chart series window to apply functions and labels to the existing graphed data. Alter the chart type ...
    • Distributed Multiple Variable Chart

      Graphing multiple variables allows you to display large amounts of information for a given site within the one image. The following details one possible procedure for creating a multiple variable chart for a given time period, where the variables on ...