Crystal Report To Excel Problem

[mitchbooks]

I have a .net application that uses Crystal Reports to display
reports. When a report is exported to Excel the number fields are
transposed to text in Excel requiring the users to format any number
columns.

Any idea on how I can get the report to retain it's datatype when
exporting to Excel?

Thanks
Mike

 

[Rich P]

Hi Mike,

Instead of exporting the data from the Crystal Report - try exporting
the data to Excel directly from the datasource of your report.

Here is a sample that used a webdatagrid to export directly to Excel

http://www.developersdex.com/vb/message.asp?p=1121&r=6137667

Rich