SSRS Report hide tablix

(0) Share

Report

Posted on by Community Member

I do have multiple tablix on my SSRS Report and on special conditions I want to hide one of it. Therefore I add an Expression in the tablix properties "Show or hide.."

this Expression Looks like:

=iif(Fields!SalesOriginId.Value = "01" And Fields!SalesPoolId.Value = "05" And CountRows("WMSPickingList_TransportTmp") > 0, false, true)

So the Tablix should be hidden if the SalesOriginId != "01" AND the SalesPoolId != "05" AND if there are no rows/records in the table the tablix belongs to (WMSPickingList_TransportTmp)

In our case the tablix is shown anytime even if the it should be hidden

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

!=(X++) is represented as <> (in VB)

SSRS makes use of VB

Fix you code and retry. If that does not works, you may give another try by replacing position of false, true

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried different expression (as well the reversed one you mentioned with <> and false, true replaced) but no Chance...the tablix is still there even if empty

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Did you try a simple expresion like =iif(CountRows() > 0, false, true)

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

where are you putting this code? Tablix visible property or somewhere else?

Was this reply helpful? Yes No
Suggested answer

Johnkrish 781 on at

Like (0)

Report

Hi ChrisBERN,

in your expression you have to put open and close braces for each condition. so try like this

=iif((Fields!SalesOriginId.Value = "01") And (Fields!SalesPoolId.Value = "05") And

(CountRows("WMSPickingList_TransportTmp") > 0), false, true)

like this i've done it for some requirement and it is working properly

=iif((Fields!ItemId.Value="JK-K001") And (Sum(Fields!Ordered.Value)=20),true,false)

Regards,

Johnkrish

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

msdn.microsoft.com/.../dd220590.aspx

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi all I had to split my Expression. so now it works

Was this reply helpful? Yes No