sql server reporting services: 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.

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

[quoted text, click to view]
"?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false
&rc:Zoom=Whole+Page&rc:Parameters=false&CampaignCode="
[quoted text, click to view]
"?/Detail/Order+Detail&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&
rc:Zoom=Whole+Page&rc:Parameters=false&OrderID="
[quoted text, click to view]

Frank,

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.


[quoted text, click to view]
"?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false
&rc:Zoom=Whole+Page&rc:Parameters=false&CampaignCode="
[quoted text, click to view]
"?/Detail/Order+Detail&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&
rc:Zoom=Whole+Page&rc:Parameters=false&OrderID="
[quoted text, click to view]

I appreciate both of ya'lls help...I've spent way too much time on
that problem. Thanks!!!

Frank

[quoted text, click to view]