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 not working

Hello .. I did exaclty what you said to display a HyperLink with the JUMP to
URL. The report works fine but no Hyperlink . Is there some other setup to do
so it can works .Is it that you are asking the underline like hyperlink ? then you need to
underline it to look like hyperlink if you are asking about the hyperlink
itself then you need to check for that particular textbox properties check
the "Action" and select Jump to URL. Moreover check the "Jump to URL" after
deploying on a server and test and not from preview
Amarnath
"DJ" wrote:
> Hello .. I did exaclty what you said to display a HyperLink with the JUMP to
> URL. The report works fine but no Hyperlink . Is there some other setup to do
> so it can works .

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 - 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 URL - Base URL portion

I need to make the hyperlink from the report based on the current virtual direcrory.

If I do not havehttp://server/virtualdirectory/ in the expression, it will not make it hyperlink.

But if I hard code it, when I move to production I will need to change it.

I can make it a parameter and fill it in the load but I am looking for a code solution that will make it smart to know where the report is running from.

Any one?

Begin you hyperlink with ~ (tilde) character and then /. It will be replaced with Virtual directory name by ASP.net at runtime. for ex: in your case you can refer to http://server/virtualdirectory/test.aspx with ~/test.aspx.|||

I put in the navigation tab in jump to URL: the expresion

="~/OTDByFamilyPlant.aspx?FromDate=" & Parameters!FromDate.Value &"&ToDate=" & Parameters!ToDate.Value &"&FamilyID=" & Fields!Customer_Family_ID.Value

it did not even change the cursor to a hand.

Do I need to do something else?

|||Please note that you can't resolve this URL in browser navigation bar, as the URL starting with ~ will be resolved at the server end by ASP.NET. If you use any URL that starts with ~/ in for server controls in ASPX pages, it will be resolved at the server end as corresponding virtual directory.

Hope I am clear.|||

Not clear at all.

I was looking for a solution to show hyperlinks in a report based on the current virtual directory.

You suggested to use ~/ as a placeholder that will do the trick.

It did not!

What do I do in a report?

Is there a command solution?

Jump to URL

If I select this item and enter some value into the field, should this field
automatically be formatted as a hyperlink or do I need to manually format
the field.
Thanks,You need the fully formed URL.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:eA16ZPo3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> If I select this item and enter some value into the field, should this
> field automatically be formatted as a hyperlink or do I need to manually
> format the field.
> Thanks,
>

Jump To Report Without Running It Automatically

Hi

I need to be able to click a hyperlink in one report to open a linked report, but without automatically running the linked report.

Scenario.

I have a report showing customer details and on this page there is a link to a price enquiry report. This price enquiry report has two parameters: customer code and product code.

When I click the price enquiry hyperlink in the customer details report I can only attach a value to the customer code parameter. The product code parameter is not known at this stage and would have to be provided by the user after the price enquiry report is opened (but not run). The customer code parameter should already be filled (carried in the link).

When I click the link at the moment I get the error "The 'product' parameter is missing a value".

Any advice much appreciated.

Thanks,

SQLServant

Sometime ago, I made a post about this. It was stated that it's by design and that all parameter values must be passed to the report.

I believe using the hyperlink feature might work though you'd have to manually append all parameter names and values that you -do- want to pass (reportname&param=val&param2=val2).

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