Drillthrough question - how to return to same page?

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users sure don't love this "feature"!

I am using Report Manager and not the .NET report viewer control. Also, I don't see any navigational control on the drillthrough report that allows me to "back up" to the master - that is why I have used the browser's "Back" button.

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

Hi BCB,
sorry I haven't the answer, but can you just explain me how you do to drill through to a detail report with the option "jump to report"... I have a post here : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1455055&SiteID=1

Thank you to take few minutes...
please
|||

Hi Alineo,

You open the properties window for the report field that you want to turn into a drillthrough link. On the "Navigation" tab you select the drillthrough report. Finally, you click the "Parameters" button to add all parameters that the drillthrough report requires. That's all it takes.

BCB

|||

I've had the opportunity to investigate this a little more and I believe it has something to do with report parameters that do not have default values. I'm convinced that a report with no parameters will return to the same page when you click the brower's Back button. In other words, the report won't be run again before you see it.

Reports that have parameters without defaults always seem to be rerun when the user clicks the Back button even though the previously entered values are used when the report is generated.

My results with reports that have parameters with default values have varied. Some reports seem to return to the last-viewed page when the Back button is clicked and other reports are rerun.

I'm still looking for an answer to this so if anyone has a theory I'd appreciate hearing it.

Thanks.

BCB

|||

After spending several hours decomposing a report that suffers from this problem, it appears that a report with a parameter of multi-value type will be always run when the user returns to it by using the browser's Back button. This causes the original report to display page #1 again. Not very nice if you happened to viewing page #39 when you clicked the drillthrough link! I can't be sure there is no other way to cause this problem but the multi-value property is guaranteed to do the trick. I'm assuming this is a bug.

We are running SP2 on our servers.

If anyone has experience working around this problem I'd appreciate hearing your solution. Multi-value parms are a requirement for us.

Thanks,

BCB