export a report including summary to excel

[vasu1211]

My boss wants to export a report to an excel format. Now the report is grouped by customer and some of the fields in each group has been added up inside the report.
Now when i export this report to excel, the formatting goes wrong. The sums for each group are in adjacent fields

eg
Transport Amt
custa 54
custb 34
custc 46
SUM 134

Sum value comes up in the adjacent field in excel even though they are in the same column in a report.

How to rectify this? Also some of the reports cannot be exported at all because of large size. Any idea how to solve this.

Please help

 

[lameid]

Why export to Excel if there is analysis in the report?

I mean the only real reason to use Excel is to perform additonal analysis. I would either use Snapshot format to send reports or PDF if you want to take the time to get it working.

 

[SkipVought]

Hi,

My blood boils, I get cranky, I rant and rave, when I get a REPORT (repeating headings/footings, wrapped rows, subtotals, etc) imported into Excel that they want some data analysis performed.

What a WASTE!

SHOW ME THE SOURCE DATA!!!!

If you have the Report requirements, pull the data in a query in Excel, do the analysis/additional calculations in excel, and produce the report.

Skip,
[sub]
[red][/red]
[/sub]