vb.net 2005 and crystal reports

[jassie]

I have the following questions to ask:
1. I would like to see code that runs a crystal report and exports the data to excel 2003.
2. I am setting up a Visual Basic.NET 2005 application where I will be creating a crystal report and exporting the data to Excel 2003. For each unique crystal report, I would like to export each report to a different tab (worksheet) on one excel workbook. I do not want each report to be on separate excel workbooks. Thus can you tell me how to accomplish this task?

[karun_happy]

Dim cryRpt As New ReportDocument
        cryRpt.Load("crpt_test.rpt")
        CrystalReportViewer1.ReportSource = cryRpt
        CrystalReportViewer1.Refresh()

you also need to import CrystalDecisions.CrystalReports.Engine

This will load your report in the form and CrystalReportViewer already has an option to export the report to excel format. You will see it when you run, it has other options is well like in pdf or doc or rtf format.