crystal reports c#2010 connecting to csv, numbers lose decimal places

Hi

I have a csv file that I am creating a report from, the figures in the csv are to lots of decimal places.

then I load the data and start working with it in crystal reports, I am seeing the figures without decimal places...

example:

56.53190986 in the csv file reads 56.000 in the crystal report....

any ideas why this is reading wrong?

Cheers
cycledudeAsked:
Who is Participating?
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.

AndyAinscowFreelance programmer / ConsultantCommented:
How is the datatype defined in the report?  If it is an integer/long type then change to double or float
What is the local decimal point symbol?  (some countries use a comma not a dot.)
0
cycledudeAuthor Commented:
Hi

How do I find out if it is integer/double? and I am in  uk, so decimal should be '.'

thanks
0
AndyAinscowFreelance programmer / ConsultantCommented:
Somewhere you must (I thought) define which field name is of which type.  (I've never used CR with a csv but with other files types / data sources I define field names/types before designing the report)

If the process is automatic then check the very first value for the fields giving the problem - maybe there are without a decimal part so CR thinks they are integral types.
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
cycledudeAuthor Commented:
wonderful, thanks

I had to convert EVERY number in the vcs to x decimal places, even if it was an integer.... that fixed it, it now reads the decimal places everywhere ...

\o/ yay
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.