Post reply

Hide columns expression

  • November 27, 2014 at 2:53 am

    #301451

    Hi I have problem with hide columns in table. In raport i have parametr where user can choose which columns must be visible and it works good. In column visibility i have expression: =IIF(InStr(JOIN(Parameters!POKAZ.Value,","),"ALCATEL")>0,False,True). Now i want to add to this expression another expression. User choose column "ALCATEL" column is visible in table, but iff value of the column "ALCATEL" is 0 or null make it invisible. How can i do this?

    Regards Kriss

  • November 27, 2014 at 8:48 pm

    #1761359

    I'm not sure what exactly you looking for..! but if you right click on table/matrix or F4 properties you can see property NoRows message , specify your own message, it will automatically hide columns when no data is available or not filtered. I hope this helps or let us know.. Thanks

  • November 28, 2014 at 1:48 am

    #1761386

    I change expression to: =SWITCH(sum(Fields!CARMEN.Value)=0,True,False,InStr(JOIN(Parameters!POKAZ.Value,","),"CARMEN")>0,False,True) and it works

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

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