Hi folks,
Crystal rookie here and I'm running Reports 10 and Enterprise 10. What I'm trying to do is create a report with a clickable hyperlink to a page on our intranet. Here's an example of a properly formatted link:
The value "1234" is contained in the 'record_no' field of our Oracle DB and is formatted to be a varchar(11). The remainder of the path is static and could be hardcoded into the Crystal Report.
So here is what I have done so far:
1. Created a simple report that contains the field "record_no".
2. Fotmatted that field to be a "Web site on the internet" type hyperlink and have it calculating the value like this:
"../../../../folder/file.asp?record_no=" & {TABLE_NAME.RECORD_NO}
There are a couple of problems:
1. When I click on the link it seems to pass the record_no parameter with a comma (,) in the value. Something like this:
It is tough to discern the exact problem because I can't see the parameter directly. I'm getting an "ORA-00907: missing right parenthesis" error message which makes me think the problem is a comma in the numeric value.
I tried the ToText function but no luck. Can anyone help me out here?
2. The other problem is with the static path. At this point I should mention that everything runs fine when I click on a link from within Reports 10 on my local workstation. The problems hit when I try to run it from Enterprise. CE seems think of the path in "relative terms"; hence the "../../.." stuff in the formula. I can live with this but would like to know if there is a way to have it use an "absolute" path.
-Striker
Crystal rookie here and I'm running Reports 10 and Enterprise 10. What I'm trying to do is create a report with a clickable hyperlink to a page on our intranet. Here's an example of a properly formatted link:
The value "1234" is contained in the 'record_no' field of our Oracle DB and is formatted to be a varchar(11). The remainder of the path is static and could be hardcoded into the Crystal Report.
So here is what I have done so far:
1. Created a simple report that contains the field "record_no".
2. Fotmatted that field to be a "Web site on the internet" type hyperlink and have it calculating the value like this:
"../../../../folder/file.asp?record_no=" & {TABLE_NAME.RECORD_NO}
There are a couple of problems:
1. When I click on the link it seems to pass the record_no parameter with a comma (,) in the value. Something like this:
It is tough to discern the exact problem because I can't see the parameter directly. I'm getting an "ORA-00907: missing right parenthesis" error message which makes me think the problem is a comma in the numeric value.
I tried the ToText function but no luck. Can anyone help me out here?
2. The other problem is with the static path. At this point I should mention that everything runs fine when I click on a link from within Reports 10 on my local workstation. The problems hit when I try to run it from Enterprise. CE seems think of the path in "relative terms"; hence the "../../.." stuff in the formula. I can live with this but would like to know if there is a way to have it use an "absolute" path.
-Striker