General information
Category:
Reports & Report designer
Title:
Limit number of decimals on report fields?
Environment versions
Network:
Windows 2008 Server
How can I limit the number of decimal places printed on the report for calculated fields?
For instance, when I use JobItem.Qty*JobItem.Price on a report textbox, it wants to print many decimal places, but I only want 2 decimal places.
When I use formatting like '999.99' I am always frustrated, because I do not know how big the number will be, so I have to guess how many digits to allow for on the left side of the decimal. I hate having to hard-code liek that. Maybe the result will require '999999.99', but if i make it that big it will print '******.**' on the report becuase the textbox is not big enough to hold all that.
My point is that I want to contrain the number of digits on the RIGHT side of the decimal, but allow as many places to the LEFT of the decimal as required, without me having to tell it how many to allow for.
Do that make sense?
I have also experimented with TRANSFROM, but I still couldn't really get what I was after.
Maybe I need a user function?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only