Export to Excel issue

[Former Member]

Hello,

I'm using CR 2008 with ASP.NET.

I have a problem with one report. When I export it to Excel - everything is OK. But if I export it to Excel Data-Only, the columns are messed up. The columns themselves are in the correct order, but the headers are unmatched and in the different order.

The only explanation to this I can think of is that this report has many formula fields, perhaps this affects export somehow.

Is there a way to fix this and restore the column - header association?

Thank you.

[abhilash_kumar]

Hi Peter,

Exporting to Excel is always tricky and you might not always get a .xls file that is aligned exactly as the report.

It doesn't really matter if it's a database field or a formula field, however what does matter is the size, alignment and the fields' placement on the grid.

Also, when you say the "headers are unmatched and in the different order", what is exactly happening?

Do a few headers take up more rows/columns than the others?

-Abhilash

[Former Member]

Thank you.

No, one header per column, this means something like this:

Header: C D A E B

Column: A B C D E

What is strange though that this happens only when I export to Excel Data-Only. The normal export works fine.

[abhilash_kumar]

Hi Peter,

Are you exporting this report to Excel (data only) from an application?

Do the headers align correctly when exported from Crystal Reports designer?

-Abhilash

[Former Member]

Hi Abhilash,

Yes, I'm exporting from an ASP.NET application.

When I export from the CR Designer the exactly same thing happens - the columns are in the same incorrect order.