Jump to URL - Open New Window

Hello,
I'm still having an issue with opening up a new window on the report
server regarding the report designer's -> Jump to URL feature (option)
in Advanced - Navigation.
This is what I currently have now and I've tried the JavaScript syntax
(expression) i've seen on the old boards, but I keeping getting a web
syntax error from Visual Studio 2003.
We are using Reporting Services Service Pack 2 with SQL Server 2000.
="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
I've tried taking away all of the rs and rc syntax and still get the
same result.
Does anyone have any advice on how to make the syntax above work to
create a popup window from a report on the report server or provide any
syntax that makes it work?
Thanks a lot for your help!First, you are on RS 2000. Do you have SP1 or higher installed? Support for
this was introduced with SP1.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nat.caserta@.telelogic.com> wrote in message
news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> Hello,
> I'm still having an issue with opening up a new window on the report
> server regarding the report designer's -> Jump to URL feature (option)
> in Advanced - Navigation.
> This is what I currently have now and I've tried the JavaScript syntax
> (expression) i've seen on the old boards, but I keeping getting a web
> syntax error from Visual Studio 2003.
> We are using Reporting Services Service Pack 2 with SQL Server 2000.
> ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> I've tried taking away all of the rs and rc syntax and still get the
> same result.
> Does anyone have any advice on how to make the syntax above work to
> create a popup window from a report on the report server or provide any
> syntax that makes it work?
> Thanks a lot for your help!
>|||Hi Bruce,
Seen you on quite a number of boards giving some good advice. We have
installed Services Pack 2 last year since it came out.
We understand that there is a hotfix to SP2 on this issue. Do we need
to install it to make your syntax work?
The Hot fix link is at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en
Otherwise, with SP2 installed i've tried what you've already suggested
with and without the " "&rs:Format=CSV&rc:Encoding=ASCII' ". I would
like for this to show up in an HTML popup window as opposed to an Excel
download.
Regards,
Nat
Bruce L-C [MVP] wrote:
> First, you are on RS 2000. Do you have SP1 or higher installed? Support for
> this was introduced with SP1.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <nat.caserta@.telelogic.com> wrote in message
> news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> > Hello,
> >
> > I'm still having an issue with opening up a new window on the report
> > server regarding the report designer's -> Jump to URL feature (option)
> > in Advanced - Navigation.
> >
> > This is what I currently have now and I've tried the JavaScript syntax
> > (expression) i've seen on the old boards, but I keeping getting a web
> > syntax error from Visual Studio 2003.
> >
> > We are using Reporting Services Service Pack 2 with SQL Server 2000.
> >
> > ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> >
> > I've tried taking away all of the rs and rc syntax and still get the
> > same result.
> >
> > Does anyone have any advice on how to make the syntax above work to
> > create a popup window from a report on the report server or provide any
> > syntax that makes it work?
> >
> > Thanks a lot for your help!
> >sql