Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hide Item in a Legend based on conditions Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 13, 2013 2:03 PM
Points: 5, Visits: 85
Hello,

I have a problem related to the legend you can make use of in an SSRS report.

I have a stacked bar diagram in my report, let us call the groups series for Category. The bar chart will display as following:

Category A

Category B

Category C

Category D

...

I have different filters in this report which will only display two categories sometimes, e.g. Cat. A and Cat B. The problem is that the legend still will display all categories even if it is not displayed in the bar chart due to certain conditions made by the users.

I have tried a lot now but without any result. How can i display only Categories in the legend that only exists in the bar?

BR,

Nicklas


Post #1463082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse