Comments by Member 10989312 (Top 16 by date)

i am not getting any error... in the button click event after print code i am exporting to pdf, and the pdf file is storing on d:\pdf folder successfully.



protected void BtnApprove_Click(object sender, EventArgs e)
{
ReportDocument cryPrntRpt;
cryPrntRpt = new ReportDocument();
cryPrntRpt.Load(Server.MapPath("~\\CrReports\\CrPrintReport.rpt"));
cryPrntRpt.SetDatabaseLogon("UNM", "PWD", @"SRVNM", "MYDB");

cryPrntRpt.PrintToPrinter(1, false, 0, 0);


try
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
cryPrntRpt.PrintToPrinter(1, false, 0, 0);
CrDiskFileDestinationOptions.DiskFileName = "D:\\PDF\\" + Regno.ToString() + ".PDF";
CrExportOptions = cryPrntRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cryPrntRpt.Export();
}
catch (Exception ex)
{
//Message(ex.ToString());
}
con.Close();
}

i tried with the above code, problem not sloved...i am not getting any error also...

Report is showing on pageload and it is also exporting to pdf, after displaying the report on button click event (Approve Button) i want to take printout.


protected void Page_Load(object sender, EventArgs e)
{


ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = "SRVNM";
myConnectionInfo.DatabaseName = "MYDB";
myConnectionInfo.UserID = "UNM";
myConnectionInfo.Password = "PWD";
setDBLOGONforREPORT(myConnectionInfo);
}

private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
{
TableLogOnInfos mytableloginfos = new TableLogOnInfos();
mytableloginfos = CrystalReportViewer1.LogOnInfo;
foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
{
myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
}
//ReportDocument cryPrntRpt;
cryPrntRpt = new ReportDocument();
cryPrntRpt.Load(Server.MapPath("~\\CrReports\\CrPrintReport.rpt"));
cryPrntRpt.SetDatabaseLogon("UNM", "PWD", @"SRVNM", "MYDB");



}

Oh.... Very Very Thanx Mr.Richard its working. I added the FileStream in Using block. its working.

I am very sorry. I dnt have much knowledge in asp.net. In processExplorer i found that
Process: w3wp.exe
PID : 5168
Type : File
Name : C:\Mypdf\CC35.Pdf

After memoryStream.Close(); and before sending the mail i am using the below code for saving pdf file in my local systme.

var output = new FileStream(Path.Combine("c:\\myPDF\\", "CC" + result + ".pdf"), FileMode.Create);
var writer1 = PdfWriter.GetInstance(document, output);

i am not getting any error in my code. In email also i can open the attachment but the same file is stored on my local drive(C:\Mypdf) folder. When i try to open the pdf file from my local drive folder i am getting the error.

Yap.. I tried, now i am getting There was an error opening this document. This file is already open or in use by another application

when i open the pdf file i am getting "Adobe Reader could not open 'CC21.PDF' because it is either not a supported file type of because the file has been damaged(for example, it was sent as an email attachment and was't correctly decoded).

The email is sent successfully with pdf attachment file but i am not able to store it in my local system folder.

var output = new FileStream(Path.Combine("c:\\myPDF\\", "CC" + result + ".pdf"), FileMode.Create);
var writer1 = PdfWriter.GetInstance(document, output);

Dear Afzaal Thanx for your reply. The pdf file is stored in C:\MyPdf folder but not able to open.