Look into allowing Drilldown reports to work properly

[Kaugustine01]

Im excited for this enhancement. What are your thoughts on feasibilty and timing?

[alanjuden]

@Kaugustine01, I'm not sure on the feasibility and timing. I've been pretty busy lately so I haven't yet had a chance to look into it, but hopefully some evening soon I'll get to mess with the idea.

[fluentsolutions]

@alanjuden I am looking into implementing this as well as the show/hide toggles but I can't seem to find documentation around how to make the generated HTML include identifiers or if this functionality even exists. What documentation were you using to help you? I have looked through all of the technet docs and can't seem to pinpoint how to define show/hide toggles. If I figure it out I can contribute the code back.

[fluentsolutions]

From what I can tell you can't utilize the interactive features with HTMLFragment=true. Have you come across anything that would suggest this is possible?

[alanjuden]

@fluentsolutions, I had done some research on this a month or so ago and wasn't ready to call it quits on figuring out a solution for it...but from what I'm seeing it doesn't really seem very feasible.

[fluentsolutions]

I had to revert to using the ReportViewerControl in a Webform within MVC. I researched and it looks like it is not possible to leverage interactive functions when HTMLFragment = true.

[ivancogeorgiev]

We solved the problem with the drill-down by parsing the HTML content and attaching javascript function on each of the drill-down links. This javascript function sends GET request to the Reporting Server (via our API since we need to set credentials) and fetches the report content in HTML format. We are aware that with this solution we are losing the paging feature but for our case, this is not very important since the reports are not that large. Drill-down reports are always shown on one page.

For the drill-down reports, we overrode the print and export features of the viewer.

We resolved toggling and sorting for the drill-down reports in a similar way: from the drill-down HTML report content we extract the execution id. This id is required for the Reporting Server to process the sorting/toggling request and return new HTML report content.

The second and last limitation we have (besides not having paging for drill-down reports) is extracting the execution id from the drill-down HTML content: SSRS set execution id only to image URL links (as far as I know) as part of the query string. This means that if the drill-down report does not have an image then sort and toggle operations will not work.

Once again, our drill down reports have images so this compromise is acceptable for our case.

If you think that this approach will work for you I'll be happy to share code snippets.

Alan, thank you a lot for the great work you have done with this viewer.

[PriyeshOulook]

@ivancogeorgiev

I am using .net c# programming to view the report from SSRS(.rdl) using WCF based on Alan Juden. I have used Report Server Commands (rs:) ShowHideToggle as a parameter for drill-out data. Could you please help me how to use ShowHideToggle parameter into Render method of WCF?

When i tried to toggle the button, the server simply returns an empty response, nothing shown in the response neither data (same “without drilldown” data) nor error.

I am simply clueless about what is happening. I am facing SSRS(.rdl) Drilldown, Sorting and Drillthrough issues for viewing the report.

I think your above approach is work for me, It is really helpful if you share code snippets or any example related to Sorting, DrillDown, Drillthrough which is working at your side based on Alan Juden.

Thanks ivancogeorgiev.

[satishkumar1610]

We solved the problem with the drill-down by parsing the HTML content and attaching javascript function on each of the drill-down links. This javascript function sends GET request to the Reporting Server (via our API since we need to set credentials) and fetches the report content in HTML format. We are aware that with this solution we are losing the paging feature but for our case, this is not very important since the reports are not that large. Drill-down reports are always shown on one page.

For the drill-down reports, we overrode the print and export features of the viewer.

We resolved toggling and sorting for the drill-down reports in a similar way: from the drill-down HTML report content we extract the execution id. This id is required for the Reporting Server to process the sorting/toggling request and return new HTML report content.

The second and last limitation we have (besides not having paging for drill-down reports) is extracting the execution id from the drill-down HTML content: SSRS set execution id only to image URL links (as far as I know) as part of the query string. This means that if the drill-down report does not have an image then sort and toggle operations will not work.

Once again, our drill down reports have images so this compromise is acceptable for our case.

If you think that this approach will work for you I'll be happy to share code snippets.

Alan, thank you a lot for the great work you have done with this viewer.

Hi Ivan,

Great to hear that you resolved the drilldown reports.

I am having the same issue, if you can help me with your code snippet it will be great full.

Thanks

[vijaythodupunoori]

Hi satish,

Can you share the code for drill down functionality

[srinivasande]

@satishkumar1610

Hi Satish, We are also facing issue with the drillthrough to another report using Alan Juden Report Viewer. Could you please share the code for drillthrough to another report functionality? Your help will be much appreciated as we are stuck with this issue. Thank you.