If using a SQL Server database, reports that use number data fields may display with 5 trailing zero's because the report template needs to have the data number field formated.
For example, if have entered in 1.5 for labor hours in a workorder, the Detailed Workorder report may display the quantity in the report as 1.50000 instead of 1.5
This is easily fixed by either of the following:
A. Format the number data field to strip the zero's by typing in {0:g29} in the FormatString property for the data field or
B. Format the number data field to use your operating systems Regional settings for numbers digits after decimal by selecting to use the Standard Type n in the FormatString. (i.e if your regional settings is set to display 2 digits after the decimal, setting this will set the data number field to display showing 2 digits even if a whole number - 1.50 for example)
You cannot post new topics.
You cannot post topic replies.
You cannot post new polls.
You cannot post replies to polls.
You cannot edit your own topics.
You cannot delete your own topics.
You cannot edit other topics.
You cannot delete other topics.
You cannot edit your own posts.
You cannot edit other posts.
You cannot delete your own posts.
You cannot delete other posts.
You cannot post events.
You cannot edit your own events.
You cannot edit other events.
You cannot delete your own events.
You cannot delete other events.
You cannot send private messages.
You cannot send emails.
You may read topics.
You cannot rate topics.
You cannot vote within polls.
You cannot upload attachments.
You cannot download attachments.
You cannot post HTML code.
You cannot edit HTML code.
You cannot post IFCode.
You cannot post JavaScript.
You cannot post EmotIcons.
You cannot post or upload images.
Posted 7/3/2006 7:36:43 AM
