I have a report that consists of a single table that has a detail row
and two levels of grouping. Each group contains a SUM formula to
aggregate a single column in the table.

When this report is rendered to Excel the sum is replaced with the
result of the formula. Is there any trick to get Reporting Services to
have the formula instead of the result?

Thanks
Phill

Sorry also should have added that this is for SQL 2000 RS SP2

Thanks
Phill