Hiding Matrix column data but still have totals displaying.

Hi,
I'm working on a matrix report with salary information. One of my
requirements is to have the sub total display but not the detail
within the report. Is this possible? "Here is an example: This "-"
is showing hidden salary information.
December January
HOURS TOTAL HOURS TOTAL
Employee A 5 - 4 -
Employee B 5 - 4 -
TOTAL $500 $450On Dec 18, 1:45 pm, michael h <mikej...@.gmail.com> wrote:
> Hi,
> I'm working on a matrix report with salary information. One of my
> requirements is to have the sub total display but not the detail
> within the report. Is this possible? "Here is an example: This "-"
> is showing hidden salary information.
> December January
> HOURS TOTAL HOURS TOTAL
> Employee A 5 - 4 -
> Employee B 5 - 4 -
> TOTAL $500 $450
Use the InScope() function in your Details Expression. Basically, the
InScope("groupName") returns True when the Details section is
contained in the named group. If your use the name of the Row Group,
then you will be InScope = True when the report is rendering the rows,
and InScope = False when the report is rendering the totals.
Use an Expression like:
= IIF( InScope( "matrix1_Employees"), "-", Sum( Fields!
Salary.Value ) )
-- Scott