Overview
Version
Report Server Version |
---|
11.0 |
Application Scenario
When standard bar charts cannot meet your specific needs for data presentation, you can use custom bar charts to customize multiple axis.
Chart Feature
Advantage: The high degree of flexibility and creativity of custom bar charts allow you to draw the viewer's attention through unique designs to better convey certain information.
Disadvantage: Designing and creating custom bar charts may cost more time and resources, and improper design may reduce the clarity and readability of data.
Example
Data Preparation
Choose File > New General Report in the upper left corner of the designer, and create a dataset ds1. The database query statement is as follows:
SELECT Category_Name, Inventory_Quantity, Order_Quantity, Reorder_Quantity FROM Product, Category
WHERE p.CategoryID = c.CategoryID AND Category_Name != 'Daily necessities'
ORDER BY Category_Name.
Chart Insertion
Merge required cells, click Insert Chart on the upper toolbar, and choose Bar Chart > Custom.
Chart Design
Select the chart, click the Cell Element icon on the right property panel, and set the properties (Type, Data, Style, and Special Effect) for the chart.
Chart Type
Select the cell where the chart is located and choose Cell Element > Type to view and select the chart type.
Data Binding
1. Select the chart and choose Cell Element > Data on the right property panel.
2. Bind the data in the Dataset. Select ds1 for Dataset, Category_Name for Category, Field Name for Series Name (Inventory_Quantity and Order_Quantity fields), and Sum for Summary.
Chart Style Setting
1. Select the chart, choose Cell Element > Style > Title and enter the text Custom Bar Chart.
2. When you select Custom Bar Chart, X Axis 2 will be added by default on the top of the chart. You can follow this default setting.
3. Follow the steps as shown below, so that the X Axis at the bottom corresponds to the value of Series 2 and the X Axis 2 at the top corresponds to the value of Series 1. Select No for the Stacked effect.
Effect Display
PC
Save the report and click Pagination Preview. The effect is same as that shown in section "Application Scenario".
Mobile Terminal
The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the display effect.
Template Download
For details, you can click to download the template Custom Bar Chart.cpt