Thursday, November 17, 2022

Display the currency sign in Report

 Hi guys, Today I got the requirement to showcase the currency symbol in the report after that amount based on currency.

Below is the path for currency symbol.

General Ledger -> Currency -> Currencies form

For getting this 

  • I have created a new field in the temp table.
  • I have added the below code in the DP class.

myTemptable.Symbol = Currency::find(myTempTable.CurrencyCode).Symbol;


After that, I added the below expression in the report Design. (Anyone we can use)

=Format(Fields!Amount.Value, "N2") & space(1) & Fields!CurrencySymbol.Value
=Format(Fields!Amount.Value & " " & Fields!CurrencySymbol.Value)



Keep Daxing!!


No comments:

Post a Comment