Drill through feature implementation in RDLC
Hi, We are implementing drill through feature in one of our application. We have the parent and child reports and have the configuration set while designing the report with by assigning appropriate values to Action and Parameters. We have configured the report viewer control with the parent report and also the data source. Our understanding is, once the parent report gets launched, on click of one of the data items in the report, the child report should also get launched with the parameters being sent as configured. This is not happening and we are getting an error "A data source instance has not been supplied for the data source ‘MyDataSet_MasterEvent’". When we looked into msdn help, there is a code written to assign appropriate values to certain properties and then it works. The question is Wont the configuration of drill through made during design time take care of the implementation? Why the above mentioned error is coming when the data source, parameter values etc are appropriately configured. Please help us. Regards, Phani Note: Please mark the post as answered if it answers your question.
May 24th, 2010 3:49pm

In RDLCs Drill through will not happen out of box. We need to do coding to make sure that it works. The problem was that even though the new report name has been configured on Action property and the parameter is supplied, the connection was not getting associated with the new RDLC. Hence the above mentioned error came. When we handled that through code, it worked.Phani Note: Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2010 1:43pm

phaneedra babu, can you please help me on how you solved this issue? I am having the same problem. I am coding in vb.net...ddd
May 5th, 2011 3:35pm

This is what my code looks like: Private Sub ReportViewer1_Drillthrough(ByVal sender As System.Object, ByVal e As Microsoft.Reporting.WinForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough Dim localreport = ReportViewer1.LocalReport Me.Sp_get_testaccountsTableAdapter1.Fill(Me.Retreival.sp_get_testaccounts) Dim od As New RetreivalTableAdapters.sp_get_testaccountsTableAdapter Dim myReportDataSource = New ReportDataSource( _ "DataSet1", Me.sp_generate_accountreportBindingSource) localreport.DataSources.Add(myReportDataSource) End Sub ddd
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2011 4:25pm

Hi, Please find the code below that we used in our application: private void LoadReport() { try { <em><span style="text-decoration:underline"> ReportViewer.Reset(); </span></em> ReportViewer.ServerReport.ReportServerUrl = new Uri(ReportServerUrl); ReportViewer.ServerReport.ReportPath = SelectedReportPath; // This piece of code is to set the parameters for passing them to the report. if (SelectedReportParamList.Count > 0) { List<ReportParameter> paramlist = new List<ReportParameter>(); foreach (ReportParamDC param in SelectedReportParamList) { if (string.Equals(param.Name, Consts.SCOPE, StringComparison.OrdinalIgnoreCase)) { paramlist.Add(new ReportParameter(param.Name, SelectedItemType, false)); } if (string.Equals(param.Name, Consts.ID, StringComparison.OrdinalIgnoreCase)) { paramlist.Add(new ReportParameter(param.Name, SelctedNodeID, false)); } } this.ReportViewer.ServerReport.SetParameters(paramlist); } ReportViewer.Visible = true; <em><span style="text-decoration:underline"> ReportViewer.RefreshReport(); </span></em> } catch (Exception ex) { StatusMsg = ex.Message; } } I think the order and sequencing the underlined code did the trick. Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.
May 9th, 2011 2:49am

Hello, This is interesting. Do you have a report server for these reports? It seems like you are doing server side processing for the reports. My implementation requires local processing. ddd
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 9:30am

Yes. They are Server side reports. We conciously made the decision of using server side reports since local reports lag certain key capabilities which would impact certain visualization capabilities. Regards, Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.
May 9th, 2011 11:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics