Crystal report printing problem

Question

Hello; I have a problem. When I am trying to print crystal report on clicking Print tab of crystal report. It don't print report, It ask me to export report in pdf. Please help me... Its really urgent...

Ankur Mistry · Answer

Where you attached your code? I got only error.zip file. can you share again

Ankit Shukla · Answer

Sir, Have you checked my error page, Which I have attached? And I think its not code problem.. It is something else.

Ankit Shukla · Answer

OK Sir, I am trying and give you feedback soon. Thanks for your appreciation..

Ankur Mistry · Answer

Ankit, Please try below code [1] first connect your report with data source using below method. protected void setDbInfo(ReportDocument rpt, string ServerName, string DatabaseName, string UserName, string Password) { TableLogOnInfo logoninfo = new TableLogOnInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table t in rpt.Database.Tables) { logoninfo = t.LogOnInfo; logoninfo.ReportName = rpt.Name; logoninfo.ConnectionInfo.ServerName = ServerName; logoninfo.ConnectionInfo.DatabaseName = DatabaseName; logoninfo.ConnectionInfo.UserID = UserName; logoninfo.ConnectionInfo.Password = Password; logoninfo.TableName = t.Name; t.ApplyLogOnInfo(logoninfo); t.Location = t.Name; } } Now write this code on button click or page load. protected void btnpdf_Click(object sender, ImageClickEventArgs e) { //////For PDF added -start string fname = DateTime.Now.ToString("yyyyMMddHHmmss").ToString() + "TimeSheetByProject_admin" + ".xls"; //Create instance for crystal report Export option class ExportOptions exprtopt = default(ExportOptions); //create instance for destination option - This one is used to set path of your pdf file save DiskFileDestinationOptions destiopt = new DiskFileDestinationOptions(); //Bind data in the crystal report first before export cystal report to PDF ReportDocument RptDoc = new ReportDocument(); //Map your crystal report path RptDoc.Load(Server.MapPath("~/Reports/TimeSheetByProject.rpt")); //////////Set your crystal report datasource as dt ////////RptDoc.SetDataSource(dt); setDbInfo(RptDoc, DataHelper.V_DSN, DataHelper.V_DB, DataHelper.V_DBUserID, DataHelper.V_DBPwd); RptDoc.DataDefinition.FormulaFields["ProjectCode"].Text = "'" + ddlClientName.Value + "'"; RptDoc.DataDefinition.FormulaFields["ToDate"].Text = "'" + dtPickerViewreportTo.Value.ToString() + "'"; RptDoc.DataDefinition.FormulaFields["FromDate"].Text = "'" + dtPickerViewReportFrom.Value.ToString() + "'"; RptDoc.DataDefinition.FormulaFields["DD1"].Text = "'" + dtPickerViewReportFrom.Date.Day + "'"; RptDoc.DataDefinition.FormulaFields["DD2"].Text = "'" + dtPickerViewreportTo.Date.Day + "'"; RptDoc.DataDefinition.FormulaFields["MM1"].Text = "'" + dtPickerViewReportFrom.Date.Month + "'"; RptDoc.DataDefinition.FormulaFields["MM2"].Text = "'" + dtPickerViewreportTo.Date.Month + "'"; RptDoc.DataDefinition.FormulaFields["YY1"].Text = "'" + dtPickerViewReportFrom.Date.Year + "'"; RptDoc.DataDefinition.FormulaFields["YY2"].Text = "'" + dtPickerViewreportTo.Date.Year + "'"; //Get path and assign into destination DiskFileName destiopt.DiskFileName = Server.MapPath(fname); exprtopt = RptDoc.ExportOptions; exprtopt.ExportDestinationType = ExportDestinationType.DiskFile; //use PortableDocFormat for PDF data // exprtopt.ExportFormatType = ExportFormatType.PortableDocFormat; exprtopt.ExportFormatType = ExportFormatType.ExcelRecord; exprtopt.DestinationOptions = destiopt; //finally export your report document RptDoc.Export(); //To open your PDF after save it from crystal report string Path = Server.MapPath(fname); FileInfo file = new FileInfo(Path); Response.ClearContent(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); // Response.ContentType = "application/pdf"; Response.ContentType = "application/xls"; Response.TransmitFile(file.FullName); Response.Flush(); System.IO.File.Delete(file.FullName); RptDoc.Dispose(); RptDoc.Close(); RptDoc = null; ////End }

Ankit Shukla · Answer

Hello Manas Sir, I think your code is for Windows Application. Please help..

Ankit Shukla · Answer

Hello Manas Sir, I am trying but In web, their is no any method name "printreport()".

Ankur Mistry · Answer

protected void setDbInfo(ReportDocument rpt, string ServerName, string DatabaseName, string UserName, string Password) { TableLogOnInfo logoninfo = new TableLogOnInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table t in rpt.Database.Tables) { logoninfo = t.LogOnInfo; logoninfo.ReportName = rpt.Name; logoninfo.ConnectionInfo.ServerName = ServerName; logoninfo.ConnectionInfo.DatabaseName = DatabaseName; logoninfo.ConnectionInfo.UserID = UserName; logoninfo.ConnectionInfo.Password = Password; logoninfo.TableName = t.Name; t.ApplyLogOnInfo(logoninfo); t.Location = t.Name; } } protected void btnpdf_Click(object sender, ImageClickEventArgs e) { //////For PDF added -start string fname = DateTime.Now.ToString("yyyyMMddHHmmss").ToString() + "TimeSheetByProject_admin" + ".xls"; //Create instance for crystal report Export option class ExportOptions exprtopt = default(ExportOptions); //create instance for destination option - This one is used to set path of your pdf file save DiskFileDestinationOptions destiopt = new DiskFileDestinationOptions(); //Bind data in the crystal report first before export cystal report to PDF ReportDocument RptDoc = new ReportDocument(); //Map your crystal report path RptDoc.Load(Server.MapPath("~/Reports/TimeSheetByProject.rpt")); //////////Set your crystal report datasource as dt ////////RptDoc.SetDataSource(dt); setDbInfo(RptDoc, DataHelper.V_DSN, DataHelper.V_DB, DataHelper.V_DBUserID, DataHelper.V_DBPwd); RptDoc.DataDefinition.FormulaFields["ProjectCode"].Text = "'" + ddlClientName.Value + "'"; RptDoc.DataDefinition.FormulaFields["ToDate"].Text = "'" + dtPickerViewreportTo.Value.ToString() + "'"; RptDoc.DataDefinition.FormulaFields["FromDate"].Text = "'" + dtPickerViewReportFrom.Value.ToString() + "'"; RptDoc.DataDefinition.FormulaFields["DD1"].Text = "'" + dtPickerViewReportFrom.Date.Day + "'"; RptDoc.DataDefinition.FormulaFields["DD2"].Text = "'" + dtPickerViewreportTo.Date.Day + "'"; RptDoc.DataDefinition.FormulaFields["MM1"].Text = "'" + dtPickerViewReportFrom.Date.Month + "'"; RptDoc.DataDefinition.FormulaFields["MM2"].Text = "'" + dtPickerViewreportTo.Date.Month + "'"; RptDoc.DataDefinition.FormulaFields["YY1"].Text = "'" + dtPickerViewReportFrom.Date.Year + "'"; RptDoc.DataDefinition.FormulaFields["YY2"].Text = "'" + dtPickerViewreportTo.Date.Year + "'"; //Get path and assign into destination DiskFileName destiopt.DiskFileName = Server.MapPath(fname); exprtopt = RptDoc.ExportOptions; exprtopt.ExportDestinationType = ExportDestinationType.DiskFile; //use PortableDocFormat for PDF data // exprtopt.ExportFormatType = ExportFormatType.PortableDocFormat; exprtopt.ExportFormatType = ExportFormatType.ExcelRecord; exprtopt.DestinationOptions = destiopt; //finally export your report document RptDoc.Export(); //To open your PDF after save it from crystal report string Path = Server.MapPath(fname); FileInfo file = new FileInfo(Path); Response.ClearContent(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); // Response.ContentType = "application/pdf"; Response.ContentType = "application/xls"; Response.TransmitFile(file.FullName); Response.Flush(); System.IO.File.Delete(file.FullName); RptDoc.Dispose(); RptDoc.Close(); RptDoc = null; ////End }

Manas Mohapatra · Answer

Hi Ankit, Did you try with my previous answers

Ankit Shukla · Answer

Hello Sir, I am using this code: try { // string jobid = Session["jobid"].ToString(); Class.ds2.WriteXmlSchema(Server.MapPath("~/Report/certificateIs.xml")); ReportDocument crt = new ReportDocument(); crt.Load(Server.MapPath("~/Report/Certificate.rpt")); crt.SetDataSource(Class.ds2); CrystalReportViewer1.ReportSource = crt; CrystalReportViewer1.RefreshReport(); } catch (SqlException ex) { }

Manas Mohapatra · Answer

Please go through below link that might help you: http://www.aspsnippets.com/Articles/Print-Crystal-Report-on-Client-Side-on-Button-Click-using-JavaScript-in-ASPNet.aspx or do it explicitly on ASP.NET button click: ReportDocument oDocument = new ReportDocument(); oDocument.Load(Application.StartupPath + "//ReportPath//ReportName.rpt"); oDocument.SetDataSource(new DataSet()); // Added report data as dataset. crviewer.ReportSource = oDocument; crviewer.PrintReport();

Ankur Mistry · Answer

You have to manage it through your code, can you pls share some more details.