• Login

DataSoft Corporation

Use Charts to Visualize Data in Report Groups

This tutorial describes how to use charts to visualize data in each report group.

DSStudio Chart Groups Results

Group Report Data

Do the following to group data in a report:

  • Bind the report to the required database table (for instance, Products).
  • Drop the ProductName field from the Field List onto the report's Detail band.
  • DSStudio Chart Add Field
  • In the Group and Sort panel, click Add a Group and select group criteria (for example, the CategoryID field).
  • DSStudio Chart Grouping
  • Enable the Show Footer check box to add a Group Footer to the report.
  • Drop the Category ID field onto the Group Header to display group titles in the report.
  • DSStudio Chart Grouping

Create a Chart

Do the following to add a chart to the report:

  • Drop the Chart control from the Toolbox onto the Group Footer.The Chart Designer is invoked. If it is not, open the Toolbar's Chart Tools contextual tab and click the Run Designer button.
  • DSStudio Chart Designer
  • In the Chart Designer, click the plus button to add a new series and select a series view (for example, Bar).
  • Select the created series and switch to the Data tab.
  • On this tab, drop the Product Name field onto the Argument area and the Unit Price field onto the Value area.
  • Switch to the Properties tab and click the Data Filters property's ellipsis button.
  • In the Data Filter Collection Editor, click Add to create a new filter.
  • Only the Value Binding setting is taken into account when the Value and Value Binding properties are specified for a data filter.
  • Set the filter's Column Name and Value Binding properties to the CategoryID field that is used as group criteria in the report.

Switch to Print Preview to see the resulting report.

Friday, 28 December 2018 Posted in Charts in Reports