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
 Development Tools
 Reporting Services Development
 Conditional Layout in RS

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2005-02-22 : 23:50:12
I have three tables ( let's say A, B, and C) in a report. I'd like to display these tables based on the report parameter which will be selected by an user.

For example,

If an user select a parameter 'HC', then dispaly table A and B

If an user select a parameter 'HB', then dispaly table A

If an user select a parameter 'HE', then dispaly table A, B, and C


I am not sure how to do this in RS



tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-23 : 12:36:50
You'll need to use the Visibility/hidden attribute for each of the tables.

Tara
Go to Top of Page

gcowhsu
Starting Member

38 Posts

Posted - 2005-02-23 : 14:24:25
Another way to do this is create 3 different reports and in the code check the parameter and call a different report for each parameter.
Go to Top of Page
   

- Advertisement -