opening reports with toggleitems set according to user defaults

i'm new to RS and have created reports with jump to url capability. the main
report has drill down capability up to 4 levels. i would like to know if it
is possible to open the report and have the toggleitems collapsed or expanded
(showing the next level if expanded) based on pre-defined choices. some
users might want drill-down expanded all the way to level 4 for some
groupings while only to level 2 on other groupings. for example, we create
financial reports that show monthly balances for staff salaries, fringe
costs, supplies, etc. a manager might want to see much detail on the staff
salaries and drill down another 2 levels to actually see staff names while
only want to see the highest level for fringe and not be concerned about how
much was paid for social security, retirement, etc..
rather than require the user each time to expand or collapse as they want
each time they run report, is there some way to save their choices to a table
and then through a query obtain their choices and set the toggleitem property
for each row based on its value.
i have found many examples of setting properties based on "value" property
but not other properties. i suspect that if it can be done, the "inscope"
function would be used. hope this makes sense!
any help you can give would be appreciated. thanksi think i found the answer to my question. RS doesn't appear to support
events and only exposes one reportitems property and that is "value". so i'm
guessing that what i'm asking is probably not possible within RS itself.
"dalem" wrote:
> i'm new to RS and have created reports with jump to url capability. the main
> report has drill down capability up to 4 levels. i would like to know if it
> is possible to open the report and have the toggleitems collapsed or expanded
> (showing the next level if expanded) based on pre-defined choices. some
> users might want drill-down expanded all the way to level 4 for some
> groupings while only to level 2 on other groupings. for example, we create
> financial reports that show monthly balances for staff salaries, fringe
> costs, supplies, etc. a manager might want to see much detail on the staff
> salaries and drill down another 2 levels to actually see staff names while
> only want to see the highest level for fringe and not be concerned about how
> much was paid for social security, retirement, etc..
> rather than require the user each time to expand or collapse as they want
> each time they run report, is there some way to save their choices to a table
> and then through a query obtain their choices and set the toggleitem property
> for each row based on its value.
> i have found many examples of setting properties based on "value" property
> but not other properties. i suspect that if it can be done, the "inscope"
> function would be used. hope this makes sense!
> any help you can give would be appreciated. thanks

Open up new window for external URL

