November 10, 2006 at 3:12 pm
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
November 13, 2006 at 8:00 am
This was removed by the editor as SPAM
February 14, 2007 at 2:03 pm
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