locked
Age range in pie chart RRS feed

  • Question

  • User-1338140908 posted

    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.

    Saturday, July 27, 2013 10:47 PM

Answers

  • User-734925760 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 2, 2013 4:23 AM

All replies

  • User-734925760 posted

    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

    Monday, July 29, 2013 6:23 AM
  • User-1338140908 posted
    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
    Monday, July 29, 2013 11:39 AM
  • User-734925760 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 2, 2013 4:23 AM
  • User-1338140908 posted
    Hi Michelle, Thanks so much
    Saturday, August 3, 2013 3:30 AM