Last post Aug 03, 2013 03:30 AM by seyha_moth
Jul 27, 2013 10:47 PM|seyha_moth|LINK
I have problem in pie chart in reporting service. I want to create pie chart to show age range in pie chart as below
- 17- down
- 18 - 30
- 31 - 50
- 51- 80
- 81- 100.
Could you tell how can I design in reporting service with pie chart.
Thanks in advance.
Jul 29, 2013 06:23 AM|Michelle Ge - MSFT|LINK
Based on my understanding, we will create a PIE chart in SSRS.
1. Open your SSRS project and add a custom template.
2. Create a data source.
3. Create a dataset, it will provide the data to display in the PIE chart.
4. Insert a chart which type is required.
More information, please try to refer to the following links:
#Pie Chart Report in SSRS
#Pie Chart Techniques
Jul 29, 2013 11:39 AM|seyha_moth|LINK
Aug 02, 2013 04:23 AM|Michelle Ge - MSFT|LINK
Dear michelle, I know how to design the basic reporting service,but I have problem to design Age gaps in pie chart Do you have any method to solve this issue? Thanks
The following is my suggestion, hope it can help you.
1. Design the data table, the two fields must be contained: Age field, Flag field, for example:
When we insert the age information into the table, we should set the flag as the age range.
2. Make the chart’s datasoure
Select Flag, count(*) as countNumber
Group by Flag
The SQL will display the data as the following:
When we get the datasource, please set the chart by the following link.
Hope it’s useful for you.
Aug 03, 2013 03:30 AM|seyha_moth|LINK