HIding a Table

Question

I have one DataSet DS_1 which returns a list of Userid.

I am pasing a userid from parameter(userid_1) to run the report.

My requrement is i want to hide a Table if my passing parameter(userid_1) is not in the list of Userids from DS_1.

How can i achive this??

Answer 1

hide the table if no rows returned:

http://stackoverflow.com/questions/514043/set-a-tables-visibility-to-false-when-it-has-no-rows-in-reporting-services

=CountRow()=0 for hidden expression.

Regards,Ram.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Answer 2

Hi,

use below expression in table Visibility

=iif(Parameters!ReportParameter1.Value=Fields!id.Value,false,true)

then You can do this.

---

Mark this as answer if this post helps you.