export as a pdf file using crystal report

Question

I have code sample here, I can save as a PDF file directly but what I want to do is to show client first pdf file, and allow users to save it. How do I achieve this?

ReportDocument rpt = new ReportDocument();
rpt.Load(@"C:\CrystalReport2.rpt");

rpt.SetDataSource(datatablesource);

ExportOptions rptExportOption;
DiskFileDestinationOptions rptFileDestOption = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions rptFormatOption = new PdfRtfWordFormatOptions();
string reportFileName = @"C:\SampleReport.pdf";
rptFileDestOption.DiskFileName = reportFileName;
rptExportOption = rpt.ExportOptions;
{
    rptExportOption.ExportDestinationType = ExportDestinationType.DiskFile;
    //if we want to generate the report as PDF, change the ExportFormatType as "ExportFormatType.PortableDocFormat"
    //if we want to generate the report as Excel, change the ExportFormatType as "ExportFormatType.Excel"
    rptExportOption.ExportFormatType = ExportFormatType.PortableDocFormat;
    rptExportOption.ExportDestinationOptions = rptFileDestOption;
    rptExportOption.ExportFormatOptions = rptFormatOption;
}

rpt.Export();

You will need to open the file in a PDF reader. This will allow the user to save it were he wants. — HelloW, Jun 13 '13 at 19:00
Have you looked at the `CrystalReportViewer` control? http://msdn.microsoft.com/en-us/library/aa665753%28v=vs.71%29.aspx — gwin003, Jun 13 '13 at 19:00

score 10 · Answer 1 · edited Feb 06 '18 at 09:35

10

Here is my code:

dbObj = new ConnectDB();
query = "SELECT Student.*, School.*FROM Student where admissionnumber = '" + reg_number + "'";
DataSet ds = dbObj.Fetch_Data(query, "DataView");
ReportDocument rd;
rd = new ReportDocument();
rd.Load(Application.StartupPath + "\\StudentReg.rpt");
//rd.Load("StudentReg.rpt");
rd.SetDataSource(ds);
crv.ReportSource = rd;
crv.Refresh();
if(File.Exists(@"D:\" + reg_number + ".pdf"))
    File.Delete(@"D:\" + reg_number + ".pdf");
rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @"D:\" + reg_number + ".pdf");

edited Feb 06 '18 at 09:35

imsome1

1,182
4
22
37

answered Mar 23 '14 at 18:12

DareDevil

5,249
6
50
88

How about map objects ? they are not displayed in the pdf – Bilel Chaouadi Mar 13 '19 at 17:30

score 3 · Accepted Answer · edited Feb 06 '18 at 09:35

3

ExportOptions CrExportOptions ;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = "C:\\SampleReport.pdf";
CrExportOptions = doc.ExportOptions;
{
    CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
    CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
    CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
    CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
doc.Export();

Code like this...........

edited Feb 06 '18 at 09:35

imsome1

1,182
4
22
37

answered Jun 14 '13 at 03:54

Chetan Sanghani

2,058
2
21
36

What where the usings you used for this? – apereira Oct 16 '17 at 19:16
this creates the same pdf in the startup directory too. can that be deleted? – Yasiru Nayanajith Feb 05 '20 at 09:20

export as a pdf file using crystal report

2 Answers2

Linked