Crystal Report displays wrong value.

Hi,

There is a issue in VB & Crystal report version is 8.5.
I have got a report which displays wrong values though the values returned from the database is correct. It displays all the numbers by dividing 100 to it. I am getting correct values in some of the machines but not in rest. For eg if the value returned from the database is 80 then the report displays the value as 0.8 in some of the machines which is wrong. How do I correct this wierd error? Is there any system based setting where in I could go and change? We have checked the following things and it seems to be correct (DSN settings, Reports Versions)

Crystal report version is 8.5. In users m/c, no crystal report is installed.
Please tell me are there any settings to be set in user machines.

Reply asap.

Regards
Shilpai hope ur problem will be solved if u follow the instructions here...

1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
NOTE: if it is system default then change it according to ur requirement.

if u r using "Customize" then do following
1) Click on "Customize"
2) Click on "Currency Symbol" Tab.
3) Make sure "Use System Default Format" is Unchecked.
NOTE: if it is checked then make it Unchecked.
Mostly people sets the format according to thier need but
ignore this option which makes such type of troubles.

Hope will be helpfull........Cheer up :D|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa

i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.|||i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.

I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.|||I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.

i m using Crystal Report 8.5 and the problem i was expecting is not in your case.

i got rid of the same situation by the steps i told u.|||U can also change the Number format of those systems to that one on which u getting the correct result by

Start->Settings->Control Panel->Regional Settings->Numbers (Tab)