Show/Hide multiple Tables based on Parameter value

Question

I'm trying to show table based on parameter inputs (2 parameters).

1)- if the first one is blank and second has the user input, it should display table 1

2)- if the second one is blank and first has the user input, it should display table 2

3)- if both parameter has value inserted by user , then it should display table 3

I get stuck in third condition (for table 3), where both parameter has values in it.

Expressions for these tables are (under visibility ):



Table 1: 

=Parameters!Store.Value<>"" And Parameters!Sku.Value=""

Table 2:

= Parameters!Store.Value="" And Parameters!Sku.Value<>""

Table 3:

= Parameters!Store.Value="" And Parameters!Sku.Value=""

Please let me know mistake in my expressions if any or suggest solution as Im new to SSRS.

Thanks.

---

ZK

Answer 1

Hi,

Select each Tablix one by one and choose on properties-> hidden -> then expression :

Table 1: 

=IIF(Parameters!Store.Value<>"" And Parameters!Sku.Value="", TRUE, FALSE )

Table 2:

= IIF(Parameters!Store.Value="" And Parameters!Sku.Value<>"", TRUE, FALSE ) 

Table 3:

= IIF(Parameters!Store.Value="" And Parameters!Sku.Value="", TRUE, FALSE)

Regards

http://simplesqlserver.wordpress.com

---

Dj's | Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

Answer 2

I'm still getting two tables get populated/shown after entering value for both parameters

---

ZK

Answer 3

I think there is problem with expression, not sure what could be..

---

ZK

Answer 4

Hi,

Are 2 tables showing no matter the combination? If param1 has a value and param2 does not what happens, vice-versa and what happens if both have a value?

Answer 5

Hi,

TRY this

Table 1: 

=IIF(Parameters!Store.Value<>"" And Parameters!Sku.Value="", FALSE , TRUE )

Table 2:

= IIF(Parameters!Store.Value="" And Parameters!Sku.Value<>"", FALSE  ,TRUE ) 

Table 3:

= IIF(Parameters!Store.Value<>"" And Parameters!Sku.Value<>"", FALSE , TRUE )

Regards

http://simplesqlserver.wordpress.com

---

Dj's | Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

Answer 6

This time it works like a magic, though bit slow while retrieving.

Thanks Djallal!

---

ZK