Add parameters to crystal report hyperlink

[Former Member]

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

[DellSC · Accepted solution]

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