Limiting Legend Items in a Pie Chart Using SSRS 2008 R2

Hi,

I have a pie chart displaying the top vendors for an agency, and I am trying to limit the legend for the chart to only the top 5 vendors, while still showing the stats for ALL vendors in the chart. Is this something that is possible to accomplish with SSRS?

Right now, if I limit the legend to the top 5 vendors, the pie chart only shows those top 5 vendors.

Any help would be greatly appreciated.
nkleeweinAsked:
Who is Participating?
 
Nico BontenbalConnect With a Mentor Commented:
Create 2 charts. One without a legend and without a filter. And one with a filter, a legend, and a  chart area of size 1. See the attached file to get the idea.
Pie.rdl
0
 
nkleeweinAuthor Commented:
Awesome, thanks Nicobo. I'll import your rdl sample and take a look!
0
 
nkleeweinAuthor Commented:
The solution works perfectly for my situation! Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.