Is it possible to use crystal repor

[Roderickf]

Is it possible to use crystal reports to calculate complex formulas and then link those formulas back to a field in ODBC to have that field updated.

My goal is to not perform the calculations within Oracle.

Thanks.

 

[Roadkill150]

Crystal won't pass calculations back to the database, though it will perform most calcs within the report itself
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[chelseatech]

One potential approach is to use CR to write some SQL and you then use that to inside an SQL utility.

But Cr is read only - which is one it's key advantages.
Editor and Publisher of Crystal Clear

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

 

[AndrewBaines]

I've been using a UFL to write back to a database - easy to set up, but even easier to make a mess.
I just used VB and the data environment, passing through whatever SQL I wanted to write back.

 

[dgillz]

Andrew,

Where did you get that write back UFL? Can I get a copy? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[AndrewBaines]

The UFL - I wrote it to create a table of contents. It would only need a small mod to write SQL. At the moment, it's very simple - fixed ODBC etc.

Andrew Baines
Chase International