Execute a URL 1

[markphillipscpa]

Crystal Version 11:

Is is possible for Crystal to issue a URL at runtime if a condition is met?

Example :
"

http://myserver.com/MyApplication/UpdateThisValue"

if Total Sales are > $1,000

 

[chelseatech]

You can create a conditional hyperlink, but if you want to invoke the hyperlink, you would need to have the user click on the object to invoke the URL.

You could use a Web Service or a SQL Command as a data source, but that tends to be read only, so I'm not sure it could be used to update data in a table.

If you want a report to update a database a better approach is to use our Disk Output UFL to write a disk file with some SQL update statements, and then pass that to our cViewSQL utility.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[markphillipscpa]

Thank you; I was hoping Crystal could execute a hyperlink on its own.

Funny how Crystal is far better report writer than programing language

 

[Turkbear]

Hi,
Not so funny -
it IS a report writer and not a programming language.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi markphillipscpa,
Sorry, I missed your smiley face at the end of your post.
( Try the Emoticons )




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[chelseatech]

If you have a development background, it wouldn't be difficult to create a UFL (User Function Library) to execute a URL inside some Vb code.

Or talk to a nice developer about doing such a thing. Contact me via my web site if you are interested in this approach.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IdoMillet]

My "CUT Light" UFL provides functions allowing Crystal formulas to issue dynamic SQL statements. It also provides a function for calling a URL.

hth,
- Ido

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

http://www.MilletSoftware.com