yeasir007

Wednesday, October 10, 2012

Calling Drillthrough Report in rdlc reporting:


Calling Drillthrough Report in rdlc reporting:

If i want to generate a rdlc report name attendence.rdlc which take three parameter employeeId,monthId and year to generate employee's monthly attendance status.Like 



When i click >> button, I need to call drillthrough (in my case same report) report increasing(deppand on arrow << decrease) month and year's parameter.In  this case i need to create an even handler obviously outside of IsPostback like:

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();
}

No comments:

Post a Comment

Thanks for your comments