Hi
We are trying to produce some reports with crystal reports 8 that are based on some old v6 4gl progress reports.
We have a few calculated fields that require procedures to be called to interegate the database.
EG
Find this record
If this value = "A" then
Do: /* calculate values */
return.
END.
ELSE
Do:
If this value then do this
else
do
run another proc that goes through set of records related to this record and return value .
END
else
do
end.
etc etc
END
Anybody got any expericence on how we would do this with odbc and crystal reports?
Would it be better to work out the fields first within progress and then call crystal reports. If we need to call crystal reports how can we automate this from progress 4gl
any help would be appreciated?
Regards
Dale
We are trying to produce some reports with crystal reports 8 that are based on some old v6 4gl progress reports.
We have a few calculated fields that require procedures to be called to interegate the database.
EG
Find this record
If this value = "A" then
Do: /* calculate values */
return.
END.
ELSE
Do:
If this value then do this
else
do
run another proc that goes through set of records related to this record and return value .
END
else
do
end.
etc etc
END
Anybody got any expericence on how we would do this with odbc and crystal reports?
Would it be better to work out the fields first within progress and then call crystal reports. If we need to call crystal reports how can we automate this from progress 4gl
any help would be appreciated?
Regards
Dale
