Drill Through report return to location of inital Drill through on parent report

Posted on 2009-04-29
Last Modified: 2012-05-06
All I'm new to SSRS so I'm sure this should be easy to answer.  I have a number of reports that are accessed via a drill through report initially.  The user starts with the first report that has highly summarized data and drills through to progressivly more detailed info.  Pretty ho hum for the most part.

The issue is when the user uses the browsers back button to return to the first report the report always refreshes and returns to the top of the screen.  This causes the user to lose his place on the report.

Is there anyway to get the report to just return back to where the user drilled through to start with.  Think of this like searching on google.  It wouldn't be to cool to review 4 pages of infomation and be half way down on the fifth page and when you back navigate have google start you off at page one again.
Question by:Guitarman316
    LVL 26

    Accepted Solution

    I have looked and done some experiments and do not see how this can be done as any solution invoves coding for it in your app/webpage and RS is in control here.  The closest thing I know of is in this link,, we used this logic in some pages on our app but I am not sure of a way to use it on reports.  Good luck.

    Author Comment

    Thanks for the reply. It seems odd that this isn't something that can be done.  I took a look at the article you provided and It got me searching again.  It looks like others have stumbled upon the same issue from as far back as ssrs 2000.  I must be missing something in my approach then or MS would have resolved this issue by now.

    Let me ask how would you accomplish the following. The user needs a larg list of summarized data. From that list he needs to go to another list that relates to summarized data of a different type than the first list and finally to the detailed data. From either of the screens below the parent he needs to be able to get back to the first report so he can continue looking at the rest of the report without having to start over.

    I've been wondering if  it's possible to do a programtic search on the first page which may be a different page that has an extra parameter for the search value (in my case a part number). The search or find function is capable of locating the record but the shouldn't have to remember to copy the part number before drilling in.

    How is everybody else accomplishing this kind of task. As one person said in my review of smartNavigation "without this functionality Drill Through reports are useless." I know my users are frustrated.  Luckily I'm just at a proof of concept phase.  I can always go for another product if I must.


    Author Closing Comment

    Wasn't a good solution that would work inside of ssrs.  Awarding points for effort.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now