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