I have a sql report that runs on a SQL 2005 reporting server. The business requirement is that the excel formulas be downloaded when the user downloads the report in excel format. It is ok for the users to see the formula and I do not mind writing an ad-hoc report only for excel downloads. I got around the first hurdle by reading this post -
The problem that I am having is writing a formula using an aggregate function that sums up all the values in a column (the last row in the report should be Totals of its corresponding columns).
So if there are 10 rows, column 1 of Row 11 should be = sum(c1:c10)
All help is appreciated