Tuesday, March 20, 2012

Open report in a new window

Hi,
Does any one know how to open a report that is a link or " jump to
report" in a new window and not instead of the previous report?
Thank you
Avi.Use jump to URL instead of jump to report. Also, to test you will need to
deploy to test.
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'))"
Note, if you leave off & "&rs:Format=CSV&rc:Encoding=ASCII' you will have
the report come up in the default which is html.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160514656.798030.305680@.i42g2000cwa.googlegroups.com...
> Hi,
> Does any one know how to open a report that is a link or " jump to
> report" in a new window and not instead of the previous report?
> Thank you
> Avi.
>|||Hi,
Thank you for thee fast Answer.
Where should I write this code?
I did it by clicking specific cell in a table-> properties-> advanced->
navigation and the choose the report I want to jump to and its
parameters.
Thank you.
Avi
Bruce L-C [MVP] wrote:
> Use jump to URL instead of jump to report. Also, to test you will need to
> deploy to test.
> 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'))"
> Note, if you leave off & "&rs:Format=CSV&rc:Encoding=ASCII' you will have
> the report come up in the default which is html.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160514656.798030.305680@.i42g2000cwa.googlegroups.com...
> > Hi,
> > Does any one know how to open a report that is a link or " jump to
> > report" in a new window and not instead of the previous report?
> >
> > Thank you
> >
> > Avi.
> >|||Same place but down a little is jump to URL. Use that instead of jump to
report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160516837.325565.187280@.m7g2000cwm.googlegroups.com...
> Hi,
> Thank you for thee fast Answer.
> Where should I write this code?
> I did it by clicking specific cell in a table-> properties-> advanced->
> navigation and the choose the report I want to jump to and its
> parameters.
> Thank you.
> Avi
> Bruce L-C [MVP] wrote:
>> Use jump to URL instead of jump to report. Also, to test you will need to
>> deploy to test.
>> 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'))"
>> Note, if you leave off & "&rs:Format=CSV&rc:Encoding=ASCII' you will
>> have
>> the report come up in the default which is html.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "AB" <savi176@.yahoo.com> wrote in message
>> news:1160514656.798030.305680@.i42g2000cwa.googlegroups.com...
>> > Hi,
>> > Does any one know how to open a report that is a link or " jump to
>> > report" in a new window and not instead of the previous report?
>> >
>> > Thank you
>> >
>> > Avi.
>> >
>

No comments:

Post a Comment