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.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2008-04-21 : 07:32:42
|
| H, need help please!I have two tables on a reports, each having it's own dataset. I want to set the visibility of the table depending on the filter selection. So if the user selects: show open then show only the table with the open dataset. I don't now how to this using the expression in the visibility expression. Please Assist! Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-21 : 11:40:50
|
| Set the hidden property expression as folows:-IIF(Parameters!YourParameter.value="ShowOpen",False,True)I'm assuming the parameter will pass string value to report. |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2008-04-22 : 03:08:05
|
| Thank You very much for the help. The expression works: =IIF(Parameters!Status.Value="All",True,False)I'm really struggling with the expressions. Regards |
|
|
|
|
|
|
Table visiblity depending on filter selection