custom layout designer - decimals

SOLVED

I would like to only have two decimals after the point please for the Quantity field and Unit Price - what are the properties for this to be achieved please

  • 0
    verified answer

    Hi there
    Chipping in to help here, or you may wait some time for support:
     1. In Report Layout Designer select the [Quantity] field you want to change the properties for. Make sure you select the field under "Detail" section on your report, and not the heading
     2. Within the Property Grid on the right, scroll down to Data > Data Bindings > Text > Format String and select the 3 dots (...) on the right of "Format String"
     3. Select your desired format. If you are looking for 2 decimal places then you should select #.00 under "Number" format
     4. In the Properties Grid next to Format String it should now show {0:#.00}

    For the [Unit Pricing], follow the above steps but:
     3. Select the format c under "Currency" format
     4. In the Properties Grid next to Format String it should now show {0:c}

    Let me know if that doesn't work.

  • 0 in reply to Stacy_K

    wow - really appreciate thank you