Solved

SSRS 2008 Jump To Report

Posted on 2012-03-30
4
650 Views
Last Modified: 2012-08-14
Jumping from reportA to reportB in SSRS 2008 works fine.

To go back to reportA from reportB, user can click Blue Back Arrow (which is not there anymore since IE 8) or Right Click on second report and then click Back, which works fine.

But, the user wants me to put a textbox on reportB, that they can click, that will take them back to reportA. Fine, I did that by doing a Jump To reportA from reportB, BUT, it takes them back to page 1 of reportA. NOT GOOD. I want them to Jump TO the page of reportA that they originally Jumped From.

Can that be done ????

Is there someway to duplicate what the right click and clicking Back does  ??
0
Comment
Question by:thayduck
4 Comments
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 250 total points
ID: 37789816
You might be able to use JavaScript to go back one page in history ( history.go(-1); ).
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37790795
"user can click Blue Back Arrow (which is not there anymore since IE 8) " 

Isn't it hidden by some IE setting then?  On my machine with Win7, IE9, I still have the blue back button.  Another way to activate IE's "back" functionality is by hitting the backspace key.  Or, if the user has a multi-button (.e. more than two) mouse, it may be an option to set one to activate the back button?  It's convenient for surfing as well :)
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37790827
Can you create a text box or a custom graphic, so when users click on it, they go to the first report?
like what's in the bottom of this article...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_8737-SSRS-can-be-also-used-for-user-inputs.html
0
 

Author Closing Comment

by:thayduck
ID: 37791617
I dug around on internet and came across this java command:

="javascript:history.back(1)"       Very similar to yours....

So I used GoToURL in my Go Back textbox with above java code and it still did nothing.

then a MIRACLE....    

Someone suggested that above will not work if called while in vs 2008 while creating your report. You must upload to report server then try.

I did that and above javascript worked perfectly. It brought me back to the first report and brought me back to the exact page I jumped from. Works the same way that the missing Blue Back Arrow worked.

Since your suggestion got me going in the right direction, I gave you the points.

Thanks for all the other suggestions....
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
convert null in sql server 12 46
Better way to make a query with date filter. 5 36
sql how to count case when 4 25
SQL Syntax: How to force case sensitive query? 2 44
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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