Hiding tables based on parameters SSRS 2008
-
Monday, January 14, 2013 7:03 AM
In a report I have made 3 tables-Location,Printer,User. And 3parameters-Location,Printer &User which will get values from their datasets.
What I want is If I select any location from the values displayed in location Parameter,then the Location table will be displayed.
ANd if I select a value of Printer from the values in Printer parameter then Printer Table will be displayed.
Same for user.
How do I hide and display these tables?
All Replies
-
Monday, January 14, 2013 7:38 AM
Hello
This can achieve based on the "Visibility" tab.
1. Rt. Click on Tablix properties .
2. Click on Visibility
3. Click on Show and hide button based on expression and put your expression like below change as per your requirement.
= IIf(Parameter!yourparameter.Value = "your condition" TRUE, FALSE)
for more detail see this link
http://www.codeproject.com/Tips/163576/Hide-Show-the-row-in-a-table-in-SSRS-based-on-para
blog:My Blog/
Hope this will help you !!!
Sanjeewan- Marked As Answer by Leeza Goyal Thursday, January 17, 2013 7:09 AM
- Unmarked As Answer by Leeza Goyal Thursday, January 17, 2013 7:10 AM
-
Monday, January 14, 2013 7:42 AM
Hello Sanjeewan,
But what to write in condition so as to achieve it?
Leeza
-
Monday, January 14, 2013 7:50 AM
Hello,
What is your parameter name and what is its value upon which you want to hide and show the table
See below :-
Yourparameter.Value =your parameter
= your parameter value on which you want show and hide
= IIf(Parameter!yourparameter.Value = "your condition" TRUE, FALSE)
1. Rt. Click on Tablix properties .
2. Click on Visibility
3. Click on Show and hide button based on expression
4. Click on Function i.e fx
and put your expression like below change as per your requirement.
= IIf(Parameter!yourparameter.Value = "your condition" TRUE, FALSE)
blog:My Blog/
Hope this will help you !!!
Sanjeewan- Marked As Answer by Leeza Goyal Thursday, January 17, 2013 7:09 AM
- Unmarked As Answer by Leeza Goyal Thursday, January 17, 2013 7:11 AM
-
Monday, January 14, 2013 11:49 AM
hi
use expression:
=iif(IsNothing(Parameters!YourParamName.Value),True,False)
or
=iif(Parameters!YourParamName.Value="",True,False)
Make sure you check "allow blank values" in your parameter configuration.
Please mark as answered or vote helpful if this post help resolved your issue. Thanks!
k r o o t z- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Tuesday, January 15, 2013 2:21 AM
- Marked As Answer by Leeza Goyal Thursday, January 17, 2013 7:11 AM
.png)
