CODEWITHSUNDEEP
sql-server-2005reportingservicepie-chart
AGoodDisplayName
AGoodDisplayName

Reputation: 5653

Reporting Services Pie Chart

The pie chart is driving me nuts...Excuse me if I sound ignorant but I have figured out the other RS charts with relative ease, and this is the first time I have had to use the Reporting Services pie chart.

I have a dataset:

Columns:
ChildId int
AssessmentType varchar
Score int

All I want is to have a pie chart that displays the percent of the whole for each assessment type. So if I had 10 records returned with the following:

2 "THIS" Assessment Types
5 "THAT" Assessment Types
3 "THEOTHER" Assessment Types

I would want the pie chart to show that the "THIS" Assessment peice of the pie is 20%, the "THAT" is 50%, "THEOTHER" as 30%, but I cannot figure out how to set it up. Can any one help me out on this, or refer me somewhere. I have been looking for some time and can't find any pages that have helped me with this control.

Upvotes: 2

Views: 4134

Answers (1)

AGoodDisplayName
AGoodDisplayName

Reputation: 5653

I figured this out...To show the percentage:

  • Right click on the chart and click on properties.
  • Go the the Data table, select your "[Value]" and click edit.
  • Go to the Point Labels tab and check "Show point labels".
  • In the format code enter P

  • Edit the expression and calculate your percentage. In my example I would use the code below.

    =Count(Fields!ChildId.Value) / Count(Fields!Childid.Value, "MyDataset")

The problem I was having is that I was filtering the data set at the chart level with a filter expression. So when I was trying to calculate the percentage using the code below my numbers were getting thrown off. The filter is not applied the dataset count when retrieved like I was doing it. 

 Count(Fields!Childid.Value, "MyDataset")

Upvotes: 5

Related Questions