SSRS Drill down. How to do bigger back button?

Hi

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
itcoupleAsked:
Who is Participating?
 
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.
 
0
 
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 (http://msdn.microsoft.com/en-us/library/microsoft.reporting.webforms.reportviewer.performback.aspx). 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.
0
 
itcoupleAuthor Commented:
Hi
Thanks for that. We are not very familiared with asp.net :) 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 :)

Regards
Emi
0
 
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 asp.net 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 asp.net and we struggle to pass multiple parameters. Have you done something similar before? We posted the question here http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_25990975.html

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

Regards
Emil & Katie
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.