Printing crystal reports from asp.net

jbushman · January 18th, 2005, 06:43 PM

First off I know this topic has many posts and replies...none of them apply to me. My situation is this: I have an asp.net web site that generates crystal reports using stored procedures...this all works fine. I bought the book "Professional Crystal Reports for visual studio.net" by David Mcamis...followd the example on page 185 about exporting to pdf then printing...doesnt work in my application. I then downloaded the example code from this site and ran it...doesnt work, the error I receive is "Invalid File Name" the code trips on MyReport.export() in both applications...frustrating. I believe all permissions have been set correctly for ASP.NET, Admins, Users etc...I'm at a loss please help me. Im so close to getting this F%$&(ng project complete its insane

Vadivel · January 20th, 2005, 12:30 AM

Code:

string strFileName = "Test.pdf";
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath(@"CRPDF.rpt"));
DataSet TestDataSetPDF = GetDataSet(userName());
rptDoc.SetDataSource(TestDataSetPDF);
rptDoc.SetDatabaseLogon("sa","sa123");

ExportOptions exportOpts = new ExportOptions();
PdfRtfWordFormatOptions pdfopts = new PdfRtfWordFormatOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rptDoc.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.FormatOptions =  pdfopts;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = Server.MapPath(strFileName);
exportOpts.DestinationOptions = diskOpts;
rptDoc.Export ();
Response.Redirect (strFileName);

This is how i create a PDF file and show it on the browser. Hmm i haven't tried printing it on the fly without showing the PDF to the user.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com