SSRS Drill down. How to do bigger back button?


My partner (Katie) created a report with drill down and that works fine however there is requirement to create back button. We know there is a small arrow on the toolbar which does it and we would like to replicated it but on the report itself and make it more obvious for users.

Is there a way to do that?

Many thanks in advance
Emil & Katie
LVL 10
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
You should be able to place a button on a web page outside the ReportViewer control and have it call ReportViewer.PerformBack ( I haven't tried it yet, but I have been tempted to add better navigation buttons to some of my reports.
This should also work for WinForms.
itcoupleAuthor Commented:
Thanks for that. We are not very familiared with :) and rather avoid.

I've been thinking about it and I wonder if there is a way to do jump back? I mean if I can jump forward can jump backward? I might try that. I would imagine that there is some link that I could build to make it work?

p.s. I have not replied to your message on another post for a while. I'm sorry I will do that now :)

Megan BrooksSQL Server ConsultantCommented:
It's not too hard. :-)
Add the button to the ASPX, specifying the name of a click event hander. Create the "click" event handler using the same name. In the click event, call rv.PerformBack(). Most of the work may be getting the page to actually look right. I can post a little sample code if you change your mind.
You could use the "Go to report" action in a text box in the drillthrough report.  You will need to know which report to return to.
You can also construct a return link in the original report and pass it as a parameter to the drillthrough report. I often do this using URLs that reference my web app rather than Report Server. The Globals (Built-in Fields in the expression editor) object contains most if not all of what you need, such as ReportServerURL, ReportFolder, and ReportName. You may also need to include parameter and page number information in the return URL if you want to end up back where you started. I think you can do all of that with URL query parameters.
Test the return URL that you construct by placing it in a spare cell in the report, so that you can view it. When it looks right, add it as a Go to URL action in the textbox that will serve as the hyperlink back to the original report.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
itcoupleAuthor Commented:
Hi Megan,

I think you provided all possible ways of doing that :) With option one we cannot do that as we are helping somebody to build more user-friendly reports, so in this particular case we will try to do that with parameter but for other web pages we might look into as it seems to give much more flexiblity although I'm still a bit scared of this technology :)

Actually I'm working on a different project where we (not me) want to use and we struggle to pass multiple parameters. Have you done something similar before? We posted the question here

Many thanks for your great support! It makes our lives so much easier :) ..... and learning is much quicker :p

Emil & Katie
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.