Post reply

Hide Sub total in matrix

  • September 24, 2009 at 4:30 pm

    #385431

    Hi

    How to hide total field when sub total is 0 ?

    Plaese help m eif any one knows ,I am trying from 1 day.

  • September 25, 2009 at 2:36 am

    #1058381

    If you want to hide the complete row, then conditionally set the visibility of that row using something like "iif(sum(datacolumn)=0,false,true) "

    If its just the 0 that you want to disappear, try this

  • September 27, 2009 at 1:23 pm

    #1058868

    Thanks for reply.And i am getting space after the matrix.

    Can you plaese tell me that how can i remove ?

    tahnks for help

  • September 28, 2009 at 12:41 am

    #1058911

    From your reply I gather that one or the other solution worked out for you.

    Make sure that the report area doesn't have a blank space below the matrix in design view.

  • September 28, 2009 at 8:49 am

    #1059029

    Hi, anitha.cherukuri.

    have you tried something like?

    =IIF(Inscope("group2") Or Inscope("group1") Or Inscope("group1"),False,IIF(Parameters!YourParameter.value="Your Visibility value",False,True)) ' in hidden property

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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