Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Turn Rounding Off

Status
Not open for further replies.
Cpreston

Cpreston

MIS
Mar 4, 2015
987
GB
Hi

I have a problem trying to get rid of rounding on a field. Th actual figure I am expecting to see is 7.986 but the field is coming in as 8.

I have tired to change the settings under customise and number but cannot get it to show the actual figure coming form the database, in this case 7.986

Any help please would be great, Thanks
 
Sort by date Sort by votes
Hi

Managed to solve it, for anyone else who may have this issue, Format the filed, Customise, Set Decimals to 1.000 and then set rounding to o.oo1

This then displayed 7.986

 
Upvote 0 Downvote
Sounds like you did not show enough decimal places (icon on tool bar).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tlbrown88
  • Locked
  • Question
Exception Report based off of results from Subreports
Replies
5
Views
365
tlbrown88
tlbrown88
Frazey
  • Locked
  • Question
How Can you kick off an IBM AS/400 (Iseries) job from a Crystal Report
Replies
2
Views
156
PeterDimitrov
PeterDimitrov
RenaG
  • Locked
  • Question
Rounding in a cross-tab 1
Replies
5
Views
194
lbass
lbass
evaleah
  • Locked
  • Question
export cutting off rows
Replies
1
Views
122
evaleah
evaleah
fmrock
  • Locked
  • Question
Crystal Reports Server - Only allow reports to run off hours?
Replies
1
Views
133
briangriffin
briangriffin

Part and Inventory Search

Sponsor

Back
Top