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
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 1, 2014 11:48 AM
Points: 80, Visits: 167
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:00 PM
Points: 341, Visits: 751
Try this expression in the Tablix Visibility tab:

=CountRows() = 0

Post #1564264
Posted Wednesday, April 23, 2014 10:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 1, 2014 11:48 AM
Points: 80, Visits: 167
yeah,thank you.it got worked.

Post #1564386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse