Question

怎样给reportViewer报表组件指定数据源？

传过来一个dataset对象，怎样给这个组件？能有完整的代码最好。谢谢大家回答！ C#语言

Answer 1

// <summary>
/// 生成报表数据
/// </summary>
private void CreateReport()
{
string bgDate = txtBegin.Text.Trim().Replace("-", "");
string edDate = txtEnd.Text.Trim().Replace("-", "");

DataTable dt = OPReportBLL.GetClientTargetList(ddlYear.SelectedValue + ddlMonth.SelectedValue + ddlWeek.SelectedValue.Substring(0, 1));

this.RptView.LocalReport.ReportPath = "Report\\RptFile\\ADCClientTarget.rdlc";
this.RptView.LocalReport.DataSources.Clear();

this.RptView.LocalReport.DataSources.Add(new ReportDataSource("ADCClientTarget_ADCClientTarget", dt));
this.SetReportParameters(this.RptView.LocalReport);

this.RptView.DataBind();
}
/// <summary>
/// 设置报表参数
/// </summary>
private void SetReportParameters(Report localReport)
{
ReportParameter[] parameters = new ReportParameter[1];
parameters[0] = new ReportParameter("time", "统计区间：" + txtBegin.Text + "至" + txtEnd.Text);
localReport.SetParameters(parameters);
}

Answer 2

DataSet ds = SQLHelper.Query("SELECT * FROM TABLE");
CrystalReportSource1.ReportDocument.Load(Server.MapPath("01.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);

CrystalReportSource1.DataBind();

CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();