I have written the following code to export crysal reports to excel. My problem is, when it exports number it adds the thousand seperator (,), but if I export the report from Crystal designer, it works fine. So I believe I am missing something in my code. Could some one help me with this? Any help is greatly appreciated.
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlBook As Workbook
Dim myReport1 As New ReportDocument
Dim reportPath1 As String = ""
reportPath1 = "C:\test\su.rpt"
myReport1 = New ReportDocument
myReport1.Load(reportPath1)
Dim tmpExcelFile As String = ""
tmpExcelFile = "C:\test\test.xls"
myReport1.ExportToDisk(ExportFormatType.Excel, tmpExcelFile)