Click here to Skip to main content
15,884,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
i am stuck in crystal report from many days i tried my code its giving me error some time its not displaying on client side , some time its not printing properly..
\
can any one give me the code to search crystal report and print with button click event using c#
/
i want to search report with id and print that report please help
Posted

 
Share this answer
 
v2
Please refer the You tube video for the best demonstration on how to set report and design .


A demo vodeo file on crystal report

For your code assistance please post it here or the error you are getting while deploying on Client machine.

Thanks
 
Share this answer
 
v2
C#
CrystalReport1 objCrustalReport = new CrystalReport1();
this.crystalReportsViewer1.ReportSource = objCrustalReport;
 
Share this answer
 
v3
Comments
Mohammed Abdul Muqeet 21-Jan-13 3:59am    
can you give me the full code

i am using this code its not displaying report on client system
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
SqlDataAdapter da = null;
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();

con.Open();


SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions WHERE idcount = @idcount ");

cmd.Connection = con;
cmd.Parameters.Add("@idcount", SqlDbType.Decimal).Value = TextBox1.Text;


da = new SqlDataAdapter(cmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{

ReportDocument Report = new ReportDocument();
Report.Load(Server.MapPath("~/CrystalReport.rpt"));
Report.SetDataSource(dt);
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
Report.SetDatabaseLogon("sa", "123456789", @"TRAINING-ROOM-8", "newMreport");
CrystalReportViewer1.ReportSource = Report;
CrystalReportViewer1.DataBind();
CrTables = Report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}

con.Close();
}
and
giving me this error on server when i click for print

A StartDocPrinter call was not issued

protected void Print(object sender, EventArgs e)
{

ReportDocument Report = new ReportDocument();
Report.Load(Server.MapPath("~/CrystalReport.rpt"));
Report.Refresh();
Report.PrintToPrinter(1, true, 1, 1);
}

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900