Post reply

Expression to show or hide the tablix based on filter id

  • April 23, 2014 at 7:26 am

    #288161

    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)

  • April 23, 2014 at 7:34 am

    #1708097

    Try this expression in the Tablix Visibility tab:

    =CountRows() = 0

  • April 23, 2014 at 10:54 am

    #1708200

    yeah,thank you.it got worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply