crystalreportviwer
i want to get data from two tables for designing a crystal report...i made a sp by using inner join.but but i don't know how to write code in crystal report viewer page load....means not getting parameters in control...in c# sql 2005
Ravi KumarPosted Aug 16, 2014, 3:31 AM
try the fallowing
DataTable dt = new DataTable();
ReportDocument MedicalReport = new ReportDocument();
SqlDataAdapter da1 = new SqlDataAdapter("ProcedureName", con);
da1.SelectCommand.CommandType = CommandType.StoredProcedure;
da1.SelectCommand.Parameters.AddWithValue("@SiteId", ddlSite.SelectedValue);
dt.Clear();
da1.Fill(dt);
if (dt.Rows.Count > 0)
{
MedicalReport.Load(Server.MapPath("ReportName"));
MedicalReport.SetDataSource(dt);
CrystalReportViewer1.ReportSource = MedicalReport;
CrystalReportViewer1.DataBind();
}