Skip to Content
avatar image
Former Member

Add parameters to crystal report hyperlink

I am workinng on a report where I Have the latitude and longitude values in two separate text boxes. On clicking of a third textbox which I will make a hyperlink, I would like to be taken to w new tab with the latitude / longitude as parameters of that hyperlink.

Example Lat Long Name 33.83, -83.39 Trustfall 28.99, -61.64 Signal

When I click "Trustfall" I want to be taken to the link

https://www.google.dm/maps/place/33%C2%B049'48.0%22N+83%C2%B023'24.0%22W/@33.8300044,-83.3921887,17z/data=!3m1!4b1!4m5!3m4!1s0x0:0x0!8m2!3d33.83!4d-83.39?hl=en

and of course the latitude and longitude for the link will come from my report fields.

I can already create the huperlink, but looking for assistance in adding parameters to the hyperlink if that can be done. Any help would be appreciated. Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 22, 2017 at 04:15 PM

    Which version of Crystal and/or Crystal for Visual Studio are you using?

    Depending on that answer, there may be a way to set a dynamic URL using data from your report. You'll know you can do that if there is a formula button (blue "X-2") to the right of the textbox where you enter the website URL. Click on the button and enter a formula that looks something like this:

    "https://www.google.dm/maps/place/" + URLEncode(<lat/long fields>) + <whatever else you need to add>

    I know this functionality is available in Crystal 2008 and newer.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded