Skip to Content
0
Dec 28, 2011 at 09:09 PM

Exporting Crystal report into Excel with code

404 Views

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)