Total Columns

[goodspeed7]

I need a way for totaling columns. Currently i have I have data that looks like so

Customer   PaymentType    Amount
111         Credit        100.00
222         Account       100.00
333         Credit        100.00
444         Transfer      100.00

The report looks like this, How can i get the totals on the bottome????

Customer    Credit    Account    Transfer
111         100.00
222                   100.00
333         100.00
444                              100.00

TOTALS:???  200.00    100.00     100.00

Thanks in advance!

Bob

 

[mrdenny]

WITH ROLLUP

Check in books online.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[goodspeed7]

Yes that would be good if i was writing a stored procedure to do it, but i want to do it in RS after all parameters have filtered the data.