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