Friday, March 9, 2012

Matrix - Row total @ the end.

Hi All,
I have a Matrix Report
Facility
HName-1 HName-2 HName-3
AA 100 150 200
BB 175 25 100
CC 100 100 200
DD 200 300 500
I need the row total something like this
Facility
HName-1 HName-2 HName-3
Total
AA 100 150 200
450
BB 175 25 100
400
CC 100 100 200
400
DD 200 300 500
1000
But when I say add Subtotal on clicking the column header it gices me the
subtotal for each row, but I need to total at the end with the total of all
the rows, HName-1,-2,-2 are dynamic columns
How do I do this..
Thanks IN ADVANCE
Balaji
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1**Sorry the display is wrong in the message the TOTAL sholud come at the end
after HName-4 **
BALAJI K wrote:
>Hi All,
>I have a Matrix Report
>
>Facility
> HName-1 HName-2 HName-3
>AA 100 150 200
>BB 175 25 100
>CC 100 100 200
>DD 200 300 500
>I need the row total something like this
>Facility
> HName-1 HName-2 HName-3
>Total
>AA 100 150 200
>450
>BB 175 25 100
>400
>CC 100 100 200
>400
>DD 200 300 500
>1000
>But when I say add Subtotal on clicking the column header it gices me the
>subtotal for each row, but I need to total at the end with the total of all
>the rows, HName-1,-2,-2 are dynamic columns
>How do I do this..
>Thanks IN ADVANCE
>Balaji
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1

No comments:

Post a Comment