Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calling an html page from crystal report

Status
Not open for further replies.

mike2003

Programmer
Mar 15, 2003
4
US
I am trying to place a hyperlink on one of my crystal report fields and call an HTML\asp page.
I know it is possible to place a hiperlink on a crystal report field, but I am not sure how i can pass the value of the field to the asp page.

for exampple,
I have a field called Customer name
and one of the customer is john
I want to place the hiper link on john so that i can load the asp page with the details for John

Thanks
 
Create a formula in your report, to display some text.

Use Format/Hyperlink to set the field on the page to a hyperlink calling your ASP page. Set it to a formula of
" +
{table.linkfield}

Is that the sort of thing you want to do? Editor and Publisher of Crystal Clear
 
Thank yo chelseatech

Please bear with me.
I am new to crystal reports and I was just throwen in to this. I am not sure what I am doing wrong.
here is what i did.
in the format editor/hyperlink tab,hyperlink information
I typed and in format formula editor: hyperlink text I have{CompanyInfo.Company_Name}

when i save this and try to run it it gives me an error" unable to open hyperlink the specified file was not found"

Hope you can help me with this
Thanks
 
There seems to be a typo or two in your link. Is this an exact copy of your hyperlink? If so, check your syntax.

Check that you can resolve communication or syntax issues by copying the URL information from your hyperlink and pasting it directly into a browser, substituting {CompanyInfo.Company_Name} with a real value.

Naith
 
The formatting of the hyperlink field is (okay *can* be.. because I am sure there is an exception) viewer dependant. What viewer are you using?

Lisa
 
Hi,

You need to publish the report to check for that hyperlink. If you are trying to click when you are in designer, it will not work.

Vishal
 
Thanks everyone for the reply's

I tried the following (" cstr(CurrentFieldValue) + "'")
in the format formula editor and
it actually loads the window and passes the value in a queystring. The problem I am having is that when the asp window loads I don't want it to have the toolbar statusbar and address bar.

Is there a way to do that?

Thanks again everyone
I appreciate your feedback
Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top