Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Expression to show or hide the tablix based on filter id Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 7:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:06 PM
Points: 55, Visits: 109
Hello,
I have a tablix and I filtered with schooltype value as 2

In my dataset if schooltype value is 1 it goes to first tablix if schooltype value is 2 it comes to second tablix

If the give parameters for System as 'ALL' I will get all the scholltypes with 1 and 2 that is fine.
IF I give only particular system that is 731 in my dataset the value for school type is only 1 so it fills first tablix coming to the second tablix I want to hide it when there is no data in database with the schooltype value 2

how to show or hide the second table here? I tried this expression its not working

=iif(Fields!SchoolType.Value >2, true, false)
Post #1564259
Posted Wednesday, April 23, 2014 7:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:33 PM
Points: 286, Visits: 623
Try this expression in the Tablix Visibility tab:

=CountRows() = 0

Post #1564264
Posted Wednesday, April 23, 2014 10:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 2, 2014 1:06 PM
Points: 55, Visits: 109
yeah,thank you.it got worked.

Post #1564386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse