Skip to Content

Suppress Zeros on a Matrix with DBDataSource

If I use a simple EditText object, I can easily set the SuppressZeroes property to true using the SDK or the Business One Studio. I would like to do the same using a Matrix, which is bound to a DBDataSource on a UDO/ User Defined Form.

The UDF the column is bound to is set to Quantity, so the data type in SQL is decimal and the picker type in the UI is Calc (correctly). The only problem is the values are displayed with three decimal places (example: 3,000 or 4,000) which is quite annoying, when you have a table with lot's of quantities besides each other.

I tried to search in the SDK UI help files and manually find the property in visual studio, but I can't find the SuppressZeroes for the Matrix Column.

(So Can I display the values inside a Matrix like it is done in any system form? If the value is '3,000' the system form display '3' and if the value is '3,541' the form displays '3,541' in the matrix's column.)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers