Thanks for checking. I ended up creating a summary table in sql and will populate summary data there for calculations and then report.

I appreciate the time and effort.

Excuse my ignorance, but does this work in SQL 2005? If so how do i add another line in my matrix below the total line to to the calcualtions.

Thanks...

I have tried that but a matrix doesn't allow it. I get the following error message - "Report item expressions can only refer to to other report items within...

Thanks for the reply. A subscription is not an option in this case because I need the report run on demand with various user parameters.

I got it to work. Thanks to all for the advice.