Hyperlinks in Crystal Reports 8

[TheStone]

Would the following be possible? Any idea how it can be done?

I have a field that is returned in a crystal report that gives the number of a map page (Ex. 52A1). We have an ASP map file that located at //Server/map and each map page would be //Server/map/52, //Server/map/64, and so on.

Now, I have hyperlinked the map field to the general map page on our server (//Server/map), but would it be possible to extract the field return from the Crystal Report(52A1 as seen above) and point the browser to //Server/map52A1? If so how?


That's problem # 1, now if the above can be done, would it be possible to complicated things a bit further. Our map page returns start with a number or two numbers, followed by a letter and then a number (i.e., 1B1, 16C4, 99E4). Now, I only want to extract the first two numbers of the entire four character field. The only exception would be if the number is 1-9 as opposed to two numbers 10-99. Then, I'd only like to extract the first digit.

Any partial help would be appreciated. Thanks in advance

 

[medleysj]

You can do what you want by creating a formula in your report like the one below

'<a href=&quot;' + href_field_name + '> ' + Description_of_FieldSample + '</A>'

Note the use of single quotes!!

Export the report to a web page and wiew in the browser.

Crystal can not display web hyper links in the preview screen

Hope this helps