Multi Series ChartsLast Updated: 07/19/2016 Introduced in Verision: 3.2 |
This tutorial demonstrates how to add Multiple Series to the Chart views on the Report. Note: in order to add multiple series to the chart view, several Report Subtotals should be defined. Not any type of chart view can have multiple series. Multiple Series are available for: Areas, Bars, Bubbles, Columns, Dots, Lines and Stacked Bars. Multiple Series can be used on the chart views of the Report when we need to visually represent multiple pieces of data that is related to the single object from the Grouped column.
Example:
In this example we will Report against several tables from integrated database. We integrated with Northwind database and created relations between the tables to be able to include those tables as Data Sources in our Report.
Next, we navigate to the Designer Folder and click Create Report > Create Report from Folder Actions Panel.
In the resulting window we Name our Report and click Create to proceed to the Report Designer.
In the Report Designer we add Data Sources for our Report. We expand Data Sources > Common > North category and add dbo.Customers table.
Then, from Data Sources > Add Related Table we add dbo.Orders table as second Data Source for our Report.
In the same manner we add dbo.Order Details table as third Data Source for the Report.
Finally, we add last dbo.Products table to the Report.
Next, we add desirable Columns from our Data Source tables to populate our Report with data. Note: we should Group our Report by the columns. In this example we Group our Report by Company Name and Order Id because we want to visually represent Number of Orders and Average Unit Price per Company.
Then, in the Report settings we locate Results category and click Add New under Sub Totals text-box.
In the Add Sub Totals window we pick Order details Orderid Field and Aggregation Type Count. In this way Subtotal will count the Number of Orderid occurrences per Company. Click Ok to save and continue.
Next, we Add second Subtotal…
For the second Sub Total we pick Order details Unitprice Field with Average Aggregation type and 2 decimal places. This Subtotal will indicate an Average unit price per Order. Click Ok.
In the Report Designer we click Add [+] link on the Report Views Panel.
Then, we pick Bars type from Charts category.
In the Add Chart pop-up window we Name our View. Then, from the Field dropdown we select one of the Subtotals that we created previously for this Report.
Then, we click Add Series to make our Chart Multi Series.
From the Field dropdown we pick second Sub Total.
Finally, we click Add Chart…
The link to our Chart appears on the Views Panel in the Report Designer. We click it to change Data View to our Chart View.
Our Chart opens… We can confirm that for each Company there are two bars: Number of Orders and Average Unit Price.
