none
To collect small slices into a secondary, callout pie chart in SSRS 2005

Answers

  • Hello,

    Based on my research, the CollectedStyle property that collect small slices into one signal slice or a secondary, callout pie chart is available from Reporting Services 2008. So it is not supported in Reporting Services 2005.

    For example, you are using the query below to return the SECTION and DIVISION fields as the chart fields: SELECT SECTION , DIVISION FROM TEMP, and you want to collect small slice COUNT(DIVISION) smaller than 5 as the callout pie chart. To work around this issue, we can create two charts on the surface, one as the big and collected slices chart, another one as the secondary, callout pie chart. For more details, please refer to the following steps:

    1. We can use the query with some conditions like below to return the fields for the main chart:
      SELECT CASE
         WHEN COUNT(DIVISION) <= 5 THEN 'Other'
         WHEN COUNT(DIVISION) >5 THEN SECTION
         END  AS SECTION, COUNT(DIVISION) AS DIVISION
       FROM TEMP
      GROUP BY SECTION, DIVISION
    2. We can use the query like below to return the fields for the callout pie chart:
      SELECT CASE
            WHEN COUNT(DIVISION) <= 5 THEN SECTION
         END  AS SECTION, CASE
            WHEN COUNT(DIVISION) <=5 THEN COUNT( DIVISION)
         END  AS DIVISION
       FROM TEMP
      GROUP BY SECTION, DIVISION


    The following screenshot is for your reference:
     
    If there are any other questions, please feel free to ask.

    Regards,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Tuesday, August 26, 2014 10:32 AM
    Moderator