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