Formatting decimal fields in NAV 2009 RTC reports

Comments

• Options

  geordie Member Posts: 655

  2013-11-14

  Use DecimalPlaces property in section design (classic client) for the corresponding Textbox, setting "3:3" if you want always to show 3 decimals or "2:3" to show the only if needed.
  To make in work assure in layout design (Visual Studio) to set Format property of the factbox: there will be in dataset an entry called "[YourField]Format", use it setting Format with "=Fields![YourField]Format.Value"

  * Daniele Rebussi * | * Rebu NAV Diary *

  0
• Options

  poppins Member Posts: 647

  2013-11-14

  geordie wrote:

  Use DecimalPlaces property in section design (classic client) for the corresponding Textbox, setting "3:3" if you want always to show 3 decimals or "2:3" to show the only if needed.
  To make in work assure in layout design (Visual Studio) to set Format property of the factbox: there will be in dataset an entry called "[YourField]Format", use it setting Format with "=Fields![YourField]Format.Value"

  Thank you for your reply...but does that enable the thousand separator as well???

  0
• Options

  geordie Member Posts: 655

  2013-11-15

  poppins wrote:

  Thank you for your reply...but does that enable the thousand separator as well???

  
  Yes

  * Daniele Rebussi * | * Rebu NAV Diary *

  0