Hi,
I just noticed a behavior change from SSRS 2000 (SP2 version) to SSRS
2005 (RTM version).
With SSRS 2000, if I use IE to bring up a report that can drillthrough
to other report, I can right-click at the textbox (where drillthrough
action would take place) to select "Open New Window". It will bring up
the drillthrough report in ANOTHER IE window along with the original
report in the original IE window.
Now with SSRS2005, if I do the same thing, right-click at the textbox
(where drillthrough would take place) does not give me "Open New
Window" selection any more.
Of course, in both cases, a simple click at the textbox would jump to
the drillthrough report which REPLACES the original report in the IE
window. But we really would like to see both reports at the same time.
To reproduce, one can try the sample AdventureWorks reports, open up
"Employee Sales Summary", select December 2003, Syed Abbas, view
report, then try right-click at order number SO58915. The followings
are the actual url (from right-click -> Properties) at the textbox for
drillthrough action.
SSRS2000:
http://kong-dell-4600/Reports$SONATA/Pages/Report.aspx?ServerUrl=http%3a%2f%2fkong-dell-4600%2fReportServer%24SONATA%3f%252fSampleReports%252fSales%2bOrder%2bDetail%26SalesOrderNumber%3dSO5421%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252fkong-dell-4600%252fReports%2524SONATA%252fPages%252fReport.aspx%253fServerUrl%253d
SSRS2005:
http://kong-dell-4600/Reports$MINUET/Reserved.ReportViewerWebControl.axd?ReportSession=nj1154fxuqxsxfn5rwz4wb55&ControlID=a97df556-62d2-4614-a898-ce42b4c28881&Culture=1033&UICulture=9&ReportStack=1&OpType=ReportArea&Controller=ClientControllerctl161&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&EnableFindNext=False&LinkTarget=_top
Is there any way to bring back the SSRS2000 behavior in SSRS2005?
Any pointers or hints are welcome. Thanks.
KongKong,
Can you use the HTML Device Setting of LinkTarget to open all your
links in a new window? This would eliminate the need to right click at
all.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
Andy Potter|||Hi, Andy,
Thanks for this suggestion.
I think if I write my own application then controlling HTML device
settings as you suggested would be easier.
All of my users are using report manager/report server from IE
directly. So I have to find a way to set LinkTarget to _blank (which
becomes default) in order to create a new window. Based on BOL, I
thought I could modify rsreportserver.config to specify LinkTarget
under Render ... HTML extension. Unfortunately the URL at the textbox
in SSRS 2005 is still http://...&LinkTarget=_top.
Any idea how to set LinkTarget to _blank as default in report
manager/report server config file?
Thanks.
Kong
Potter wrote:
> Kong,
> Can you use the HTML Device Setting of LinkTarget to open all your
> links in a new window? This would eliminate the need to right click at
> all.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
> Andy Potter|||Kong,
You can change your navigation to use a 'Jump to URL' and do some
javascript:window.open(blah) expression in the jump to URL. Search the
group, there are a few examples.
Andy Potter|||Here is an example for CSV format. Just remove the rs:Format and rc:Encoding
parts if you are doing HTML (HTML is the default). The
Globals!ReportServerURL allows you to not hardcode the name of your server.
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
<likong@.email.com> wrote in message
news:1137023689.498483.253560@.g14g2000cwa.googlegroups.com...
> Hi, Andy,
> Thanks for this suggestion.
> I think if I write my own application then controlling HTML device
> settings as you suggested would be easier.
> All of my users are using report manager/report server from IE
> directly. So I have to find a way to set LinkTarget to _blank (which
> becomes default) in order to create a new window. Based on BOL, I
> thought I could modify rsreportserver.config to specify LinkTarget
> under Render ... HTML extension. Unfortunately the URL at the textbox
> in SSRS 2005 is still http://...&LinkTarget=_top.
> Any idea how to set LinkTarget to _blank as default in report
> manager/report server config file?
> Thanks.
> Kong
>
> Potter wrote:
>> Kong,
>> Can you use the HTML Device Setting of LinkTarget to open all your
>> links in a new window? This would eliminate the need to right click at
>> all.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
>> Andy Potter
>|||Andy and Bruce, thanks for the great suggestion. It works perfectly.
Thanks.
Kong
Bruce L-C [MVP] wrote:
> Here is an example for CSV format. Just remove the rs:Format and rc:Encoding
> parts if you are doing HTML (HTML is the default). The
> Globals!ReportServerURL allows you to not hardcode the name of your server.
> 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
> <likong@.email.com> wrote in message
> news:1137023689.498483.253560@.g14g2000cwa.googlegroups.com...
> > Hi, Andy,
> >
> > Thanks for this suggestion.
> >
> > I think if I write my own application then controlling HTML device
> > settings as you suggested would be easier.
> >
> > All of my users are using report manager/report server from IE
> > directly. So I have to find a way to set LinkTarget to _blank (which
> > becomes default) in order to create a new window. Based on BOL, I
> > thought I could modify rsreportserver.config to specify LinkTarget
> > under Render ... HTML extension. Unfortunately the URL at the textbox
> > in SSRS 2005 is still http://...&LinkTarget=_top.
> >
> > Any idea how to set LinkTarget to _blank as default in report
> > manager/report server config file?
> >
> > Thanks.
> >
> > Kong
> >
> >
> > Potter wrote:
> >> Kong,
> >>
> >> Can you use the HTML Device Setting of LinkTarget to open all your
> >> links in a new window? This would eliminate the need to right click at
> >> all.
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
> >>
> >> Andy Potter
> >
Thursday, February 16, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment