Format Quantity to remove trailing zeros on a Sum field


This how-to was kindly provided by a service company using AyaNova.

If your AyaNova database is networked using SQL, you may have one or more reports display trailing zeros.
Resolve this by customizing your report template to force the report to use the number format from your computer settings:

Open up the report to edit mode by choosing Shift and choosing the report to open.
Using The example below to edit simple number field:
Choose the Field to be modified 1, DATA BINDING 2, TEXT 3, FORMAT STRING 4.
A popup window will appear where you will choose NUMBER 5 , the CUSTOM tab 6, and type in “g29”
into the custom entry field 6.
Choose OK and save the changes. Go to your PREVIEW tab for your report and verify the changes took effect.

How to account for trailing zeros in reports using SQL Server database