el

Pop-up Windows in SSRS

Saturday, October 17, 2020

In This post we can find that how to perform the Pop-Up windows in SSRS report. Much of the data on the main report did not need to be displayed all the time, the users only needed additional details on some of the rows.  In order to solve the problem we can create a sub-report with additional data, add it to a cell in the main report’s Tablix and toggle visibility based on a textbox in the Tablix. Unfortunately, as so often happens with sub-reports, the performance was slow.  All the additional data in the sub-report had to be queried and rendered for each row even if the user never needed to see most of it. The solution was simple and effective, only run the query for the sub-report for those rows the user needs With a pop-up window the user can simultaneously view the main report and as many detail windows as needed.  Also, when the user is done viewing details he can close the pop-up window and be immediately back the exact spot on the main report without any further navigation. Opening a drill-through report in a pop-up is simple with a basic JavaScript function, window. Open.  Set the Action property of a textbox or image to Go to URL.  Add an expression like this: =”javascript:void(window.open(‘http://myserver/mypath/myasppage.html’,‘subreport‘))” Change the MyReportServer, MyFolder, MyReport, etc to your report server and path to your drill-through report. Using this technique can dramatically improve performance because the sub-report data is not being run for each row on the report and it also doesn’t need to be rendered/hidden either.  It is only displayed when the user needs it The user does not need to navigate back to the main report when he’s done reviewing the drill-through report(s), he simply closes the pop-up window(s) and the main report is in the exact state he left it. By: Pratap Palukuru

No items found.