Limiting Legend Items in a Pie Chart Using SSRS 2008 R2

Posted on 2012-08-30
Last Modified: 2012-08-31

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.
Question by:nkleewein
    LVL 22

    Accepted Solution

    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.

    Author Comment

    Awesome, thanks Nicobo. I'll import your rdl sample and take a look!

    Author Closing Comment

    The solution works perfectly for my situation! Thanks again.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now