Symbol and Position Formulas not the same in Number and Currency
Hello,
Using Crystal Reports 10
I'm trying to use different formats for different currencies. For example. $15,000 and 15,000EUR.
I have these two formulas
For Currency Position
if {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency } = "USD" Then
1
else
3
For Currency Symbol
if {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency } <> 'USD' Then
{eaSPSelDealPayoutByDateRangeInitialQry;1.Currency }
else
'$'
I have 3 fields that would use this formula, one Numeric and two currencies. The formula works as expected in the Number but not in the Currency.
Re: Symbol and Position Formulas not the same in Number and Currency
put the field on report
Right Click -> Format Field -> Number Tab -> Customize -> Currency Symbot Tab
Set the position for the currencies and Currency symboy in the conditional formula of your choice.
By this you can adjust the currency symbol and its position according to your requirement or choice.
Re: Symbol and Position Formulas not the same in Number and Currency
Thanks! That is how I was trying to do it, but it wouldn't let me. I couldn't do it so I decided to solve it by using a Formula Field instead of applying the formula to the Currency Field and doing it that way.
if {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency} = "USD" then
"$" & cstr({eaSPSelDealPayoutByDateRangeInitialQry;1.ClientEarnings})
else
cdbl({eaSPSelDealPayoutByDateRangeInitialQry;1.ClientEarnings}) & " " & {eaSPSelDealPayoutByDateRangeInitialQry;1.Currency}
Re: Symbol and Position Formulas not the same in Number and Currency
Dear I suggest you should use the way I told you.
I did a sample which worked on my end.
From today I am onvacation other wise I would send you the sample.
Attach you report might be some one else could help you.
It is very simple dear using a shared variable you should set the currency and in the formula you should check the currency symbol and set the symbol position to right or left and as well set the symbol.
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.