Jump to report in new window? 1

[woyler]

Hi all,
I am using SQL RS 2005 and need to find out if it is possible to use the "jump to report " action and have the report open in a new window?

regards,

Bill

 

[xlbo]

This will depend on the settings for the window you are currently in. If the HTML tells it to open links in a new window, that is what it will do. There is nothing (AFAIK) in RS2000 at least that will make the link you specify open in a new window.

What I have done as a workaround is to use the JumpToUrl instead and make sure that the report before the jump to new window report sets the appropriate target for the current report (I think that makes sense)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[woyler]

Thanks for the reply Geoff,
I have seen the jump to url as a solution, but I need to pass several parameters in from the master report. Can this be done with the "Jump to URL"?
regards,
Bill

 

[xlbo]

certainly can. I use a little bit of code to build the url but can be pretty easily done in a formula.

You will need to make use of the Globals ReportServer & ReportFolder items.

Other than that, it is simply a case of concatenating strings to create a url. Parameters are simply passed with an & e.g.

= Globals!ReportServerUrl & "?" & Globals!ReportFolder & ReportName & "&Param1Name=Param1Value&Param2Name=Param2Value"

etc etc. You can also set the render type and whether parameters are visible to the user as well as toolbar visibility....

"&rcarameters=collapsed&rc:Toolbar=False&rc:LinkTarget=_blank&rs:Format=EXCEL"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question