Hyperlink to Mapquest

[blueboyz]

Crystal Reports v2008
Peachtree Premium 2009
Pervasive SQL

I have created a report that shows workorder information:

customer
address
date
work to perform

Is there a way for me to create a link to mapquest.com so the technician can put in the address for directions?

 

[IdoMillet]

From Crystal's Help:
______________________________
Hyperlink fields
You can select a report object on the Design or Preview tab and create a hyperlink to another location.
The hyperlink is saved with your report and is available to other users as a way of viewing additional information.
Note: Crystal Reports also lets you create hyperlinks with Relative URLs, so your web reports retain independence from their location on any particular server.
To create a hyperlink field
Select a report object on the Design or Preview tab.
On the Format menu, click Hyperlink.
The Format Editor dialog box appears with the Hyperlink tab active.
Click the type of hyperlink you want to create.
The available types in the upper area are:
No Hyperlink
This is the default option. There is no hyperlink associated with the selected report object.
A Website on the Internet
Select this option if you want your report object to be linked to a static web address. Use the formula button to create a URL based on a field value. For example, you might enter the following formula if your Customer Name field contained information that would create a series of meaningful URLs:
"

http://www."

+ {Customer.Customer Name} + ".com"
Note: You can also use this option to connect to Business Objects, Web Intelligence, and OLAP Intelligence documents (this is also known as report linking). Click Create enterprise Hyperlink to create these hyperlinks in Crystal Reports.
Tip: Alternatively, you can use the openDocument function in the Formula Workshop to create hyperlinks.
Current Website Field Value
Select this option if you want the program to create a hyperlink out of the field you selected. The field must be stored as a proper hyperlink in your data source.
An E-mail Address
Select this option if you want to create a "mailto" address from the field you selected. Use the formula button to create an address based on a field value.
A File
Select this option to create a hyperlink to a file on a specific computer or networked computer. Use the formula button to create a file path based on a field value.
You can also use a hyperlink of this type to run an EXE with a command-line parameter. Enter the path and application name, and follow it by the parameter for the command.
Current E-mail Field Value
Select this option if you want the program to create an email hyperlink out of the field you selected. The field must be stored as a proper email address in your data source.
The available types in the DHTML Viewer Only area are:
Report Part Drilldown
For information about how to use this option, see The Report Part Drilldown option.
Another Report Object
For information about how to use this option, see The Another Report Object option.
Note: Not all hyperlink types are available at all times. The object you select and its location on the report determine which types are available.
After you have chosen a hyperlink type, enter the appropriate hyperlink information (the URL of a web site, for example).
Click OK when you are finished.
The hyperlink is inserted as appropriate. Click it on the report to go to the web site, to send an e-mail, and so on. For information about how to use the hyperlink types in the DHTML Viewer Only area, see Setting up navigation.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[blueboyz]

Thanks much.

 

[blueboyz]

Sometimes our answers are right under our noses.

 

[CR85user]

Remember that because of the way these hyperlinks are formed you can automatically pull in the poscode or similar and populate the relevant part of the URL. For example:

"

http://www.mapquest.co.uk/mq/maps/mapAddress.do?cboCountry=GB&txtPostcode="

+ {Customer.Postcode}

Obviously if the url format changes then you would need to update it accordingly or amend for zip code if in the US etc.

You should also be able to then use this same format to give directions from a specific starting point to a location if required, use the same logic to input reference entires into the predefined URL.

'J



CR8.5 / CRXI - Discovering the impossible