Saturday, February 25, 2012

Report Hyperlink Opening New Window

Hi, I am trying to get a link out of a report to open another web browser
with the HTML
rs:target=_blank as part of the string parameter that is passed in...but it
still opens the link in the same window.
?How does one open a link out of a report so that it will open a new window?
THANKS!!!There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi, I am trying to get a link out of a report to open another web browser
> with the HTML
> rs:target=_blank as part of the string parameter that is passed in...but
> it still opens the link in the same window.
> ?How does one open a link out of a report so that it will open a new
> window?
> THANKS!!!
>|||ok, so I tried this and it didn't work...or maybe I didn't understand it...
I'm in a text box in a table under
properties>>advanced>>navigation>>Jump to URL
and I enter
="http://kingofthegreens.com&rc:LinkTarget=_blank"
results in it still opening in the same window'
"Robert Bruckner [MSFT]" wrote:
> There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > Hi, I am trying to get a link out of a report to open another web browser
> > with the HTML
> > rs:target=_blank as part of the string parameter that is passed in...but
> > it still opens the link in the same window.
> >
> > ?How does one open a link out of a report so that it will open a new
> > window?
> >
> > THANKS!!!
> >
>
>|||I am having a similar issue, I can't find the syntax for adding
rc:LinkTarget. I am trying to add a url with one query string parameter and
open in a new window.
Thanks!
"Ben Sullins" wrote:
> ok, so I tried this and it didn't work...or maybe I didn't understand it...
> I'm in a text box in a table under
> properties>>advanced>>navigation>>Jump to URL
> and I enter
> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
> results in it still opening in the same window'
>
> "Robert Bruckner [MSFT]" wrote:
> > There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> > See also:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > > Hi, I am trying to get a link out of a report to open another web browser
> > > with the HTML
> > > rs:target=_blank as part of the string parameter that is passed in...but
> > > it still opens the link in the same window.
> > >
> > > ?How does one open a link out of a report so that it will open a new
> > > window?
> > >
> > > THANKS!!!
> > >
> >
> >
> >|||Here is a response of mine about exporting to CSV that covers your
situation. Note that you need to have SP1 or SP2 installed to be able to use
this:
>>>>>>
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
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"
Very nice and very fast.
>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Rogers" <Peter Rogers@.discussions.microsoft.com> wrote in message
news:F4C1AC98-3B0D-443D-B18A-0E7896435958@.microsoft.com...
>I am having a similar issue, I can't find the syntax for adding
> rc:LinkTarget. I am trying to add a url with one query string parameter
> and
> open in a new window.
> Thanks!
> "Ben Sullins" wrote:
>> ok, so I tried this and it didn't work...or maybe I didn't understand
>> it...
>> I'm in a text box in a table under
>> properties>>advanced>>navigation>>Jump to URL
>> and I enter
>> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
>> results in it still opening in the same window'
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > There is no rs:target parameter. I suppose you mean
>> > rc:LinkTarget=_blank
>> > See also:
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
>> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > > Hi, I am trying to get a link out of a report to open another web
>> > > browser
>> > > with the HTML
>> > > rs:target=_blank as part of the string parameter that is passed
>> > > in...but
>> > > it still opens the link in the same window.
>> > >
>> > > ?How does one open a link out of a report so that it will open a new
>> > > window?
>> > >
>> > > THANKS!!!
>> > >
>> >
>> >
>> >

No comments:

Post a Comment