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 names, along with points' arguments and values) are stored in the same data table. Note that in this scenario, the view type, and certain other settings, will be the same for all series.
-
Create a new report.
-
Bind the report to DataSight data.
- Drop the Chart control from the Toolbox onto the report's Detail band.
- 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.
- To specify the data field which should provide data for the series names (so that a new series is created for each record in that data field), set the Series Data Member property value.
- Adjust the series template which is accessed via the chart's Series Template First, set the Argument Data Member (which specifies from where the data for points' arguments is obtained). Make sure that the Argument Scale Type property is set to an appropriate value. Otherwise (e.g. when your data is of the date-time type, but this property is set to Qualitative), the resulting Chart will be seriously affected, and incorrectly represent its underlying data.
- Specify the Value Data Members property, indicating the data field(s) from which the points' values are obtained. As with the argument, make sure to appropriately specify the Value Scale Type.
- At this point, the chart's data options are completely defined, so in this step some additional customisation capabilities are described.
- Adjust the Series Name Template. You can edit the name of a series by clicking on the series in the left panel, and adding a new name in the Name field under Options.
- Customise Axis Labels. To avoid overlapping axis labels, select an axis. Then click the Properties tab. In the Elements section, drop down the Label property. Then set Staggered property to Yes.
- It is possible to customise many other properties for the Chart.
- 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.
When creating a report with Report Designer, in which you have inserted a Chart control bound to the queried data, the Argument Scale cannot be changed from Qualitative to DateTime from within the Properties Tab. In order to make this change, the MONITORING_DATETIME field must be re-dropped into the Argument Type field from the Data tab on the designer.
|
See also:
- Report Designer User Interface
- Report Designer Controls
- Report Designer Bands
Related Articles
Customizing dynamic chart controls in Report Designer
Reported: June 13, 2017. Version(s) affected: DataSight 3.0 and above Issue: When creating a report with Report Designer, in which the user has inserted a Chart control bound to the queried data, the Argument Scale cannot be changed from Qualitative ...
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 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 ...
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 ...