Prev: Interesting IntelliSense behaviour with Webbrowser
Next: Substitute For Microsoft Script Control
From: mitchbooks on 7 Jul 2008 17:13
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
From: Rich P on 7 Jul 2008 17:34
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

*** Sent via Developersdex http://www.developersdex.com ***
 | 
Pages: 1
Prev: Interesting IntelliSense behaviour with Webbrowser
Next: Substitute For Microsoft Script Control