Conditional Summary - Reporting Services 2005

[Zurich98]

GroupByCustomer
CustName Amt
John Doe $100
John Doe -$50
John Doe -$100
-----
Total JohnD -$50

Jane Doe -$50
Jane Doe $100
Jane Doe $50
----
Total JaneD $100


Foo Bar $250
Foo Bar -$150
Foo Bar -$200
-----
Total FooB -$100

Lisa Boyd $175
Lisa Boyd -$50
Lisa Boyd -$50
-----
Total LisaB $75


Grand Total Debit = $175
Credit = -$150

The report is grouped by customer. Each customer will have a debit and credit amounts. For the Grand Total, I would like to add those customers with credit amount to create a Credit grand total and those customer with debit amount to create the Debit grand total. How can I acomplish this in RS 2005? Any help/suggestion is greatly appreciated.

 

[rose4567]

How is your report structured? Are you using a table? I like tables for reports like this because when you set up a group based on customer you can sum group specific totals in the group footer and then for the grand totals you are looking for, just sum them in the table footer.