Friday, March 30, 2012

Jump to URL and pass parameter

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,
JohnHere 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|||You have to turn this into an expression:
="http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
Fields!TrackingNumber.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.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.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
>|||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!TrackingNumber.Value
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John K" <JohnK@.discussions.microsoft.com> wrote in message
> news:EABF40D1-D597-4575-B149-5FDB74FC6D0F@.microsoft.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.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
> >
> >
>
>

No comments:

Post a Comment