October 29, 2010 at 3:21 am
I have a set of reports which use dundas reporting tool to build the charts. When it comes to the Number and currency formatting, the latter is being set according to the language setting at the report level and/or the regional settings. The deal is that I'm trying to assign a currency for a middle eastern country, if i change the regional settings both numbers and currency logo would be represented in arabic letters which i want to avoid. My goal is to keep the numbers in latin digits and the currency be represented by 'SR' Saudi Riyals instead of the currency initials in arabic letters.
Is there any way I could possibly do that or maybe add a customized currency logo and correlate it in relation to the report settings?
Regards,
Samer.
October 29, 2010 at 6:03 am
without experience with dundas, I can only give you how to solve that in SSRS itself.
Simply use SR # ##0.00 as format.
Maybe this works in Dundas as well, or might give you a clou towards the solution.
Peter Rijs
BI Consultant, The Netherlands
October 29, 2010 at 7:15 am
Dear Peter,
The code definitely worked... even on dundas charts. However I was looking for something on a more global level, maybe reporting services due to the fact that i need to apply these changes on 40+ reports each containing a minimum of 3 charts, so thats gona take some time.
Thanks for the help buddy 🙂
Regards,
Samer.
October 29, 2010 at 9:07 am
I'm afraid you would have to look at the windows regional setting to make that happen globally without touching the reports.
But changing the format in 40 reports shouldn't be that hard (if you want to override all currencyformats to "SR #.##0.00"):
the rdl files are plain xml, so you can open all 40 of them together in (for instance) Notepad ++ and do a "Replace All in all opened files"-operation, replacing the tag
<Format>C2</Format>
with
<Format>SR # ##0.00</Format>
Hope that helps. If you decide to go the other way and find a way to overrule the regional setting for all reports please post your solution back here. That might be interesting to all of us.
Peter Rijs
BI Consultant, The Netherlands
November 1, 2010 at 1:27 am
Dear Peter,
I have already tried the regional settings option and it didn't help much in my case... In the Regional Options tab > Customize In the Numbers tab > Digit substitution: if you select National then all digits & currency strings in addition to x/y axis labels are converted to the characters in the specified native language. On the contrary, selecting Context will just convert the values on the charts along with the currency string to the characters of the language specified in regional settings.
In either ways the field values will be converted in my case to arabic, something I want to avoid. So the solution you presented by replacing the currency label in the xml would be the best option to keep the values in latin characters and set the currency string as 'SR' rather than its Arabic equivalent!
Most appreciated,
Samer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply