Jump to URL and pass parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John K - 31 Mar 2005 19:37 GMT

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.

Signature

Thanks in advance,
John

Reply to this Message

John K - 31 Mar 2005 23:15 GMT

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

Reply to this Message

Bruce L-C [MVP] - 31 Mar 2005 23:32 GMT

You have to turn this into an expression:
="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
Fields!TrackingNumber.Value

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> 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
[quoted text clipped - 4 lines]
> Thanks,
> John

Reply to this Message

John K - 31 Mar 2005 23:51 GMT

Thanks Bruce, that did it.

> You have to turn this into an expression:
> ="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
[quoted text clipped - 17 lines]
> > Thanks,
> > John

Reply to this Message