Hi,
I use MSRS 2000 to create some reports and, unfortunately, upgrading
to MSRS 2005 is not an option for now. These reports will be viewed in
many countries around the world (some in Africa, Viet-Nam, South
America, etc).
I have problems to properly format currency numbers.
Reporting services doesn't seem to have african countries/languages in
the Language setting (textbox).
So, in this case, as my organization is a french speaking one, I would
prefer to format currency numbers in the French format (like 1 000
000,00 as one million) (space as thousand separator and comma as
decimal separator). Also, the numbers need to be surrounded by rounded
parentheses if they are negatives and I DON'T want to have any
currency symbol before or after the number (no $, =C2=A3, =E2=82=AC or any =
other
currency symbol).
I searched the web and groups, but I didn't find anything interesting.
The Format() function seemed to be good, but it didn't work (not as I
want)
I want something like :
12 345 678,12
1 234,56
123,45
Does anybody know how can I format properly these numbers?
Can I format a currency number to be non locale specific?
Thanks a lot!