I'm trying to use "Jump to URL" to link the report to external web site.
However, I find that there's no way to open up a new window. It seems
inconvenient for user to close the report whenever external link is clicked.
Does anyone have idea to resolve this?use target=_blank
"Edmond Lee" wrote:
> I'm trying to use "Jump to URL" to link the report to external web site.
> However, I find that there's no way to open up a new window. It seems
> inconvenient for user to close the report whenever external link is clicked.
> Does anyone have idea to resolve this?
>|||yuanxm, Thank you for your reply.
However, I had tried several time to type "target=_blank" together with URL
for "Jump to URL" insides Navigation tab and error was resulted.
Is there any trick required?
"yuanxm" wrote:
> use target=_blank
> "Edmond Lee" wrote:
> > I'm trying to use "Jump to URL" to link the report to external web site.
> > However, I find that there's no way to open up a new window. It seems
> > inconvenient for user to close the report whenever external link is clicked.
> >
> > Does anyone have idea to resolve this?
> >|||I have not personally needed to do this so I don't know from experience but
my feeling is that the solution here is where you are in another webpage
(not Reporting Services) and want to have this happen. Not when it is using
the jump to url. What you can do (and this is something I just learned this
week) is to use the ability with SP1 to use javascript. For you jump to URL
put in the following expression:
="javascript:void(window.open('http://www.google.com'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> yuanxm, Thank you for your reply.
> However, I had tried several time to type "target=_blank" together with
> URL
> for "Jump to URL" insides Navigation tab and error was resulted.
> Is there any trick required?
> "yuanxm" wrote:
>> use target=_blank
>> "Edmond Lee" wrote:
>> > I'm trying to use "Jump to URL" to link the report to external web
>> > site.
>> > However, I find that there's no way to open up a new window. It seems
>> > inconvenient for user to close the report whenever external link is
>> > clicked.
>> >
>> > Does anyone have idea to resolve this?
>> >|||This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..
Plz suggest somethng
"Bruce L-C [MVP]" wrote:
> I have not personally needed to do this so I don't know from experience but
> my feeling is that the solution here is where you are in another webpage
> (not Reporting Services) and want to have this happen. Not when it is using
> the jump to url. What you can do (and this is something I just learned this
> week) is to use the ability with SP1 to use javascript. For you jump to URL
> put in the following expression:
> ="javascript:void(window.open('http://www.google.com'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
> news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> > yuanxm, Thank you for your reply.
> >
> > However, I had tried several time to type "target=_blank" together with
> > URL
> > for "Jump to URL" insides Navigation tab and error was resulted.
> > Is there any trick required?
> >
> > "yuanxm" wrote:
> >
> >> use target=_blank
> >>
> >> "Edmond Lee" wrote:
> >>
> >> > I'm trying to use "Jump to URL" to link the report to external web
> >> > site.
> >> > However, I find that there's no way to open up a new window. It seems
> >> > inconvenient for user to close the report whenever external link is
> >> > clicked.
> >> >
> >> > Does anyone have idea to resolve this?
> >> >
>
>|||When I tried opening it on report manager, it opened 2 windows. One was
google and the other one had the
javascript:void(window.open('http://www.google.com')) on the address bar. It
was interesting!!
"NI" wrote:
> This works only on the reportserver, i.e. when i view reports
> http://servername/reportserver/... but the java scrip doesnt work when i view
> reports on the report manager like this http://servername/reports/..
> Plz suggest somethng
>
> "Bruce L-C [MVP]" wrote:
> > I have not personally needed to do this so I don't know from experience but
> > my feeling is that the solution here is where you are in another webpage
> > (not Reporting Services) and want to have this happen. Not when it is using
> > the jump to url. What you can do (and this is something I just learned this
> > week) is to use the ability with SP1 to use javascript. For you jump to URL
> > put in the following expression:
> >
> > ="javascript:void(window.open('http://www.google.com'))"
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
> > news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> > > yuanxm, Thank you for your reply.
> > >
> > > However, I had tried several time to type "target=_blank" together with
> > > URL
> > > for "Jump to URL" insides Navigation tab and error was resulted.
> > > Is there any trick required?
> > >
> > > "yuanxm" wrote:
> > >
> > >> use target=_blank
> > >>
> > >> "Edmond Lee" wrote:
> > >>
> > >> > I'm trying to use "Jump to URL" to link the report to external web
> > >> > site.
> > >> > However, I find that there's no way to open up a new window. It seems
> > >> > inconvenient for user to close the report whenever external link is
> > >> > clicked.
> > >> >
> > >> > Does anyone have idea to resolve this?
> > >> >
> >
> >
> >

Open the link in new window

When i giving a url passing some parameter..in Jump to Url of cell navigation properties..

In VS Studio its opening in new window ..but when deployed in server and its opening same browser while my requirement is to open in new window..

You need to set the LinkTarget deviceinfo to "_blank". This can be set using a url parameter or in the rsreportserver.config file.

See this link for more information on setting the device info:

http://msdn2.microsoft.com/en-us/library/ms155397.aspx

This link has information on the device info settings for the html renderer.

http://msdn2.microsoft.com/en-us/library/ms155395.aspx

|||

I have Used this code in jump to url of navigation text box void(window.open(url))" its working and had satisfied mine requirement..

sql

Open the link in new window

When i giving a url passing some parameter..in Jump to Url of cell navigation properties..

In VS Studio its opening in new window ..but when deployed in server and its opening same browser while my requirement is to open in new window..

You need to set the LinkTarget deviceinfo to "_blank". This can be set using a url parameter or in the rsreportserver.config file.

See this link for more information on setting the device info:

http://msdn2.microsoft.com/en-us/library/ms155397.aspx

This link has information on the device info settings for the html renderer.

http://msdn2.microsoft.com/en-us/library/ms155395.aspx

|||

I have Used this code in jump to url of navigation text box void(window.open(url))" its working and had satisfied mine requirement..

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.
>> >
>

Open New Window from Iframe

I am having this problem. Any thoughts?
the standard way of opening a new window using the Jump To URL
navigation feature - ie using the
="javascript:void(window.open('someURL'))" works great as long as the
report containing these links is NOT in an IFRAME. If it is, it's
treating the Javascript as the URL.
Anyone getting same results? Anyone know of a workaround?This is one I use. But, this opens it up in a new window.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
I worked with someone about a week ago who wanted to do what you do. This is
what I believed worked for him. Let's say your iframe is called main. Then
do this:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','main'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Raz" <Raz@.discussions.microsoft.com> wrote in message
news:184220F9-B42F-42B9-80F1-ED8946C29EB6@.microsoft.com...
>I am having this problem. Any thoughts?
> the standard way of opening a new window using the Jump To URL
> navigation feature - ie using the
> ="javascript:void(window.open('someURL'))" works great as long as the
> report containing these links is NOT in an IFRAME. If it is, it's
> treating the Javascript as the URL.
> Anyone getting same results? Anyone know of a workaround?
>|||Thanks for the Reply Bruce. I have read many of your posts and have already
tried opening a window using your technique. Actually the technique works
fine except for when you are opening a window from an Iframe the address bar
in the new window shows
"javascript:void(window.open('http://www.google.com','_blank'))" instead of
the url "http://www.google.com" of course the result of this is "Page cannot
be displayed"
Any thoughts?
"Bruce L-C [MVP]" wrote:
> This is one I use. But, this opens it up in a new window.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> I worked with someone about a week ago who wanted to do what you do. This is
> what I believed worked for him. Let's say your iframe is called main. Then
> do this:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','main'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Raz" <Raz@.discussions.microsoft.com> wrote in message
> news:184220F9-B42F-42B9-80F1-ED8946C29EB6@.microsoft.com...
> >I am having this problem. Any thoughts?
> >
> > the standard way of opening a new window using the Jump To URL
> > navigation feature - ie using the
> > ="javascript:void(window.open('someURL'))" works great as long as the
> > report containing these links is NOT in an IFRAME. If it is, it's
> > treating the Javascript as the URL.
> >
> > Anyone getting same results? Anyone know of a workaround?
> >
>
>|||Just to let everyone know I go this working by including &rc:linktarget=_self
in the url to the report server.
"Raz" wrote:
> Thanks for the Reply Bruce. I have read many of your posts and have already
> tried opening a window using your technique. Actually the technique works
> fine except for when you are opening a window from an Iframe the address bar
> in the new window shows
> "javascript:void(window.open('http://www.google.com','_blank'))" instead of
> the url "http://www.google.com" of course the result of this is "Page cannot
> be displayed"
> Any thoughts?
> "Bruce L-C [MVP]" wrote:
> > This is one I use. But, this opens it up in a new window.
> >
> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >
> > I worked with someone about a week ago who wanted to do what you do. This is
> > what I believed worked for him. Let's say your iframe is called main. Then
> > do this:
> >
> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > "&rs:Format=CSV&rc:Encoding=ASCII','main'))"
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Raz" <Raz@.discussions.microsoft.com> wrote in message
> > news:184220F9-B42F-42B9-80F1-ED8946C29EB6@.microsoft.com...
> > >I am having this problem. Any thoughts?
> > >
> > > the standard way of opening a new window using the Jump To URL
> > > navigation feature - ie using the
> > > ="javascript:void(window.open('someURL'))" works great as long as the
> > > report containing these links is NOT in an IFRAME. If it is, it's
> > > treating the Javascript as the URL.
> > >
> > > Anyone getting same results? Anyone know of a workaround?
> > >
> >
> >
> >