"BALAJI K via SQLMonster.com" <u5178@uwe> wrote in message
news:5556507f491a4@uwe...
> Hi All,
>
> I have a simple Matrix Report
>
> DC-1 DC-2
> AA 10 20
> BB 20 12
> CC 30 55
>
> When I add a subtotal to the report both (row and column) it result the
> total
> of the first row or a column, something like this
>
> DC-1 DC-2 Total
> AA 10 20 10
> BB 20 12 20
> CC 30 55 30
> Total 10 20 10
>
> How do i solve this
>
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1

Robert Bruckner [MSFT] wrote:
>It seems like the matrix cell contains an expression like =Fields!Abc.Value.
>Also, in report designer you should get a warning about a field used in a
>matrix cell without aggregate function.
>
>A matrix cell (and subtotal cell) will usually cover more than one data row
>(after grouping). Using an expression like =Fields!Abc.Value will however
>only return the first row (and this is what you see in the subtotal cells).
>You need to change the cell expression to e.g. =Sum(Fields!Abc.Value)
>Then, the subtotal cells will show the Sum of the values also.
>
>-- Robert
>
>> Hi All,
>>
>[quoted text clipped - 16 lines]
>>
>> How do i solve this