Crystal Report - Data Changed in Print

Hi
number is in database 9044422262
Data field is in report,

Field name = Contact_No
Data Type = Number
Field Size = Double
Format = General Number

But in crystal report its showing me something else,  like 437256192 instead of 9044422262
LVL 1
Altaf PatniSoftware DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
In my opinion this cannot be so.
I think you should carefully check your data again and make sure that the field is being shown without any manipulation in say, a formula field,  in the report.

If you browse the data values what do you see?
0
Altaf PatniSoftware DeveloperAuthor Commented:
different data than actual data in table
like -45632587
0
peter57rCommented:
What sort of database is it- include the version please. (Oracle/SqlServer/ whatever)
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Altaf PatniSoftware DeveloperAuthor Commented:
MS Access
Designed in 2003 than convert it in 97
0
mlmccCommented:
I notice the tag says Crystal Report 7

Are you running the 16 or 32 bit version?
Probably need to be using the 32-bit version otherwise the numberis too big

I just built a quick databse and put the value in and it displays just fine in CR2008.

What data type does Crystal think it is?
It may be interpreting it as an integer

Has this data worked in the past?

mlmcc
0
Altaf PatniSoftware DeveloperAuthor Commented:
i just created this report now.
ok, what if i change this fields datatype number to text
will it be work..?
0
Altaf PatniSoftware DeveloperAuthor Commented:
"Are you running the 16 or 32 bit version?"

32 bit version
0
James0628Commented:
I have no idea what limits CR 7 might have, but it does look like that number may just be too big for it.  If so, then if you can change the field to text/string, it seems like that should take care of it.

 James
0
peter57rCommented:
I suspect that this may be an issue arising from the backwards conversion of the Access database.
I'm pretty sure CR7 could handle A97 format databases  (I think even CR6 could do so even though it pre-dated Access 97).

If you have Access 97 available then you should create a new blank database and use File>GetExternalData to import all objects from your current mdb file into the new one.
0
mlmccCommented:
If you change the field to text then Crystal will handle it properly.  One issue though is that it will then sort like text so 99 will come after 111

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
James0628Commented:
That's a good point, although, FWIW, I think that field may be a phone number.  If so, and if they're all 10 digits (US numbers that include the area code), then that shouldn't be a problem (assuming that you even wanted to sort by the phone number).  But I could be wrong about it being a phone number, or they might not all have 10 digits.  IAC, it's a good point to keep in mind.

 James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.