Return to report where user left off.
Ok, so I have a report which users click on items in the report that navigates them to a direct SharePoint list edit form to edit the item. I have a custom button that then returns the user back to the report after clicking save which refreshes the data. However It returns them to the first page in the report. What I have been trying to figure out is how do I return the user back to where they left off? I have been brainstorming different ways but every time I come up with an idea it gets stopped by some oddball way SSRS works. For example. 1. I thought I could just add a query string parameter to the URL that takes them to SharePoint then use that Query string to return them back to the page they were on in the report. This would work great except for the fact SSRS won't report the page number where the textbox they click is on when the user clicks the report. 2. I figure possibly if there is a way to Go back to the report per say using the report back button, so after you click the save button on SharePoint it returns you 2 pages to go back to the report. This would possibly work but I cannot figure out how you do or force an "Auto Refresh" of the report once you hit the back button. 3. I have bookmarks in the report which I might be able to pass the bookmark in based on the SharePoint data ("which has a column that is the value of the bookmarks") but I'm not sure I can programmatically or use a URL parameter anymore for accessing bookmarks. 4. Have the SharePoint screen Open in a new window, which then closes the window on save, then provide a refresh button that works like auto refresh and returns them to the same spot they were. Currently refresh will refresh the report and return you to the beginning of the report. If anyone has had to tackle this let me know your method of going from your report. Clicking a URL, then having that webpage send you back to the report with refreshed data that would be awesome. Thanks in advanced!
November 2nd, 2012 9:11pm

Hi Turismon, Based on your scenario, I think the closet approach is to open the SharePoint site in a new window by using a javascript link for the "Go to URL" action (i.e. drillthrough) of the target textbox. The URL is like: =javascript:void(window.open('URL')) Reference: Advanced javascript in Reporting Services Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Your Name TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2012 9:50pm

Yeah, I've already had that working but they want it to refresh when they click OK or cancel and refresh the report automatically if they click OK on the SharePoint screen. Don't think I can trace where to window opened from then send a command back to that window. If I could add a refresh button to the report that might work, but the refresh button that the report viewer uses refreshes the entire report and starts at the first page again. The auto-refresh however will refresh to your current position in the report so I need to find out how to call that auto-refresh method that it uses.
November 4th, 2012 11:53pm

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

Other recent topics Other recent topics