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