September 8, 2009 at 1:36 pm
User wants to be able to click on the record
in my "DSR Validation" report and open a separate browser window with another report.
So far I only know of one way to do something like this:
Set Hyperlink action to "jump to report" and pass some parameters.
The problem is it opens "called" report in the same browser window.
Th user wants to leave the the main report untouched and to generate a few Chart reports based on parameters form main "DSR Validation" report.
September 9, 2009 at 7:17 am
I believe you need to use some javascript and url access to the report in the jump to url. See this blog post: http://blog-mstechnology.blogspot.com/2009/07/provide-hyperlink-to-open-in-new-window.html
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 9, 2009 at 7:21 am
I found the solution.
In Textbox Properties, Navigation tab, select "Jump to URL"" option.
Then insert this Javascript script:
="void(window.open('http://wmbcextrmw80101.na.corp.tdwm.com/ReportServer/Pages/ReportViewer.aspx?%2fMarket+Risk%2fSystems+QA%2fUAT%2fCUSIP+Chart&rs:Command=Render&Parm1="+Fields!CUSIP.Value+"'))"
The URL path to the report you can get if you type http://servername/ReportServer/
in your browser. Then just go to your report and you'll get something like:
http://wmbcextrmw80101.na.corp.tdwm.com/ReportServer/Pages/ReportViewer.aspx?%2fMarket+Risk%2fSystems+QA%2fUAT
Just add &rs:Command=Render&Parm1="+Fields!Index.Value+"
in Navigation / Jump to URL box. In my case I am passing parameter "Parm1" value to "CUSIP Chart" report that is located in the same web folder.
So what did I achieve?
When I click a link in my main report, it opens "CUSIP Chart" report in a new browser window.
I probably can even control the position and size of the new window.
I will do it for sure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply