How to Hide one column in a matrix total column

  • I've got a matrix in a Reporting Services report. The far right column is a "Totals" column that sums more than one column (for example, two of them are Hours and Wages.) The totals column gives me sums of the hours and wages for several paytypes.

    The problem is I need to display only one of the columns (Wages) that is being totaled and not show the totaled Hours column. Is this even possible? I've can do a screen shot that would be worth a thousand words but I'm not sure that I can add a graphic to my post.

    Any help would be greatly appreciated!

    Bob

  • This was removed by the editor as SPAM

  • I din't know if this will help but you could try hiding the column the hours are in by conditionally hiding the group that the hours column is in.

    ie right click the group that contains the hours column and select 'edit group' the select visibility, the put something like the following in the expression field...

    =IIF(Fields![yourfield].value="Hours", False, True)

    Hope this helps a little.

     

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

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