Age range in pie chart[Answered] RSS

• • Reply
  seyha_moth

  Member

  14 Points

  43 Posts

  Age range in pie chart

  Jul 27, 2013 10:47 PM|seyha_moth|LINK

  Dear sir/madam,

  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.

• • Reply
  Michelle Ge...

  All-Star

  18232 Points

  2199 Posts

  Re: Age range in pie chart

  Jul 29, 2013 06:23 AM|Michelle Ge - MSFT|LINK

  Hi,

  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

  http://bhushan.extreme-advice.com/pie-chart-report-in-ssrs/

  #Pie Chart Techniques

  http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_1884-Pie-Chart-Techniques.html

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!
• • Reply
  seyha_moth

  Member

  14 Points

  43 Posts

  Re: Age range in pie chart

  Jul 29, 2013 11:39 AM|seyha_moth|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
• • Reply
  Michelle Ge...

  All-Star

  18232 Points

  2199 Posts

  Re: Age range in pie chart

  Aug 02, 2013 04:23 AM|Michelle Ge - MSFT|LINK

  seyha_moth

  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

  Hi seyha,

  Hi,

  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:

  Age            Flag
  
  7              Flag1
  
  12             Flag1
  
  19             Flag2
  
  32             Flag3

  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
  
  From Table
  
  Group by Flag
  

  The SQL will display the data as the following:

  Flag      countNumber
  
  Flag1    2
  
  Flag2    1
  
  Flag3    1
  

  When we get the datasource, please set the chart by the following link.

  http://bhushan.extreme-advice.com/pie-chart-report-in-ssrs/

  Hope it’s useful for you.

  Best Regards,

  Michelle Ge

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!
• • Reply
  seyha_moth

  Member

  14 Points

  43 Posts

  Re: Age range in pie chart

  Aug 03, 2013 03:30 AM|seyha_moth|LINK

  Hi Michelle, Thanks so much