How to show Currency Symbol in SQL Server Reporting (SSRS):
1>Create a table called "Currency" with column [Currency Name],[Rate] and later join Currency table with your primary table in while creating data set in Report.
2>Right Click Text box property--> Number-->Custom -->Custom format-->Paste below code in expression field.
3>Red color symbol display for negative value .
4>Currency Symbol:
$ :US Dollar
AUD :Australian Dollar
€ : Euro
£ : Pound
¥ :Yen
Y:Yuan
=IIF(
Fields!Currency.Value="USD","'$' #,0;('$' #,0)"
,IIF(Fields!Currency.Value="AUD","'AUD' #,0;('AUD' #,0)"
,IIF(Fields!Currency.Value="EUR","'€' #,0;('€' #,0)"
,IIF(Fields!Currency.Value="GBP","'£' #,0;('£' #,0)"
,IIF(Fields!Currency.Value="JPY","'¥' #,0;(''¥' #,0)"
,IIF(Fields!Currency.Value="CNY","'Y' #,0;('Y' #,0)"
,"Error"))))))
ReplyDeleteThrough this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
Msbi online training Hyderabad
Msbi online training India
Msbi online course