drill through issue when using Report Viewer in SharePoint

Question

Hi guys,

I've a issue about Reporting Services integrated with Sharepoint.

I've a report with a drill through to another report.

The parent report has a parameter hidden and the child report has a parameter visible, so, when I run de report through de BIDS the parameter from the child report appears, but when a run through de Report Manager integrated with Sharepoint(Report Viewer) the parameter from the child report does not appear.

I did a test in Report Manager integrated with Sharepoint(Report Viewer), I modified the parameter from my parent report to visible, and works well, when I run my parent report and drill through to my child report the parameter from my child report appears, but if the parameter from my parent report is hidden when I run and drill through to child report the parameter from te child report does not visible.

Any idea about this issue

Thanks!!

---

Renato Freitas

Answer 1

Hi Renato,

Based on your description, I create a similar report and try to reproduce the issue in my test environment.

I create a main report and a drill through report in the same Report Server project and deploy reports to SharePoint site under the same library folder. When preview the reports, parameter control is visible in the drill through report.

When the main report and the drill through report are not in the same project and I specify the drill through report with URL in the main report, for example: =”http://servername/sites/Reports/drillthroughreport.rdl”.  At this time, the parameter control disappears when I run the report in SharePoint, just as you post above. This behavior might be by design. Personally, I recommend that you submit a feedback in https://connect.microsoft.com/SQLServer/. 

To work around this issue, please try to change the drill through action by “Go to URL”, for example: =”http://servername/ReportSever?http://servername/sites/Reports/drillthroughreport.rdl&fieldname=”&Fields!fieldname.Value. Then we can select values in the parameter control in Report Viewer.
Hope it will help.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support

Answer 2

Hi Fanny Liu,

I changed my parent report by using "Go to URL" in the drillthrough action to my child report, and I use this post http://blogs.msdn.com/b/prash/archive/2009/01/21/passing-url-report-parameters-to-reports-in-sharepoint-document-library-in-ssrs-2008.aspx with model, this solution works fine running with Report Viewer in Sharepoint.

My reports are in the same project in the report server integrated with Sharepoint.

Does your parent report has a parameter hidden? Because my parent report has a parameter hidden and my child report has a prompt parameter visible. If I use the action "Go to Report" and I run the report with this configuration in the Report Viewer, the parameter from chlid report does not appear when I drillthrough to him. If I changed the parameter from parent report to visible, when I run in Report Viewer the reports work.

It looks like that the DrillThrough report inherit the properties from the parent report when use action "go to report" and execute in Report Viewer.

Thanks

---

Renato Freitas

Answer 3

Hi Renato,

Thanks for your reply.

Sorry for the misunderstanding in my first post: I run the report in the SharePoint site instead of render the report from the report server with Report Viewer.When I run the report in SharePoint site, the issue doesn't happen just as I post above.

When the report in rendered with Report Viewer, it seems that the parameter in the drill through report inherit the hidden properties from the main report, but we can show the hide parameter by click the “Show/Hide Parameter” button in the Report Viewer control. Based on my test, when the drill through has other parameters, the issue doesn’t appear.

The following screen shot shows my test, please take as reference.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support