| Author |
Jump to URL and pass parameter
|
|
| John K 2005-03-31, 8:03 pm |
| 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.
--
Thanks in advance,
John
| |
| John K 2005-03-31, 8:03 pm |
| 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...20Fi
elds!TrackingNumber.Value
When executing the report, clicking in the actual value passes the URL
exactly as shown above instead of converting Fields!TrackingNumbe
r.Value to
the actual value.
Is there an alternate way to accomplish this?
Thanks,
John
| |
| Bruce L-C [MVP] 2005-03-31, 8:03 pm |
| You have to turn this into an expression:
="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
Fields!TrackingNumbe
r.Value
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John K" <JohnK@discussions.microsoft.com> wrote in message
news:EABF40D1-D597-4575-B149- 5FDB74FC6D0F@microso
ft.com...
> 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...20Fi
elds!TrackingNumber. Value
>
> When executing the report, clicking in the actual value passes the URL
> exactly as shown above instead of converting Fields!TrackingNumbe
r.Value
to
> the actual value.
>
> Is there an alternate way to accomplish this?
>
> Thanks,
> John
>
>
| |
| John K 2005-03-31, 8:03 pm |
| Thanks Bruce, that did it.
"Bruce L-C [MVP]" wrote:
> You have to turn this into an expression:
> ="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
> Fields!TrackingNumbe
r.Value
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "John K" <JohnK@discussions.microsoft.com> wrote in message
> news:EABF40D1-D597-4575-B149- 5FDB74FC6D0F@microso
ft.com...
> Layout,
> the
> http://track.dhl-usa.com/TrackByNbr...20Fi
elds!TrackingNumber.Value
> to
>
>
>
|
|
|
|