Showing posts with label opening. Show all posts
Showing posts with label opening. Show all posts

Friday, March 30, 2012

Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

sql

Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

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