How to display Legend dynamically in SSRS reports

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

How to display Legend dynamically in SSRS reports

Author

Topic

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2012-09-18 : 05:25:44

Hi All,

I have created pie chart and ploted all my dataset columns on it.Below are the following columns
Completed
Item_ready
Cancelled
item_moved_to_DataStore
item_failed_to_mapped
item_awaiting_OD_Number
OD_Number_Recieved
Reissued
New
In_Progress
Error_Detected_by_User

for all coulmns legends are appearing with different colors .

I want to disply all legends dynamically .If any of the coloum doe not have value it should not be appeared in Legend list ...

For example
My three columns have values .Those are
Completed
Item_ready
Cancelled

and other don't have ....I just want to disply above three column color in Legend list not all...

Vijay is here to learn something from you guys.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources