Jump to URL was working - now not working

Hello. I have javascript in a bunch of my reports so that when jumping to a
url in the action property everything would go to a new browser window.
Everything is working just fine (after I upgraded the service pack so I could
do it) but now all of a sudden it doesn't work on any of the reports. Nothing
has changed on the box and none of the reports have been touched. Everything
else appears to be working as intended.
Any ideas? Any help would be very much appreciated. Thanks!Hi can i know what is the javascript you used? There is a some change in SP1
2005RS that made to do this. Few javascript code added to the RS report
manager has been changed to support and block some feature...
"dcray" wrote:
> Hello. I have javascript in a bunch of my reports so that when jumping to a
> url in the action property everything would go to a new browser window.
> Everything is working just fine (after I upgraded the service pack so I could
> do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> has changed on the box and none of the reports have been touched. Everything
> else appears to be working as intended.
> Any ideas? Any help would be very much appreciated. Thanks!|||Hi, it wasn't until I upgraded the service pack that it would work at all,
and after applied worked fine just as anticipated. Nothing fancy, now all of
reports that use this js are broke and nothing has changed
="javascript:void(window.open('http://www.google.com'))"
I also tried specifiying the target window
="javascript:void(window.open('http://www.google.com','_blank'))"
still not working. These are the things that have been added to the box
reporting services is on since the reports were impliented and working with
the javascript in the action property:
Windows Malicious Software Removal Tool
Security Update for Microsoft Data Access Components 2.7 SP1
Cumulative Security Update for IE 6 SP1
Security Update for Windows 200
Cumulative Security Update for Outlook Express 6 SP1
just in case any of these might cause a prolblem...you never know.
thanks!!
"Bava Mani" wrote:
> Hi can i know what is the javascript you used? There is a some change in SP1
> 2005RS that made to do this. Few javascript code added to the RS report
> manager has been changed to support and block some feature...
> "dcray" wrote:
> > Hello. I have javascript in a bunch of my reports so that when jumping to a
> > url in the action property everything would go to a new browser window.
> > Everything is working just fine (after I upgraded the service pack so I could
> > do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> > has changed on the box and none of the reports have been touched. Everything
> > else appears to be working as intended.
> >
> > Any ideas? Any help would be very much appreciated. Thanks!|||I have a report I designed in RS 2000 and converted to RS 2005. I just tried
it out and it worked fine:
= "javascript:void(window.open('http://www.google.com','_blank'))"
Looks exactly the same as below.
So, might be something else but it is not RS 2005. This requires RS 2000 SP1
or greater. I have all the latest security updates at the server and the
client (Server is 2003 SP1, client XP Pro SP2).
Anyway, not a solution but at least another data point for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dcray" <dcray@.discussions.microsoft.com> wrote in message
news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> Hi, it wasn't until I upgraded the service pack that it would work at all,
> and after applied worked fine just as anticipated. Nothing fancy, now all
> of
> reports that use this js are broke and nothing has changed
> ="javascript:void(window.open('http://www.google.com'))"
> I also tried specifiying the target window
> ="javascript:void(window.open('http://www.google.com','_blank'))"
> still not working. These are the things that have been added to the box
> reporting services is on since the reports were impliented and working
> with
> the javascript in the action property:
> Windows Malicious Software Removal Tool
> Security Update for Microsoft Data Access Components 2.7 SP1
> Cumulative Security Update for IE 6 SP1
> Security Update for Windows 200
> Cumulative Security Update for Outlook Express 6 SP1
> just in case any of these might cause a prolblem...you never know.
> thanks!!
>
> "Bava Mani" wrote:
>> Hi can i know what is the javascript you used? There is a some change in
>> SP1
>> 2005RS that made to do this. Few javascript code added to the RS report
>> manager has been changed to support and block some feature...
>> "dcray" wrote:
>> > Hello. I have javascript in a bunch of my reports so that when jumping
>> > to a
>> > url in the action property everything would go to a new browser window.
>> > Everything is working just fine (after I upgraded the service pack so I
>> > could
>> > do it) but now all of a sudden it doesn't work on any of the reports.
>> > Nothing
>> > has changed on the box and none of the reports have been touched.
>> > Everything
>> > else appears to be working as intended.
>> >
>> > Any ideas? Any help would be very much appreciated. Thanks!|||turns out the problem is that some of the urls to the reports that were
getting passed around used an alias for the machine that hasn't been set up
properly as one of the host headers
"Bruce L-C [MVP]" wrote:
> I have a report I designed in RS 2000 and converted to RS 2005. I just tried
> it out and it worked fine:
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> Looks exactly the same as below.
> So, might be something else but it is not RS 2005. This requires RS 2000 SP1
> or greater. I have all the latest security updates at the server and the
> client (Server is 2003 SP1, client XP Pro SP2).
> Anyway, not a solution but at least another data point for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dcray" <dcray@.discussions.microsoft.com> wrote in message
> news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> >
> > Hi, it wasn't until I upgraded the service pack that it would work at all,
> > and after applied worked fine just as anticipated. Nothing fancy, now all
> > of
> > reports that use this js are broke and nothing has changed
> >
> > ="javascript:void(window.open('http://www.google.com'))"
> >
> > I also tried specifiying the target window
> >
> > ="javascript:void(window.open('http://www.google.com','_blank'))"
> >
> > still not working. These are the things that have been added to the box
> > reporting services is on since the reports were impliented and working
> > with
> > the javascript in the action property:
> >
> > Windows Malicious Software Removal Tool
> > Security Update for Microsoft Data Access Components 2.7 SP1
> > Cumulative Security Update for IE 6 SP1
> > Security Update for Windows 200
> > Cumulative Security Update for Outlook Express 6 SP1
> >
> > just in case any of these might cause a prolblem...you never know.
> > thanks!!
> >
> >
> >
> > "Bava Mani" wrote:
> >
> >> Hi can i know what is the javascript you used? There is a some change in
> >> SP1
> >> 2005RS that made to do this. Few javascript code added to the RS report
> >> manager has been changed to support and block some feature...
> >>
> >> "dcray" wrote:
> >>
> >> > Hello. I have javascript in a bunch of my reports so that when jumping
> >> > to a
> >> > url in the action property everything would go to a new browser window.
> >> > Everything is working just fine (after I upgraded the service pack so I
> >> > could
> >> > do it) but now all of a sudden it doesn't work on any of the reports.
> >> > Nothing
> >> > has changed on the box and none of the reports have been touched.
> >> > Everything
> >> > else appears to be working as intended.
> >> >
> >> > Any ideas? Any help would be very much appreciated. Thanks!
>
>

jump to url option with _blank

I am trying to set up a link using the navigation/hyperlink action/jump to
url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
Url).
When I click on the hyperlink, I would like the navigation target to be a
new form (_blank), NOT the existing one. I have tried the following code
with some success
="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
As you can see the actual url is contained in: " & Fields!feature_url.Value
& "
If I preview my report in Visual Studio, click on the hyperlink it will
launch a page that contains the entire line:
="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
in the browser's url field, it then launches a second page with the correct
url.
Unfortunately, it doesn't work at all from the report server...I just get a
page with the entire line and then nothing.
Does anyone know how to do this? Here's the html if that's of any use.
<Action>
<Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
& "','_blank'))"
</Hyperlink>
</Action>I create a test report and it works fine...I have SP2.
Check the post "Please Help"
Jeronimo Vogt
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:ED8D1700-FA0E-4E58-B8C4-CEC4AC367B6C@.microsoft.com...
> I am trying to set up a link using the navigation/hyperlink action/jump to
> url feature of reporting services(Right Click ->Advanced->Navigation->Jump
To
> Url).
> When I click on the hyperlink, I would like the navigation target to be a
> new form (_blank), NOT the existing one. I have tried the following code
> with some success
> ="javascript:void(window.open('" & Fields!feature_url.Value &
"','_blank'))"
> As you can see the actual url is contained in: " &
Fields!feature_url.Value
> & "
> If I preview my report in Visual Studio, click on the hyperlink it will
> launch a page that contains the entire line:
> ="javascript:void(window.open('" & Fields!feature_url.Value &
"','_blank'))"
> in the browser's url field, it then launches a second page with the
correct
> url.
> Unfortunately, it doesn't work at all from the report server...I just get
a
> page with the entire line and then nothing.
> Does anyone know how to do this? Here's the html if that's of any use.
> <Action>
> <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> & "','_blank'))"
> </Hyperlink>
> </Action>
>
>
>|||bee,
Please check the url of the first report
dont type in localhost/reorts - type <yourservername>/reports.
Hope this helps
"beeyule" wrote:
> I am trying to set up a link using the navigation/hyperlink action/jump to
> url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> Url).
> When I click on the hyperlink, I would like the navigation target to be a
> new form (_blank), NOT the existing one. I have tried the following code
> with some success
> ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> As you can see the actual url is contained in: " & Fields!feature_url.Value
> & "
> If I preview my report in Visual Studio, click on the hyperlink it will
> launch a page that contains the entire line:
> ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> in the browser's url field, it then launches a second page with the correct
> url.
> Unfortunately, it doesn't work at all from the report server...I just get a
> page with the entire line and then nothing.
> Does anyone know how to do this? Here's the html if that's of any use.
> <Action>
> <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> & "','_blank'))"
> </Hyperlink>
> </Action>
>
>
>|||"RP" wrote:
> bee,
> Please check the url of the first report
> dont type in localhost/reorts - type <yourservername>/reports.
> Hope this helps
> "beeyule" wrote:
> > I am trying to set up a link using the navigation/hyperlink action/jump to
> > url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> > Url).
> >
> > When I click on the hyperlink, I would like the navigation target to be a
> > new form (_blank), NOT the existing one. I have tried the following code
> > with some success
> >
> > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> >
> > As you can see the actual url is contained in: " & Fields!feature_url.Value
> > & "
> >
> > If I preview my report in Visual Studio, click on the hyperlink it will
> > launch a page that contains the entire line:
> >
> > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> >
> > in the browser's url field, it then launches a second page with the correct
> > url.
> >
> > Unfortunately, it doesn't work at all from the report server...I just get a
> > page with the entire line and then nothing.
> >
> > Does anyone know how to do this? Here's the html if that's of any use.
> >
> > <Action>
> > <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> > & "','_blank'))"
> > </Hyperlink>
> > </Action>
> >
> >
> >
> >
> >
> >
bee,
> Please check the url of the first report
> dont type in localhost/reorts - type <yourservername>/reports.
I have sp4...
I'm not typing in the localhost address. The url to the report server is
determined by the "Fields!feature_url.Value" field.
The report itself opens without incident. When I click on the hyperlink
located within the report column I get a directed to a web page with the url:
javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
the url contained within the code is correct, it just doesn't behave the way
I had anticipated.|||We are on SP1 and found the "LinkTarget" property does NOT work the way it is
supposed to on the report server (be careful when testing in the Visual
Studio designer - it opens a new page because you are running in VS.)
The Javascript code to open a new window does NOT work in SP1. SP2 is
supposed to have fixed this - I have not yet found out if that is actually
the case.
Tom
"beeyule" wrote:
>
> "RP" wrote:
> > bee,
> > Please check the url of the first report
> > dont type in localhost/reorts - type <yourservername>/reports.
> >
> > Hope this helps
> >
> > "beeyule" wrote:
> >
> > > I am trying to set up a link using the navigation/hyperlink action/jump to
> > > url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> > > Url).
> > >
> > > When I click on the hyperlink, I would like the navigation target to be a
> > > new form (_blank), NOT the existing one. I have tried the following code
> > > with some success
> > >
> > > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> > >
> > > As you can see the actual url is contained in: " & Fields!feature_url.Value
> > > & "
> > >
> > > If I preview my report in Visual Studio, click on the hyperlink it will
> > > launch a page that contains the entire line:
> > >
> > > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> > >
> > > in the browser's url field, it then launches a second page with the correct
> > > url.
> > >
> > > Unfortunately, it doesn't work at all from the report server...I just get a
> > > page with the entire line and then nothing.
> > >
> > > Does anyone know how to do this? Here's the html if that's of any use.
> > >
> > > <Action>
> > > <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> > > & "','_blank'))"
> > > </Hyperlink>
> > > </Action>
> > >
> > >
> > >
> > >
> > >
> > >
> bee,
> > Please check the url of the first report
> > dont type in localhost/reorts - type <yourservername>/reports.
>
> I have sp4...
> I'm not typing in the localhost address. The url to the report server is
> determined by the "Fields!feature_url.Value" field.
> The report itself opens without incident. When I click on the hyperlink
> located within the report column I get a directed to a web page with the url:
> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
> the url contained within the code is correct, it just doesn't behave the way
> I had anticipated.
>
>|||Hmm, not sure why it isn't working correctly for you. I suspect something in
how you are creating the URL. Are you using jump to URL? I have had this
working in both SP1 and SP2 and I know others have as well. Here is a URL
that works for me (opening a new window). One thing to note, it does not
work from VS, you have to deploy it. Try copying and pasting the below into
the jump to URL and give it a try.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ASP Yaboh" <ASPYaboh@.discussions.microsoft.com> wrote in message
news:8F5897A0-09D1-4565-8573-5ADCE6191360@.microsoft.com...
> We are on SP1 and found the "LinkTarget" property does NOT work the way it
> is
> supposed to on the report server (be careful when testing in the Visual
> Studio designer - it opens a new page because you are running in VS.)
> The Javascript code to open a new window does NOT work in SP1. SP2 is
> supposed to have fixed this - I have not yet found out if that is actually
> the case.
> Tom
> "beeyule" wrote:
>>
>> "RP" wrote:
>> > bee,
>> > Please check the url of the first report
>> > dont type in localhost/reorts - type <yourservername>/reports.
>> >
>> > Hope this helps
>> >
>> > "beeyule" wrote:
>> >
>> > > I am trying to set up a link using the navigation/hyperlink
>> > > action/jump to
>> > > url feature of reporting services(Right
>> > > Click ->Advanced->Navigation->Jump To
>> > > Url).
>> > >
>> > > When I click on the hyperlink, I would like the navigation target to
>> > > be a
>> > > new form (_blank), NOT the existing one. I have tried the following
>> > > code
>> > > with some success
>> > >
>> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
>> > > "','_blank'))"
>> > >
>> > > As you can see the actual url is contained in: " &
>> > > Fields!feature_url.Value
>> > > & "
>> > >
>> > > If I preview my report in Visual Studio, click on the hyperlink it
>> > > will
>> > > launch a page that contains the entire line:
>> > >
>> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
>> > > "','_blank'))"
>> > >
>> > > in the browser's url field, it then launches a second page with the
>> > > correct
>> > > url.
>> > >
>> > > Unfortunately, it doesn't work at all from the report server...I just
>> > > get a
>> > > page with the entire line and then nothing.
>> > >
>> > > Does anyone know how to do this? Here's the html if that's of any
>> > > use.
>> > >
>> > > <Action>
>> > > <Hyperlink>="javascript:void(window.open('" &
>> > > Fields!feature_url.Value
>> > > & "','_blank'))"
>> > > </Hyperlink>
>> > > </Action>
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> bee,
>> > Please check the url of the first report
>> > dont type in localhost/reorts - type <yourservername>/reports.
>>
>> I have sp4...
>> I'm not typing in the localhost address. The url to the report server is
>> determined by the "Fields!feature_url.Value" field.
>> The report itself opens without incident. When I click on the hyperlink
>> located within the report column I get a directed to a web page with the
>> url:
>> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
>> the url contained within the code is correct, it just doesn't behave the
>> way
>> I had anticipated.
>>
>>|||I'm pretty certain we thoroughly flogged this issue, but I will deploy a test
report later today with that exact link just to be certain.
Thank you.
"Bruce L-C [MVP]" wrote:
> Hmm, not sure why it isn't working correctly for you. I suspect something in
> how you are creating the URL. Are you using jump to URL? I have had this
> working in both SP1 and SP2 and I know others have as well. Here is a URL
> that works for me (opening a new window). One thing to note, it does not
> work from VS, you have to deploy it. Try copying and pasting the below into
> the jump to URL and give it a try.
> = "javascript:void(window.open('http://www.google.com','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ASP Yaboh" <ASPYaboh@.discussions.microsoft.com> wrote in message
> news:8F5897A0-09D1-4565-8573-5ADCE6191360@.microsoft.com...
> > We are on SP1 and found the "LinkTarget" property does NOT work the way it
> > is
> > supposed to on the report server (be careful when testing in the Visual
> > Studio designer - it opens a new page because you are running in VS.)
> >
> > The Javascript code to open a new window does NOT work in SP1. SP2 is
> > supposed to have fixed this - I have not yet found out if that is actually
> > the case.
> >
> > Tom
> >
> > "beeyule" wrote:
> >
> >>
> >>
> >> "RP" wrote:
> >>
> >> > bee,
> >> > Please check the url of the first report
> >> > dont type in localhost/reorts - type <yourservername>/reports.
> >> >
> >> > Hope this helps
> >> >
> >> > "beeyule" wrote:
> >> >
> >> > > I am trying to set up a link using the navigation/hyperlink
> >> > > action/jump to
> >> > > url feature of reporting services(Right
> >> > > Click ->Advanced->Navigation->Jump To
> >> > > Url).
> >> > >
> >> > > When I click on the hyperlink, I would like the navigation target to
> >> > > be a
> >> > > new form (_blank), NOT the existing one. I have tried the following
> >> > > code
> >> > > with some success
> >> > >
> >> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
> >> > > "','_blank'))"
> >> > >
> >> > > As you can see the actual url is contained in: " &
> >> > > Fields!feature_url.Value
> >> > > & "
> >> > >
> >> > > If I preview my report in Visual Studio, click on the hyperlink it
> >> > > will
> >> > > launch a page that contains the entire line:
> >> > >
> >> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
> >> > > "','_blank'))"
> >> > >
> >> > > in the browser's url field, it then launches a second page with the
> >> > > correct
> >> > > url.
> >> > >
> >> > > Unfortunately, it doesn't work at all from the report server...I just
> >> > > get a
> >> > > page with the entire line and then nothing.
> >> > >
> >> > > Does anyone know how to do this? Here's the html if that's of any
> >> > > use.
> >> > >
> >> > > <Action>
> >> > > <Hyperlink>="javascript:void(window.open('" &
> >> > > Fields!feature_url.Value
> >> > > & "','_blank'))"
> >> > > </Hyperlink>
> >> > > </Action>
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >>
> >> bee,
> >> > Please check the url of the first report
> >> > dont type in localhost/reorts - type <yourservername>/reports.
> >>
> >>
> >> I have sp4...
> >>
> >> I'm not typing in the localhost address. The url to the report server is
> >> determined by the "Fields!feature_url.Value" field.
> >>
> >> The report itself opens without incident. When I click on the hyperlink
> >> located within the report column I get a directed to a web page with the
> >> url:
> >>
> >> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
> >>
> >> the url contained within the code is correct, it just doesn't behave the
> >> way
> >> I had anticipated.
> >>
> >>
> >>
> >>
>
>

jump to URL navigation feature

I am using the navigation/hyperlink action/jump to url feature of reporting services(Right Click ->Advanced->Navigation->Jump To Url).In my environment the url comes from the database so I use thefollowing code in the "jump to url" field: =Fields!feature_url.Value.
I want to open a new window(_blank) when I click on the link but am having difficulties. I found some code
"void(window.open('& =Fields!feature_url &','_blank'))"
but haven't yet gotten it to work. I am entering this code directly into the "jump to url" field.
Does anyone have any ideas?
I left out a bit of important info...
If I use this:
="javascript:void(window.open('http://www.google.com','_blank'))"
I will be properly directed to google, so it looks like this piece ofcode works. I'm having trouble replacing the google urlwith "=Fields!feature_url.Value"

|||Hi, I don't know how you manage to have that piece of javascript working... I copy/pasted the string you posted and it is taked as a URL literally ... so obviosly it doesn't work.
I want that the Report show itself in an IFRAME and not in a new window, but should be just changing the TARGET property in the windows.open, isn't it?
May be this is a problem with my OS... Win2003 Server.
If you could help me... I'll be grateful.
Thanks in advance,
Matías|||

To call up a javascript window link from the "Jump To URL" functionality in Reporting Services SP2 Hotfix 1 applied, use:
="javascript:void(window.open('" & Fields!feature_url &"','_blank'))"
If you want it to direct to an iframe, make your iframe on your page:
<iframe name="MyFrameName"></iframe>
and make your link:
="javascript:void(window.open('" & Fields!feature_url &"','MyFrameName'))"
This works in IE6, but I can't say for the other browsers.

|||

The reportviewer control has an attribute named "HyperlinkTarget"

so Yo can have somthing like:

<rsweb:ReportViewerID="reportViewer"runat="server"Font-Names="Verdana"Font-Size="8pt"

Width="100%"Height="800px"HyperlinkTarget="_blank">

</rsweb:ReportViewer>

Jump to URL Error

I'm trying to put a hyperlink in a field on a report. I've found the action property and set the "Jump To" box with the following:

="http://dveowb01.wbhq.com/UnitsStatusLog/StatusEntry.aspx?Unit=" & Fields!Unit.Value

I'm getting this error message:

The Hyperlink expression for the textbox ‘textbox24’ refers to the field ‘Unit’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

Please help.

Thanks,

Jennifer

1. Click View -> Datasets from within your report server project.
2. Expand the dataset that is associated with the table or matrix in your report that this field references.

3. If the Unit field is not in the list for that dataset, right click the dataset and then click refresh. The field should now appear in the list.

4. Rebuild and deploy the report.

|||

If the text box that you have set the property on is not in a data region (list, table, or matrix) you will need to use an aggregator to access values from a dataset. Either add the text box to a list and let the list provide you with one copy of the text box for each item in the data set or change your formula to:

Code Snippet

="http://dveowb01.wbhq.com/UnitsStatusLog/StatusEntry.aspx?Unit="&First(Fields!Unit.Value)

and the first value will be used. A real easy way to get the expression, including scoping string, is to drag the field onto your report from the Datasets tab to your report. This will create a text box with an aggregator expression (first or sum) as the value.

To create a list and bind it to your data set, add the list and then on the properties tab (hit F4 if you don't see it) set the DataSetName property to be the data set with the field 'Unit'. Add your current text box to the list by dragging it over the list and dropping it once the pointer changes to the arrow with the attached small box.

Good luck!

Larry

Jump to URL and pass parameter

I would like to jump to a URL like UPS and pass in a value (tracking number).
Is there a way to do this under the "action" of the field I would like to
pass? "Jump to Report" allows parameters but "Jump to URL" does not resolve
the actual field values.
--
Thanks in advance,
JohnHere is the specific example for the issue described. In ther Report Layout,
I select a specific field and in the properties window "action" I enter the
URL below in the "Jump to URL" option.
http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
When executing the report, clicking in the actual value passes the URL
exactly as shown above instead of converting Fields!TrackingNumber.Value to
the actual value.
Is there an alternate way to accomplish this?
Thanks,
John|||You have to turn this into an expression:
="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
Fields!TrackingNumber.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.com...
> Here is the specific example for the issue described. In ther Report
Layout,
> I select a specific field and in the properties window "action" I enter
the
> URL below in the "Jump to URL" option.
>
http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
> When executing the report, clicking in the actual value passes the URL
> exactly as shown above instead of converting Fields!TrackingNumber.Value
to
> the actual value.
> Is there an alternate way to accomplish this?
> Thanks,
> John
>|||Thanks Bruce, that did it.
"Bruce L-C [MVP]" wrote:
> You have to turn this into an expression:
> ="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
> Fields!TrackingNumber.Value
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John K" <JohnK@.discussions.microsoft.com> wrote in message
> news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.com...
> > Here is the specific example for the issue described. In ther Report
> Layout,
> > I select a specific field and in the properties window "action" I enter
> the
> > URL below in the "Jump to URL" option.
> >
> >
> http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=%20Fields!TrackingNumber.Value
> >
> > When executing the report, clicking in the actual value passes the URL
> > exactly as shown above instead of converting Fields!TrackingNumber.Value
> to
> > the actual value.
> >
> > Is there an alternate way to accomplish this?
> >
> > Thanks,
> > John
> >
> >
>
>

Jump to URL Action in a New Window

I've read countless postings now but haven't yet found an answer to this frequently asked question: "When using the Jump to URL option in the Action property of a textbox, how do you make that URL open in a new window?" Is it possible?Have you tried the LinkTarget HTML format DeviceInfo setting? I know you
can make hyperlinks open in a new window but I don't know if this will work
for jump to URL. I assume it will :)
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"ToxicDice" <ToxicDice@.discussions.microsoft.com> wrote in message
news:E551A617-1589-4386-8E6C-49B67A5AC386@.microsoft.com...
> I've read countless postings now but haven't yet found an answer to this
frequently asked question: "When using the Jump to URL option in the Action
property of a textbox, how do you make that URL open in a new window?" Is
it possible?

Jump to URL - New Window - Ampersand

I have a Jump to URL hyperlink action using the "javascript:
void(window.open)" code. This works great, except when one of the parameters
contains an ampersand. I get an error saying that the "path of the item is
not valid. The full path must be less than 260 characters long, muster start
with slash..."
One of my parameters for the report that first comes up is
"OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
passing this to the URL as listed below. It only fails if there is that
ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
replacing the "&" with %26 but I can't get that to work.
This works fine if I use a "Jump to Report" and pass the parameters that
way, but I need to pop up the report in a new window.
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
Thanks for any advice anyone cares to offer!Parameter values must be URLEncoded. Please perform the following steps:
* load the report in report designer
* go to the report menu -> report properties -> References tab
* in the "References:" list, add a reference to System.Web, and click OK
* in the report, modify your expression to use the HttpUtility.UrlEncode
function (see MSDN:
http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
"&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"kaibh" <kaibh@.discussions.microsoft.com> wrote in message
news:7EAE0CF0-2C9C-47A8-8A2D-B5861AFA5740@.microsoft.com...
>I have a Jump to URL hyperlink action using the "javascript:
> void(window.open)" code. This works great, except when one of the
> parameters
> contains an ampersand. I get an error saying that the "path of the item
> is
> not valid. The full path must be less than 260 characters long, muster
> start
> with slash..."
> One of my parameters for the report that first comes up is
> "OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
> passing this to the URL as listed below. It only fails if there is that
> ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
> replacing the "&" with %26 but I can't get that to work.
> This works fine if I use a "Jump to Report" and pass the parameters that
> way, but I need to pop up the report in a new window.
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value
> &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> Thanks for any advice anyone cares to offer!
>|||Robert, thanks for the feedback, however I'm still getting the same error:
Reporting Services Error
The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
path must be less than 260 characters long, must start with slash; other
restrictions apply. Check the documentation for complete set of restrictions.
(rsInvalidItemPath)
The HTML generated for this link looks like:
<a style="text-decoration:none;color:Black"
href="javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
But since I'm still getting this error, I assume there must be something else
that I'm missing.
Thanks
"Robert Bruckner [MSFT]" wrote:
> Parameter values must be URLEncoded. Please perform the following steps:
> * load the report in report designer
> * go to the report menu -> report properties -> References tab
> * in the "References:" list, add a reference to System.Web, and click OK
> * in the report, modify your expression to use the HttpUtility.UrlEncode
> function (see MSDN:
> http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.|||I also am trying to do this. It works great in the IDE, but I get the
following error when publishing the report to Report Manager on my local
machine and any servers.
Request for the permission of type System.Web.AspNetHostingPermission,
System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
It is probably permissions. How would I modify rssrvpolicy.config to allow
the execution of System.Web assembly?
Dan Bock
"kaibh" wrote:
> Robert, thanks for the feedback, however I'm still getting the same error:
> Reporting Services Error
> The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
> path must be less than 260 characters long, must start with slash; other
> restrictions apply. Check the documentation for complete set of restrictions.
> (rsInvalidItemPath)
> The HTML generated for this link looks like:
> <a style="text-decoration:none;color:Black"
> href="http://links.10026.com/?link=javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
> The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
> But since I'm still getting this error, I assume there must be something else
> that I'm missing.
> Thanks
>
> "Robert Bruckner [MSFT]" wrote:
> > Parameter values must be URLEncoded. Please perform the following steps:
> > * load the report in report designer
> > * go to the report menu -> report properties -> References tab
> > * in the "References:" list, add a reference to System.Web, and click OK
> > * in the report, modify your expression to use the HttpUtility.UrlEncode
> > function (see MSDN:
> > http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> > ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> > Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> > System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> > "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> > "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
>

Jump to report, Parameters visible

I have an action in my report: jump to report. It works great!
However - I don't want to collapse the parameters... when I jump.
How do I achieve that?
I know with SP1, the parameters are collapsed, but available. I want
to 'uncollapse' them.
ThanksYou need to use the URL Access instead (at least that is the only way I
found to do it). Note that you can use some of the global variables with the
expression builder to create this on the fly (so it changes with wherever it
is deployed.
http://servername/Reports/Pages/Report.aspx?ServerUrl=http://servername/ReportServer%3f/directoryname%252fReportName&Parameter1=blahblah&rc:Parameters=True
Bruce L-C
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407141011.7b716b31@.posting.google.com...
> I have an action in my report: jump to report. It works great!
> However - I don't want to collapse the parameters... when I jump.
> How do I achieve that?
> I know with SP1, the parameters are collapsed, but available. I want
> to 'uncollapse' them.
> Thanks

Jump to Report Without Parameters

Hi,

Is there any way in Rs2000 "Jump to Report" Action, to pass only some off the target report parameters, and when the report opens fill the rest from the target report parameter area?

I can make this work in VS2003 but not in Report Manager.

In Report Manager when you click the link it just clear the screen and stays like that.

Thank you for your help

Rgranada

i do have a crude way of doing it and i still looking out for the best way to do it.

for example, lets take @.Empno is the parameter and u want to make it optional

so declare another variable like @.ES

when u r passing employee number , then pass @.ES = 'S' ( means selected)

when u do not want to use @.EmpNO , then pass @.ES = 'A' (means all)

use in ur query

where (@.EmpNo = '123' and @.ES = 'S') or (@.EmpNo like '%' and @.ES = 'A')

hope this works for u

Jump to Report Parameters not passing correctly defualt values use

I have a Report with a chart on it and have a Jump to report setup on the
Action tab of the Chart control. I pass the report Parameters in the Jump to
Report. My problem is that if I have defualt values for the report
parameters, when I pass values in the Jump to report they get over written by
the defualt values. If I remove
the Defualt values my report parameters get passed correctly with the Jump
to report. Do defualt values over ride report Parameters that are passed in
the jump to report command? Can I make it so that defualt values will only
get used if I do not pass in a value to the report?
MikeIf you dont provide any value during drill-through then only it will take the
default values. If you provide some value then it will take that value. Check
if you are passing all the parameter to the Dill-Through report. If any
parameter is missing then the drill-throught report will take the default
value provided . This defult value is of the drill-through defaul value not
the parent report default value.
"Hotwheels" wrote:
> I have a Report with a chart on it and have a Jump to report setup on the
> Action tab of the Chart control. I pass the report Parameters in the Jump to
> Report. My problem is that if I have defualt values for the report
> parameters, when I pass values in the Jump to report they get over written by
> the defualt values. If I remove
> the Defualt values my report parameters get passed correctly with the Jump
> to report. Do defualt values over ride report Parameters that are passed in
> the jump to report command? Can I make it so that defualt values will only
> get used if I do not pass in a value to the report?
> Mike|||If I am passing a report parameter it does not seem to work like you say and
I have to remove the defualt value to get it to work.
If I pass the Field value of the chart it works like you say.
I tried this with a report with one Report parameter to make it easy.
Why would passing a report Parameter cause a problem?
"Bava Mani" wrote:
> If you dont provide any value during drill-through then only it will take the
> default values. If you provide some value then it will take that value. Check
> if you are passing all the parameter to the Dill-Through report. If any
> parameter is missing then the drill-throught report will take the default
> value provided . This defult value is of the drill-through defaul value not
> the parent report default value.
> "Hotwheels" wrote:
> > I have a Report with a chart on it and have a Jump to report setup on the
> > Action tab of the Chart control. I pass the report Parameters in the Jump to
> > Report. My problem is that if I have defualt values for the report
> > parameters, when I pass values in the Jump to report they get over written by
> > the defualt values. If I remove
> > the Defualt values my report parameters get passed correctly with the Jump
> > to report. Do defualt values over ride report Parameters that are passed in
> > the jump to report command? Can I make it so that defualt values will only
> > get used if I do not pass in a value to the report?
> >
> > Mike

Jump to Report Parameters collapsed

Hi
I am using a jump through report action to call a sub report. The main
report has the paramters displayed but for the sub report the section
where the parameters are displayed is collapsed. Is there a way to
change this behaviour for the second report, my users will want to
know where the parameters are.
A second question, how to you go back to the first report without
coding another jump to report action. In the development environment
(visual studio) there is a nice blue button that you can use to go
back. Once again my users will not want to use the back button on
internet explorer.
I am using SQL 2005 RS with service pack 2 and am displaying the
reports via report viewer control.
ThanksUse Jump to URL instead of jump to report. You have full control over the
URL which includes collapsing or not the parameter area. Read up on URL
integration on Books Online. One option for this is that you can if you want
open up a new window. Then they can just shut down the window when they are
done. Some examples for you of Jump to URL
Jump to URL gives you more control than jump to report.
For the first two examples be careful with the single and double quotes.
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=Excel','_blank'))"
This comes up as html (default format) in a separate window
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value','_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
As far as not using the IE back button? Not sure why that is a requirement.
Pretty much everyone know how to do that and if they don't you would have to
train them for an alternative method so train them about the back button.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<trevor.howe@.engenoil.com> wrote in message
news:1191587402.088348.21130@.r29g2000hsg.googlegroups.com...
> Hi
> I am using a jump through report action to call a sub report. The main
> report has the paramters displayed but for the sub report the section
> where the parameters are displayed is collapsed. Is there a way to
> change this behaviour for the second report, my users will want to
> know where the parameters are.
> A second question, how to you go back to the first report without
> coding another jump to report action. In the development environment
> (visual studio) there is a nice blue button that you can use to go
> back. Once again my users will not want to use the back button on
> internet explorer.
> I am using SQL 2005 RS with service pack 2 and am displaying the
> reports via report viewer control.
> Thanks
>|||On Oct 5, 4:02 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Use Jump to URL instead of jump to report. You have full control over the
> URL which includes collapsing or not the parameter area. Read up on URL
> integration on Books Online. One option for this is that you can if you want
> open up a new window. Then they can just shut down the window when they are
> done. Some examples for you of Jump to URL
> Jump to URL gives you more control than jump to report.
> For the first two examples be careful with the single and double quotes.
> 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=Excel','_blank'))"
> This comes up as html (default format) in a separate window
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value','_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
> As far as not using the IE back button? Not sure why that is a requirement.
> Pretty much everyone know how to do that and if they don't you would have to
> train them for an alternative method so train them about the back button.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <trevor.h...@.engenoil.com> wrote in message
> news:1191587402.088348.21130@.r29g2000hsg.googlegroups.com...
>
> > Hi
> > I am using a jump through report action to call a sub report. The main
> > report has the paramters displayed but for the sub report the section
> > where the parameters are displayed is collapsed. Is there a way to
> > change this behaviour for the second report, my users will want to
> > know where the parameters are.
> > A second question, how to you go back to the first report without
> > coding another jump to report action. In the development environment
> > (visual studio) there is a nice blue button that you can use to go
> > back. Once again my users will not want to use the back button on
> > internet explorer.
> > I am using SQL 2005 RS with service pack 2 and am displaying the
> > reports via report viewer control.
> > Thanks- Hide quoted text -
> - Show quoted text -
Thanks Bruce. I am aware of using Jump to URL as a solution and also
of using the back button and I will most probably have to resort to
these "plan b" options. I am really trying to get Reporting Services
to fly in my organisation but I battle to understand why seemingly
little things like the above cant be resolved in future service packs
or releases, i.e.:
1. If Jump to URL is the only way of handling parameter passing
between reports, why is there a Jump to Report action at all. In my
case I am trying to create a dashboard type solution where there are 4
reports involved with each parent report passing parameter values
(combinations of its parameters and field values) down to the child
report.
2. Why is there a nice blue back button in the design environment and
not in the web environment. Yes, my users can use the back button but
we also do other web development where using the back button is
discouraged because it causes post back problems.
If you have any clout, maybe you could suggest some "enhancements" to
an already great product.|||Back up a little. Your first posting was a complaint about not showing the
parameters section. NOT that you had a problem passing parameters. Jump to
Report definitely allows passing parameters. It would be useless if it did
not. When you select jump to report and pick the report to jump to RS
provides a screen for mapping the parameters to whatever you want. Go back
and look for that. Are you having trouble with this?
So, you can use jump to report and take the default behaviour of how RS
shows the report. Or you can use Jump to URL and have full control of how it
shows the report. Either method can easily map parameters.
As far as the development environment being different, well, it is the
development environment and it is not IE.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<trevor.howe@.engenoil.com> wrote in message
news:1191820071.879175.230190@.g4g2000hsf.googlegroups.com...
Snip
> Thanks Bruce. I am aware of using Jump to URL as a solution and also
> of using the back button and I will most probably have to resort to
> these "plan b" options. I am really trying to get Reporting Services
> to fly in my organisation but I battle to understand why seemingly
> little things like the above cant be resolved in future service packs
> or releases, i.e.:
> 1. If Jump to URL is the only way of handling parameter passing
> between reports, why is there a Jump to Report action at all. In my
> case I am trying to create a dashboard type solution where there are 4
> reports involved with each parent report passing parameter values
> (combinations of its parameters and field values) down to the child
> report.
> 2. Why is there a nice blue back button in the design environment and
> not in the web environment. Yes, my users can use the back button but
> we also do other web development where using the back button is
> discouraged because it causes post back problems.
> If you have any clout, maybe you could suggest some "enhancements" to
> an already great product.
>|||On Oct 8, 2:25 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Back up a little. Your first posting was a complaint about not showing the
> parameters section. NOT that you had a problem passing parameters. Jump to
> Report definitely allows passing parameters. It would be useless if it did
> not. When you select jump to report and pick the report to jump to RS
> provides a screen for mapping the parameters to whatever you want. Go back
> and look for that. Are you having trouble with this?
> So, you can use jump to report and take the default behaviour of how RS
> shows the report. Or you can use Jump to URL and have full control of how it
> shows the report. Either method can easily map parameters.
> As far as the development environment being different, well, it is the
> development environment and it is not IE.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <trevor.h...@.engenoil.com> wrote in message
> news:1191820071.879175.230190@.g4g2000hsf.googlegroups.com...
> Snip
>
>
> > Thanks Bruce. I am aware of using Jump to URL as a solution and also
> > of using the back button and I will most probably have to resort to
> > these "plan b" options. I am really trying to get Reporting Services
> > to fly in my organisation but I battle to understand why seemingly
> > little things like the above cant be resolved in future service packs
> > or releases, i.e.:
> > 1. If Jump to URL is the only way of handling parameter passing
> > between reports, why is there a Jump to Report action at all. In my
> > case I am trying to create a dashboard type solution where there are 4
> > reports involved with each parent report passing parameter values
> > (combinations of its parameters and field values) down to the child
> > report.
> > 2. Why is there a nice blue back button in the design environment and
> > not in the web environment. Yes, my users can use the back button but
> > we also do other web development where using the back button is
> > discouraged because it causes post back problems.
> > If you have any clout, maybe you could suggest some "enhancements" to
> > an already great product.- Hide quoted text -
> - Show quoted text -
Ok, lets go back to the original mail. I am aware that parameters can
work with Jump to Report and Jump to Url. I have 4 reports with report
1 calling report 2, report 2 calling report 3 and report 3 calling
report 4. Report 1 shows the parameter selection criteria - beautiful.
When I click on a hyperlink within report 1 that calls the jump to
report action for report2, the parameter selection screen in Report 2
is hidden. It gets even worse for report 4 which contains about 4
different parameters. Yes, I could use jump to url but I prefer the
jump to report action (you dont have to doctor the string value to
cater for spaces, etc).
On the back button issue, remember SQL 2000 Reporting services did not
have a nice print feature and we had to rely on the clunky way that
printig in IE. Well enough people complained about it and now there is
a nice print control on the toolbar. What could be so difficult about
putting a back button on the toolbar that navigates back to the parent
report,
Forgive my gripes but I can see by your title that you might just be
able to remove these kind of frustrations in future releases of RS.
Heres hoping..|||Sorry, I thought you wanted to know how to show the parameter section. I
didn't realize you just wanted to complain.
Sum total of your complaint. You don't like using jump to URL even though it
does what you want. You don't like the users using the Internet explorer
back button even though that is a standard way to go backward to another web
page.
If you want to complain fine do so, don't write your posting like you want
help and then get snarky with me.
Also, complaining here is pretty much useless. Very few MS people hang out
here. Here is an official link for complaints/suggestions:
http://connect.microsoft.com/
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<trevor.howe@.engenoil.com> wrote in message
news:1192007368.106861.284440@.d55g2000hsg.googlegroups.com...
> On Oct 8, 2:25 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Back up a little. Your first posting was a complaint about not showing
>> the
>> parameters section. NOT that you had a problem passing parameters. Jump
>> to
>> Report definitely allows passing parameters. It would be useless if it
>> did
>> not. When you select jump to report and pick the report to jump to RS
>> provides a screen for mapping the parameters to whatever you want. Go
>> back
>> and look for that. Are you having trouble with this?
>> So, you can use jump to report and take the default behaviour of how RS
>> shows the report. Or you can use Jump to URL and have full control of how
>> it
>> shows the report. Either method can easily map parameters.
>> As far as the development environment being different, well, it is the
>> development environment and it is not IE.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <trevor.h...@.engenoil.com> wrote in message
>> news:1191820071.879175.230190@.g4g2000hsf.googlegroups.com...
>> Snip
>>
>>
>> > Thanks Bruce. I am aware of using Jump to URL as a solution and also
>> > of using the back button and I will most probably have to resort to
>> > these "plan b" options. I am really trying to get Reporting Services
>> > to fly in my organisation but I battle to understand why seemingly
>> > little things like the above cant be resolved in future service packs
>> > or releases, i.e.:
>> > 1. If Jump to URL is the only way of handling parameter passing
>> > between reports, why is there a Jump to Report action at all. In my
>> > case I am trying to create a dashboard type solution where there are 4
>> > reports involved with each parent report passing parameter values
>> > (combinations of its parameters and field values) down to the child
>> > report.
>> > 2. Why is there a nice blue back button in the design environment and
>> > not in the web environment. Yes, my users can use the back button but
>> > we also do other web development where using the back button is
>> > discouraged because it causes post back problems.
>> > If you have any clout, maybe you could suggest some "enhancements" to
>> > an already great product.- Hide quoted text -
>> - Show quoted text -
> Ok, lets go back to the original mail. I am aware that parameters can
> work with Jump to Report and Jump to Url. I have 4 reports with report
> 1 calling report 2, report 2 calling report 3 and report 3 calling
> report 4. Report 1 shows the parameter selection criteria - beautiful.
> When I click on a hyperlink within report 1 that calls the jump to
> report action for report2, the parameter selection screen in Report 2
> is hidden. It gets even worse for report 4 which contains about 4
> different parameters. Yes, I could use jump to url but I prefer the
> jump to report action (you dont have to doctor the string value to
> cater for spaces, etc).
> On the back button issue, remember SQL 2000 Reporting services did not
> have a nice print feature and we had to rely on the clunky way that
> printig in IE. Well enough people complained about it and now there is
> a nice print control on the toolbar. What could be so difficult about
> putting a back button on the toolbar that navigates back to the parent
> report,
> Forgive my gripes but I can see by your title that you might just be
> able to remove these kind of frustrations in future releases of RS.
> Heres hoping..
>

Jump to report in new window?

Hi all,

Is it possible to use the "jump to report " action and have the report open in a new window?

regards,

Bill

lil' bump|||Does anyone know the answer to this question?|||

Check out this thread. It should help you out.

http://tek-tips.com/viewthread.cfm?qid=1367703&page=1

regards

sql

Jump to report in new window?

Hi all,

Is it possible to use the "jump to report " action and have the report open in a new window?

regards,

Bill

lil' bump|||Does anyone know the answer to this question?|||

Check out this thread. It should help you out.

http://tek-tips.com/viewthread.cfm?qid=1367703&page=1

regards

Jump to Report Action for Textbox fails when Textbox is in Report Header

When I put a textbox in the report header with a Jump to Report Action,
it works fine in the Preview in VS, but when it is actually uploaded,
clicking on it results in:
The path of the item "(null)" is not valid. The path must be less than
260 characters long and must start with slash. Other restrictions
apply. (rsInvalidItemPath)
Works fine when the textbox is in the report body. Anyone else having
this problem?
-WilliamAny solution to this one? Or better yet, is it noted somewhere as a bug in
the product?
thanks!
Michael R.
"nimitt" wrote:
> I am having the exact same problem... I'm using the latest service packs.
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
>

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.sql