Crystal report printing problem

Ankit Shukla

10y1.2k.NET

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...

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankur Mistry10y ago
Where you attached your code? I got only error.zip file.
can you share again
Ankit Shukla10y ago
Sir, Have you checked my error page, Which I have attached? And I think its not code problem.. It is something else.
Ankit Shukla10y ago
OK Sir, I am trying and give you feedback soon. Thanks for your appreciation..
Ankur Mistry10y ago
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 Shukla10y ago
Hello Manas Sir,

I think your code is for Windows Application. Please help..
Ankit Shukla10y ago
Hello Manas Sir, I am trying but In web, their is no any method name "printreport()".
Ankur Mistry10y ago
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 Mohapatra10y ago
Hi Ankit,

Did you try with my previous answers
Ankit Shukla10y ago
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 Mohapatra10y ago
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 Mistry10y ago
You have to manage it through your code, can you pls share some more details.