I am facing problem in SSRS. Actually, I do have 3 Tablix in same report and want to hide 2 tablix based on Parameter value selected. I created parameter called Report and it having 3 values All, Emp with Service Hrs, Emp without Services hrs. Now what I am looking for if I select All then 2 tablix that belong to With Service Hrs and Without Service hrs should hide. similarlly for remaining 2 parameter as well.
I knew it is possible if you having 2 Tablix using IIf() but no idea on 3. If anyone knows then please give me ur feedback. Thanks in Advance.
