Setting a currency datafield to show the correct currency symbol in a report template

Let’s say that you want all currency in AyaNova to display with the EURO symbol, including reports.

  1. As per the AyaNova 5 Help file (URL removed as for older version no longer supported - see the latest version of AyaNova) you first make sure that your computer itself is set for this.

  2. Then if a report template continues to show for example the $ currency symbol, then you know it is because that currency datafield in that report template needs to be specifically set to use the computer’s currency.

  3. Open the report template in the designer

  4. Select the datafield in the report template design panel that is showing with the incorrect currency symbol

  1. Select the Fields tab and expand the Data Bindings -> Text property so that you can see what the Format String property for this datafield is set to

  1. In the example screenshot above, we can see that the Format String has been set to {0:$0.00} which will force the currency to always display with the $ symbol

  2. Select to open the Format String Editor and select c to use instead and then press OK

  1. Now the Format String property will show as {0:c} which means that this datafield will always take whatever curency setting you have set in your Regional settings as per (URL removed as for older version no longer supported - see the latest version of AyaNova)