Sunday, February 19, 2012

How to set a link whitch opens the record in an new Window

Hello NG,
I have to link to a SharePoint Document library out of the Report. But the
Library opens in the Report Window and not in an new Window.
How can I set the Link in Reporting Services that the Library will open in a
new Window?
Thanks
ThomasThis is for a regular report (not SharePoint) but hopefully it will put you
in the right direction. You need RS 2000 SP1 or greater (which hopefully is
everybody at this point).
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"','_blank'))"
Couple of things to notice. First, I use the Globals!ReportServerURL so I do
not hard code the server name. Second, be careful with the single and double
quotes.
Note that the Jump to URL action is used for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
> Hello NG,
> I have to link to a SharePoint Document library out of the Report. But the
> Library opens in the Report Window and not in an new Window.
> How can I set the Link in Reporting Services that the Library will open in
> a new Window?
> Thanks
> Thomas
>|||Hello, thank you for your Answer.
I try it many times, but it wont work. The Report doesn't identify it as a
Link.
I build it like this.
="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
But there must be an Mistake in it. Have I forgot something?
Thanks
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
> This is for a regular report (not SharePoint) but hopefully it will put
> you in the right direction. You need RS 2000 SP1 or greater (which
> hopefully is everybody at this point).
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "','_blank'))"
> Couple of things to notice. First, I use the Globals!ReportServerURL so I
> do not hard code the server name. Second, be careful with the single and
> double quotes.
> Note that the Jump to URL action is used for this.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>|||You are piecing together a string. Yours is a total mess. Look closely at
mine. You are doing the same thing.
For instance, what is the apersand doing here? Appersand means to append two
string. You do not have two strings to append. You are putting an appersand
in the middle of a string. You have done that same throughout this.
="javascript:void(window.open('http://serveradress&"/
I suggest you first hard code the value (get it working with out the Field
values.
I don't know if this will work but it is a whole lot closer:
="javascript:void(window.open('http://serveradress/" &
Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
> Hello, thank you for your Answer.
> I try it many times, but it wont work. The Report doesn't identify it as a
> Link.
> I build it like this.
> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
> But there must be an Mistake in it. Have I forgot something?
> Thanks
> Thomas
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so I
>> do not hard code the server name. Second, be careful with the single and
>> double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>>
>|||Ok I did it like you. Now the Report identyfies it as a link. But when i
click at the link nothing will happen. If I copy the link into the Internet
Explorer, nothing will happens too.
Thats the generated link.
javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
If I take the middle of this link
'http://servername:port/wss_id/default.aspx than its working.
Maybe its because of the Internet Options?
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
> You are piecing together a string. Yours is a total mess. Look closely at
> mine. You are doing the same thing.
> For instance, what is the apersand doing here? Appersand means to append
> two string. You do not have two strings to append. You are putting an
> appersand in the middle of a string. You have done that same throughout
> this.
> ="javascript:void(window.open('http://serveradress&"/
>
> I suggest you first hard code the value (get it working with out the Field
> values.
> I don't know if this will work but it is a whole lot closer:
> ="javascript:void(window.open('http://serveradress/" &
> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it as
>> a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so
>> I do not hard code the server name. Second, be careful with the single
>> and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>>
>>
>|||What is this about? You don't want to have a // after javascript.
javascript://void
As I mentioned previously, I do not know about sharepoint integration.
However, I don't think it will make any difference.
Do the following, put what I have below in the jump to URL action and make
sure this works as advertised. This pulls up the google page in another
window:
="javascript:void(window.open('http://www.google.com/','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:uCiNm7UfIHA.1900@.TK2MSFTNGP02.phx.gbl...
> Ok I did it like you. Now the Report identyfies it as a link. But when i
> click at the link nothing will happen. If I copy the link into the
> Internet Explorer, nothing will happens too.
> Thats the generated link.
> javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
> If I take the middle of this link
> 'http://servername:port/wss_id/default.aspx than its working.
> Maybe its because of the Internet Options?
> Thomas
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
> news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
>> You are piecing together a string. Yours is a total mess. Look closely at
>> mine. You are doing the same thing.
>> For instance, what is the apersand doing here? Appersand means to append
>> two string. You do not have two strings to append. You are putting an
>> appersand in the middle of a string. You have done that same throughout
>> this.
>> ="javascript:void(window.open('http://serveradress&"/
>>
>> I suggest you first hard code the value (get it working with out the
>> Field values.
>> I don't know if this will work but it is a whole lot closer:
>> ="javascript:void(window.open('http://serveradress/" &
>> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it as
>> a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so
>> I do not hard code the server name. Second, be careful with the single
>> and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will
>> open in a new Window?
>> Thanks
>> Thomas
>>
>>
>>
>|||I took your link into the Jump to Url action. But its the same Problem.
When I click at the Link nothing will happen.
Is there any other alternative without javascript to open in a new Window?
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:OIAzHiVfIHA.5900@.TK2MSFTNGP02.phx.gbl...
> What is this about? You don't want to have a // after javascript.
> javascript://void
> As I mentioned previously, I do not know about sharepoint integration.
> However, I don't think it will make any difference.
> Do the following, put what I have below in the jump to URL action and make
> sure this works as advertised. This pulls up the google page in another
> window:
> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:uCiNm7UfIHA.1900@.TK2MSFTNGP02.phx.gbl...
>> Ok I did it like you. Now the Report identyfies it as a link. But when i
>> click at the link nothing will happen. If I copy the link into the
>> Internet Explorer, nothing will happens too.
>> Thats the generated link.
>> javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
>> If I take the middle of this link
>> 'http://servername:port/wss_id/default.aspx than its working.
>> Maybe its because of the Internet Options?
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
>> You are piecing together a string. Yours is a total mess. Look closely
>> at mine. You are doing the same thing.
>> For instance, what is the apersand doing here? Appersand means to append
>> two string. You do not have two strings to append. You are putting an
>> appersand in the middle of a string. You have done that same throughout
>> this.
>> ="javascript:void(window.open('http://serveradress&"/
>>
>> I suggest you first hard code the value (get it working with out the
>> Field values.
>> I don't know if this will work but it is a whole lot closer:
>> ="javascript:void(window.open('http://serveradress/" &
>> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it
>> as a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will
>> put you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL
>> so I do not hard code the server name. Second, be careful with the
>> single and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report.
>> But the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will
>> open in a new Window?
>> Thanks
>> Thomas
>>
>>
>>
>>
>

No comments:

Post a Comment