CE 8 displays wrong number value not represenative of data in database

[GCPDadmin]

I have a report done in cr8 looks great data is accurate.
upload to ce8 and the fields with numbers go "wacky" I can see no logical corolation with the actual data in the database and the obscure number the system is throwing out. this is not a formula just display of fields from records. nothing fancy.

 

[Turkbear]

Hi,
Must be something very odd as Crystal is not smart enough to make things up..

By 'Whacky' do you mean the numbers are different than the numbers in the database fields ( can you use the 'Browse data' option on the field and see the 'good' numbers)..


What number is in the database and what does Crystal show you?





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

 

[synapsevampire]

Try posting technical information in lieu of saying it's wacky.

Show what the value is supposed to be and what you have, and the data type.

This can happen because of the connectivity, depending upon the database being used, for instance using the supplied ODBC driver can return bad values.

At any rate I'd be suspicious of it not pointing to the right data source, or you're using the wrong connectivity for whatever your database is.

-k

 

[GCPDadmin]

The data displayed throug CE is not the same as data in database fields the value in the database oracle8i is for example is 2 for the value field is number. run the same report in cr8 or cr8.5 or cr11 its correct. I know wacky.

 

[Turkbear]

Hi,
Please show how it differs...

If 2 in the Database field, what is it in the CE displayed report?

Have you checked Synapse's ideas?
Wrong database being accessed.
Different user/pass so different table/view.

Again:

What Database?
What connection method?






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

 

[GCPDadmin]

ce out put
Date hours location
May 10, 2006 50 GCPD

April 26, 2006 98697266 GCPD

April 26, 2006 50 GCPD

the data below is correct

cr output

May 10, 2006 2 GCPD

April 26, 2006 2 GCPD

April 26, 2006 2 GCPD


same report different training
ce
SCORE PASSFAIL RECEIVED HOURS LOCATION
3,290,162 P May 24, 2006 55 GCPD

3,158,067 P May 24, 2006 55 GCPD

3,159,858 P May 10, 2006 55 GCPD

3,683,634 P May 10, 2006 55 GCPD


cr

SCORE PASSFAIL RECEIVEDHOURS
242 P May 24, 2006 7 GCPD

300 P May 24, 2006 7 GCPD

270 P May 10, 2006 7 GCPD

258 P May 10, 2006 7 GCPD

 

[GCPDadmin]

Oracle 8i is the Database and using Microsoft odbc for oracle

 

[synapsevampire]

Again, for the 3rd time being asked of you, HOW are you connecting to the Oracle database?

And don't say Oracle client or just ODBC, state specifically if you're using Oracle ODBC, the native Crystal connectivity (which is what you should be using), or the Crystal supplied Oracle ODBC driver.

-k

 

[synapsevampire]

That's not a supported ODBC for Oracle.

Switch to native connectivity to Oracle which is listed as Oracle Server.

Had you bothered to answer my question initially you probably would have had this resolved by now.

-k