Crystal 8.5 Hyperlink to URL not working

[macrane]

I have a report that has a conditional hyperlink that looks like this:

if dbfield.name = "No" then
"

http://urlname.com?variablename="+dbfieldname

else
"

http://differenturlname.com?variablename="+dbfieldname

(NOTE: the quotes are included in the formula)

When I run the report in Crystal 8.5 and click the hyperlink, everything works fine. However, once I put the report on our website, and the link is clicked, I get a syntax error because this is coming up before the URL listing:

http://"%1"

So my address bar says

http://"%1" http://urlname.com?variablename=variablevalue

I searched the Business Objects support site to no avail. I will appreciate any insight and help!

Thanks
MAC

 

[synapsevampire]

Report on the website...that's pretty vague don't you think? Perhaps you should share what this website is?

Crystal Enterprise? A Proprietary website?

And it's very disconcerting that the URL is stating the word variablevalue, or do you mean to say that it's constructing it with the appropriate value?

It sounds like this website is prefacing it with some values for some reason...

Crystal Reports 8.5 shipped with Crystal Enterprise 8.0 (standard version, very limited in it's scope), so you might leverage that for deployment via a browser.

-k

 

[macrane]

I apologize for not explaining myself clearly.

We use Crystal 8.5 for report development. We are not using Crystal Enterprise at this time. This report, like others, was prepared for the web using ReCrystallize. This is a project management website that requires login.

The report provides detail for one or more help desk ticket numbers. In each of the fields on the report where a help desk ticket number is listed, when the user clicks on the hyperlink, they should be taken to another area (not a crystal report) that provides further detail about the particular ticket.

So, the formula reads:
if dbfield.name = "No" then
"

http://urlname.com?CaseID="+dbfieldname

else
"

http://differenturlname.com?CaseID="+dbfieldname

When the URL comes up in the address bar, everything is correct, including the variable value, with the exception of the

http://"%1"

that prefaces the address.


Thanks

MAC

 

[Turkbear]

Hi,
The

http://"%1"

appears to be is an explicit string that something has to be adding to the start of the URL.. The %20 is the ascii code for the space character