Dynamic Column - Total - Using Matrix - Help Neede!

Hi All,
I have a report with Dynamic Column - achieved using Matrix
The Output is something like this
Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
AA 100 10 20
30
BB 200 20 15
30
CC 300 10 10
10
I need the total of static and dynmaic column for each column individually
Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
AA 100 10 20
30
BB 200 20 15
30
CC 300 10 10
10
Total 500 40
45 70
For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
display the total for dynamic columns
Thanks
Balaji
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1BALAJI K wrote:
>Hi All,
>I have a report with Dynamic Column - achieved using Matrix
>The Output is something like this
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>I need the total of static and dynmaic column for each column individually
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>Total 500 40
>45 70
>For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
>display the total for dynamic columns
>Thanks
>Balaji
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1|||BALAJI K wrote:
>Hi All,
>I have a report with Dynamic Column - achieved using Matrix
>The Output is something like this
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>I need the total of static and dynmaic column for each column individually
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20 30
>BB 200 20 15 30
>CC 300 10 10 10
>Total 500 40 45 70
>For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
>display the total for dynamic columns
>Thanks
>Balaji
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1