Skip to Content
0
Former Member
Aug 27, 2008 at 01:55 PM

Trouble in extracting Via ODBC to Oracle or Access - Numbers Change

18 Views

I am running a report that I only want the group records printed. One of the group fields shows a sum of a function from the detail records.

The following function sj_rec is on the detail record

WhilePrintingRecords;

Numbervar clm_sj_amt;

if {SJE_RECORD.SJER_TYPE} in ["S","J"] then

clm_sj_amt := clm_sj_amt + {SJE_RECORD.SJER_AMOUNT};

if {SJE_RECORD.SJER_TYPE} = "R" then

clm_sj_amt := clm_sj_amt - {SJE_RECORD.SJER_AMOUNT};

clm_sj_amt;

Then on the Group Record we have disp_sj function

WhilePrintingRecords;

numberVar clm_sj_amt;

clm_sj_amt;

On the crystal report every thing looks fine.

When I extract the Information Via ODBC to Oracle or Access the numbers change. If I extract to Excel it is fine.

Can you please explain why I canu2019t get on oracle the exact info displayd in crystal ???