expression for regional report

Hi all thnaks in advacne for your time im new to MS reprting and am
writing my first report albeit very slow but im getting there is there
a way for me to
for instance i am reporting on a number of sales in different
countries so i would like the total sales to show as =A3 for uk sales
and the euro sign for spain, france, italy etc?
i can determine the county but just need to know if i can change the
currency?
CheersOn May 25, 9:58 am, blueboy <matt_me...@.hotmail.com> wrote:
> Hi all thnaks in advacne for your time im new to MS reprting and am
> writing my first report albeit very slow but im getting there is there
> a way for me to
> for instance i am reporting on a number of sales in different
> countries so i would like the total sales to show as =A3 for uk sales
> and the euro sign for spain, france, italy etc?
> i can determine the county but just need to know if i can change the
> currency?
> Cheers
I don't think you can have multiple currencies because the currency is
represented based on Locale:
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices=
.aspx#CurrencySetting
If you can find a way to put multiple locals, or you have data for
different countries on separate tables then you can probably change
the currency. You may want to try an IIF command. In that link, it
shows you how to change the locale. You can use an expression in
there. For the formula you can use something like
=3DIIF(FIELD!<Name of your field>.value=3D'UK',English (United
Kingdom),English(United States))
So if the value for the field that identifies the record as one from
the UK is true, it will format it as british pounds, otherwise it will
format it as US $. You want more than one country, just nest IIF
commands as such:
=3DIIF(FIELD!<Name of your field>.value=3D'UK',English (United
Kingdom),IIF(FIELD!<Name of your field>.value=3D'USA',English(United
States), Arabic (Egypt)))
etc... it gets complicated after a few permutations. Try it with a
simple IIF like I first demonstrated and see how it goes. I have a
complex nested IIF in one of my GO TO URL buttons for selected between
3-4 different reports and passing parameters so I know it works.
Note: my syntax might not be perfect but I believe the concept is
correct and you can always find sources on here that will show you how
to properly write IIF commands.
Hope this helps!