Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

sql

Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

Jump to URL with a new target page

In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.

I have the URL with the invoice number in the expression. Is there something I can add to this expression that will force the interface to Open a new windows page instead of the existing window?

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

I'm a newbie to Reporting Services, and managed to get another screen with the Jump to URL selection, thanks to the help of this forum.

Have tried the above with no luck; what I am trying to accomplish is placing a relative URL in the Jump to URL selection as well as have it open in another screen. I have multiple files in the same folder. One file is the main one, and other reports will link off of it. Later, I expect the folder in its entirety will be moved to another computer/server, so in the interest of avoiding having to re-code every link, I am still trying. (And failing.)

If anyone has any ideas, it will be much appreciated.

|||

I want to navigate to a new url, but i need to have a anchor tag defined for this. eg

col1 col2

1 server1.com

2 server2.com

but i need the url to be embedded inside the link, <a href=server1.com?p=1&p1=2>server1.com</a>

in sql server 2005 reporting services how can this be achieved using jump to url.

Does any have ideas on this.

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 Bug

I have two different URLs I use for Jump To URL navigation in my
reports.
This one adds a String report parameter on the end and works fine:
=Globals!ReportServerUrl + Globals!ReportFolder +
"?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&rc:Zoom=Whole+Page&rc:Parameters=false&CampaignCode="
+ Fields!CampaignCode.Value
This one adds an Integer report parameter on the end and does not
work:
=Globals!ReportServerUrl + Globals!ReportFolder +
"?/Detail/Order+Detail&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&rc:Zoom=Whole+Page&rc:Parameters=false&OrderID="
+ Fields!OrderID.Value
The two URLs are exactly the same except for the report names and
report parameters passed on the end. For some reason the second URL
that passes an Integer report parameter does not create a Hyperlink at
all, you can't click on it. If you remove the #"&OrderID=" +
Fields!OrderID.Value# (#'s used for reference only) part the field
will become a Hyperlink, but of course the report won't run because it
needs the report parameter passed. I also tried sticking it in the
middle of the URL and still
no dice.
The only conclusion I can come to is that there is a bug passing an
Integer parameter in the Jump To URL. Can someone run a quick test
that replicates this problem and confirm or deny this as being a bug?
Any and all help is appreciated.
FrankFrank,
Use an & instead of the + to concatenate the URL strings. I saw the bug
happen when there is a + sign. When I used the &, it works fine.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0411231419.5a269fa8@.posting.google.com...
> I have two different URLs I use for Jump To URL navigation in my
> reports.
> This one adds a String report parameter on the end and works fine:
> =Globals!ReportServerUrl + Globals!ReportFolder +
>
"?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false
&rc:Zoom=Whole+Page&rc:Parameters=false&CampaignCode="
> + Fields!CampaignCode.Value
> This one adds an Integer report parameter on the end and does not
> work:
> =Globals!ReportServerUrl + Globals!ReportFolder +
>
"?/Detail/Order+Detail&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&
rc:Zoom=Whole+Page&rc:Parameters=false&OrderID="
> + Fields!OrderID.Value
> The two URLs are exactly the same except for the report names and
> report parameters passed on the end. For some reason the second URL
> that passes an Integer report parameter does not create a Hyperlink at
> all, you can't click on it. If you remove the #"&OrderID=" +
> Fields!OrderID.Value# (#'s used for reference only) part the field
> will become a Hyperlink, but of course the report won't run because it
> needs the report parameter passed. I also tried sticking it in the
> middle of the URL and still
> no dice.
> The only conclusion I can come to is that there is a bug passing an
> Integer parameter in the Jump To URL. Can someone run a quick test
> that replicates this problem and confirm or deny this as being a bug?
> Any and all help is appreciated.
> Frank|||What is happening is when you use a + it does a concatenate if they are
strings. If it sees a number it trys to add it (this is a vb thing). Always
use & when concatenating strings.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0411231419.5a269fa8@.posting.google.com...
> I have two different URLs I use for Jump To URL navigation in my
> reports.
> This one adds a String report parameter on the end and works fine:
> =Globals!ReportServerUrl + Globals!ReportFolder +
>
"?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false
&rc:Zoom=Whole+Page&rc:Parameters=false&CampaignCode="
> + Fields!CampaignCode.Value
> This one adds an Integer report parameter on the end and does not
> work:
> =Globals!ReportServerUrl + Globals!ReportFolder +
>
"?/Detail/Order+Detail&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&
rc:Zoom=Whole+Page&rc:Parameters=false&OrderID="
> + Fields!OrderID.Value
> The two URLs are exactly the same except for the report names and
> report parameters passed on the end. For some reason the second URL
> that passes an Integer report parameter does not create a Hyperlink at
> all, you can't click on it. If you remove the #"&OrderID=" +
> Fields!OrderID.Value# (#'s used for reference only) part the field
> will become a Hyperlink, but of course the report won't run because it
> needs the report parameter passed. I also tried sticking it in the
> middle of the URL and still
> no dice.
> The only conclusion I can come to is that there is a bug passing an
> Integer parameter in the Jump To URL. Can someone run a quick test
> that replicates this problem and confirm or deny this as being a bug?
> Any and all help is appreciated.
> Frank|||I appreciate both of ya'lls help...I've spent way too much time on
that problem. Thanks!!!
Frank
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<#V2B7Gb0EHA.3336@.TK2MSFTNGP11.phx.gbl>...
> What is happening is when you use a + it does a concatenate if they are
> strings. If it sees a number it trys to add it (this is a vb thing). Always
> use & when concatenating strings.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services|||Just a FYI: the difference between + and & is that a concatenation using &
will implicitly call the .ToString() method on the object before
concatenation.
Concatenating real strings will also work with + instead of &
e.g. ="Hello " + "World"
For other datatypes, you could also use CStr() to convert them to strings:
e.g. =CStr(20)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0411291255.3b9241e8@.posting.google.com...
> I appreciate both of ya'lls help...I've spent way too much time on
> that problem. Thanks!!!
> Frank
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:<#V2B7Gb0EHA.3336@.TK2MSFTNGP11.phx.gbl>...
> > What is happening is when you use a + it does a concatenate if they are
> > strings. If it sees a number it trys to add it (this is a vb thing).
Always
> > use & when concatenating strings.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services

jump to report in the same frame of calling report

Hi,
i had created a report (ReportA) in which i m calling another report (ReportB). I had added a textbox (tb) in ReportA and had set the navigation property of tb to "jump to report" and given a report name ReportB (i.e. the second report).
Now, i m using asp.net report service,
i had created an asp form in which i had added a frame, n in tat frame i had added the report service control, this report service control calls my first report (ReportA),when i click on the textbox (tb) it jumps to another report (ReportB), now the problem is when i click textbox (tb), it jumps to ReportB but this report takes whole area of internet explorer.
wat i want is when i click textbox (tb), the next report (ReportB) should come in the same frame where my first report (ReportA) was.
Plz help me out.
Thanx.
--
Message posted via http://www.sqlmonster.comIn the URL for ReportA, you'll need to Add:
&rc:LinkTarget=nameofFrame
Then in your textbox tb, you'll need to set your navigation property to jump
to URL, giving it the URL of ReportB.
"Imran Saiyed via SQLMonster.com" wrote:
> Hi,
> i had created a report (ReportA) in which i m calling another report (ReportB). I had added a textbox (tb) in ReportA and had set the navigation property of tb to "jump to report" and given a report name ReportB (i.e. the second report).
> Now, i m using asp.net report service,
> i had created an asp form in which i had added a frame, n in tat frame i had added the report service control, this report service control calls my first report (ReportA),when i click on the textbox (tb) it jumps to another report (ReportB), now the problem is when i click textbox (tb), it jumps to ReportB but this report takes whole area of internet explorer.
> wat i want is when i click textbox (tb), the next report (ReportB) should come in the same frame where my first report (ReportA) was.
> Plz help me out.
> Thanx.
> --
> Message posted via http://www.sqlmonster.com
>|||Hi,
Thanx for ur suggestion, but
firstly,
i had created my project such tat whenever new session of project is opened, it ask for username and password. therefore if i add the url of ReportB in the navigation property of textbox (tb) "jump to url", then whenever tb is clicked, it creates a new session for ReportB, so first the login screen occurs, then it enters into the project, then again i have to go to ReportA, then click tb. Therefore i was using "Jump to report" property which directly opens the ReportB.
secondly,
now i had removed the frame for some problem i was facing, n now i m using table (i.e. <td><\td>) between this td the reportviewer control is added. so i want to show ReportB in this table.
Thanx.
--
Message posted via http://www.sqlmonster.com

Jump to Report Error after SP1

I have a textbox on a report that has the advanced navigation jump to report
property set to another report three properties are passed to the "jump to
report". There is one dataset on the original report that is using a report
datasource with a specific username and password that allows the saving of
the password.
This works correctly when executing the report in visual studio design time.
It doesn't work correctly after it is deployed and it gets executed from the
report server/manager web site. When the user clicks the text box that
executes the "jump to" report the following error comes up:
The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSourceCredentialSetting)
This worked fine before SP1 was installed.
Any assistance would be appreciated.
Tim
tfogel@.idmi.comOne of the changes in SP1 was require the unattended execution account to be
specified on the server when running reports with datasources with
CredentialsOptions = None.
If you are using a data source that requires no credentials, for ex. Access
or XML files, set the unattended account using rsconfig -u ...
If you are using a data source that requires credentials, for ex: SQL,
Oracle, DB/2, etc. store credentials in the report server.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Fogel" <tfogel@.idmi.com> wrote in message
news:OCEdA9dXEHA.1144@.TK2MSFTNGP12.phx.gbl...
> I have a textbox on a report that has the advanced navigation jump to
report
> property set to another report three properties are passed to the "jump to
> report". There is one dataset on the original report that is using a
report
> datasource with a specific username and password that allows the saving of
> the password.
> This works correctly when executing the report in visual studio design
time.
> It doesn't work correctly after it is deployed and it gets executed from
the
> report server/manager web site. When the user clicks the text box that
> executes the "jump to" report the following error comes up:
> The current action cannot be completed because the user data source
> credentials that are required to execute this report are not stored in the
> report server database. (rsInvalidDataSourceCredentialSetting)
> This worked fine before SP1 was installed.
> Any assistance would be appreciated.
> Tim
> tfogel@.idmi.com
>

Jump to report

Hi

I want to use Jump to Report option under Navigation tab.

I have two reports both with Same parameters and parameters are multiple value selectable.

In Jump to Report this is how I set the parameter value.

LeadershipTeamId =Join(Parameters!LeadershipTeamId.Value,", ")

CostCentreId =Join(Parameters!CostCentreId.Value,", ")

CostElementGroupId =Fields!CostElementGroupId.Value

This works fine if I have only one value selected for CostCentre and LeadershipTeam but when I select the multiple value I get the following error.

The value provided for the report parameter 'LeadershipTeamId' is not valid for its type. (rsReportParameterTypeMismatch)

Am I missing anything here?

Any help would be highly appreciated.

Best Regards

I used this expression and it seems to be working.

=Split(Join(Parameters!LeadershipTeamId.Value,", "),",")

Correct me if this is not the right approach.

Now my problem is When I jump to second report the CostCentre Parameter value is not set.

Because, costcentre value is depend on the LeadershipTeam value.

So when I jump to second report I have LeadershipTeam value set but I have to select costcentre value.

Is it possible to make CostCentre selected when someone jump to the report?

Thanks for your help

Regards

Update: By the way it works if I select only one CostCentre.

|||

Solved it using this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=163803&SiteID=1

Thanks guys

Amit