November 5, 2014 at 10:55 pm
HI ,
I am facing issue in SSRS Report. I have a Report which contains multiple currency.I had implemented currency logic in report using custom Set Expression:
=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"))))))
Currency symbols display correctly in Report ,also when i download report in Excel i am able to sum different currency cell,
But when i download Report in CSV file ,other then $ and € currency i am not able to sum AUD,£,¥,Y currency cell values and it read as a text cell and shows count.
Please suggest any solution for this problem.
Regards,
Pushpendra singh
November 6, 2014 at 2:09 am
Quick suggestion, instead of nesting IIF's use the Switch statement
😎
=Switch(
Fields!Currency.Value = "USD" ,"'$' #,0;('$' #,0)"
,Fields!Currency.Value = "AUD" ,"'AUD' #,0;('AUD' #,0)"
,Fields!Currency.Value = "EUR" ,"'€' #,0;('€' #,0)"
,Fields!Currency.Value = "GBP" ,"'£' #,0;('£' #,0)"
,Fields!Currency.Value = "JPY" ,"'¥' #,0;('¥' #,0)"
,Fields!Currency.Value = "CNY" ,"'Y' #,0;('Y' #,0)"
)
November 6, 2014 at 3:15 am
HI,
issue is not related to currency display in report.Both Switch and IIF will work same way.Problem is when you sum different currency values in CSV it reads as text box instead of currency.
Ex: copy and paste below values in .csv file and try to sum these value,you will get 0
£ 7,607
£ 9,425
£ 163,656
and now copy and paste below values in csv file and try to sum these value,you will get summed value
€ 5,613
€ 5,613
€ 5,613
€ 5,613
Regards,
Pushpendra Singh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply