logo标签列表

在rdlc中调用钻取报表

c#rdlc
3
我有一个名为attendence.rdlc的报表，它需要三个参数：employeeId、monthId和year，用于生成员工每月的考勤状况。例如： enter image description here 当我点击“>>”按钮时，需要调用钻取（在我的情况下是同一份报表）报表，并增加月份和年份的参数。 enter image description here 如何在rdlc报表中创建钻取事件处理程序？
1个回答
3

我的问题已经解决了。在rdlc中，当有人调用goto_report/goto_url时，实际上是由钻取报表调用的。因此，如果我创建一个事件处理程序，显然要在postback url之外，例如：

 protected void Page_Load(object sender, EventArgs e)
 { 

 if (!IsPostBack)
    {
       //otherscode u need
       //now call report first time
      string path = HttpContext.Current.Server.MapPath(your report path);
      ReportViewer1.Reset(); //important
      ReportViewer1.ProcessingMode = ProcessingMode.Local;
      ReportViewer1.LocalReport.EnableHyperlinks = true;

      LocalReport objReport = ReportViewer1.LocalReport;
      objReport.DataSources.Clear();
      objReport.ReportPath = path;

      // Add Parameter if you need
      List<ReportParameter> parameters = new List<ReportParameter>();
      parameters.Add(new ReportParameter("parameterName", ParameterValue));
      ReportViewer1.LocalReport.SetParameters(parameters);
      ReportViewer1.ShowParameterPrompts = false;
      ReportViewer1.ShowPromptAreaButton = false;
      ReportViewer1.LocalReport.Refresh();

      //Add Datasourdce
      ReportDataSource reportDataSource = new ReportDataSource();
      reportDataSource.Name = "odsReportData";
      reportDataSource.Value = YourReportDataSourseValue;
      objReport.DataSources.Add(reportDataSource);
      objReport.Refresh();
    }

    ReportViewer1.Drillthrough += new DrillthroughEventHandler(DemoDrillthroughEventHandler);

    }







   public void DemoDrillthroughEventHandler(object sender, DrillthroughEventArgs e)
   {
  /*Collect report parameter from drillthrough report*/
    ReportParameterInfoCollection DrillThroughValues = e.Report.GetParameters();
    Type parameterName = Type.Parse(DrillThroughValues[1].Values[0].ToString());

  /*Bind data source with report*/
    LocalReport localReport = (LocalReport)e.Report;
    localReport.DataSources.Clear();
    localReport.DataSources.Add(new ReportDataSource("odsData", reportData));
    localReport.EnableHyperlinks = true;     

   /*Add parameter to the report if report have paramerter*/
    List<ReportParameter> parameters = new List<ReportParameter>();
    parameters.Add(new ReportParameter("ParameterName", ParameterValue));
    localReport.SetParameters(parameters);
    localReport.Refresh();
}
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接