Currency formatting: how to change to use another locale... or is US format hard coded?

How to I change the formatting of my currency based members according to the actual currency that they are defined in rather than the default US format? (in my case GBP).

Answers to this can be found here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=887100&SiteID=1

I got sorta the same problem..

|||

FYI: Direct link to answer:

http://sqljunkies.com/WebLog/mosha/archive/2005/10/13/mdx_format_currency.aspx

Am I right in thinking that I should create a Script Command in the Calculuations tab to set the appropriate languages for my measures?

eg:

Language([Measures].[GBPEQUIV-SENSITIVIES]) = 2057;

Language([Measures].[GBPEQUIV-STRESS]) = 2057;

BTW: I also changed the server locale to English-UK to get a default setting.

|||

Yeah I think you could do that, I have a script command like that with: Language(this) = 1053

Currency Formatting

Is there a way to format currency for check print using the reporting
services software? For example, instead of displaying $32,469.68, I could
display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
--
K. ThomasI would use a UDF on the SQL side to return this as a string
"K. Thomas" wrote:
> Is there a way to format currency for check print using the reporting
> services software? For example, instead of displaying $32,469.68, I could
> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
> --
> K. Thomas|||Or you could write code and put in a custom assembly. In RS Books Online
look for "assembly references" in the index.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
>I would use a UDF on the SQL side to return this as a string
> "K. Thomas" wrote:
>> Is there a way to format currency for check print using the reporting
>> services software? For example, instead of displaying $32,469.68, I
>> could
>> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
>> --
>> K. Thomas|||Jeff,
In terms of efficiency, I stand well corrected,
Thanks,
Tony
"Jeff A. Stucker" wrote:
> Or you could write code and put in a custom assembly. In RS Books Online
> look for "assembly references" in the index.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
> news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
> >I would use a UDF on the SQL side to return this as a string
> >
> > "K. Thomas" wrote:
> >
> >> Is there a way to format currency for check print using the reporting
> >> services software? For example, instead of displaying $32,469.68, I
> >> could
> >> display "thirty-two thousand four hundred sixty-nine and 68/100 dollars".
> >> --
> >> K. Thomas
>
>|||I have no idea which would be more efficient, I just like knowing there are
multiple options... ;-)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
news:2C1B882D-A985-4CD0-B791-46A4BF12F8B3@.microsoft.com...
> Jeff,
> In terms of efficiency, I stand well corrected,
> Thanks,
> Tony
> "Jeff A. Stucker" wrote:
>> Or you could write code and put in a custom assembly. In RS Books Online
>> look for "assembly references" in the index.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
>> news:3199963D-FEDA-4E92-B278-F50E38DEC8F6@.microsoft.com...
>> >I would use a UDF on the SQL side to return this as a string
>> >
>> > "K. Thomas" wrote:
>> >
>> >> Is there a way to format currency for check print using the reporting
>> >> services software? For example, instead of displaying $32,469.68, I
>> >> could
>> >> display "thirty-two thousand four hundred sixty-nine and 68/100
>> >> dollars".
>> >> --
>> >> K. Thomas
>>

Currency Formatting

I have a report that uses the following xml dataset via a DPE I got from Teo
Lachev:
<dsDisplay>
<Table1>
<AreaGroup>Orange County </AreaGroup>
<Col1>96090.8100</Col1>
<Col2>310241.9500</Col2>
<Col3>95732.6400</Col3>
<Col4>123224.3500</Col4>
<ShowFilter>show</ShowFilter>
<V1>-214151.1400</V1>
<V2>-27491.7100</V2>
</Table1>. . . . . . . .
I am specifying Currency formatting for the textboxes having numeric amounts
but it doesn't format - they still appear as they are in the dataset.
Why would this not work?
Thanks,
TI suspect that your report data is being treated as a string. If that is
correct the currency formatting will affect how your report data is
displayed.
What you need to do is to convert the data to a numeric format and then
apply the currency formatting. The textbox value expression you will need
should be similar to this:
=CDbl(Fields!<SomeFieldName>.Value)
Please see the VB Type Conversion discussion at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vagrptypeconversion.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tina" <tinamseaburn@.removespamexcite.com> wrote in message
news:OegSX3shEHA.1156@.TK2MSFTNGP10.phx.gbl...
> I have a report that uses the following xml dataset via a DPE I got from
Teo
> Lachev:
> <dsDisplay>
> <Table1>
> <AreaGroup>Orange County </AreaGroup>
> <Col1>96090.8100</Col1>
> <Col2>310241.9500</Col2>
> <Col3>95732.6400</Col3>
> <Col4>123224.3500</Col4>
> <ShowFilter>show</ShowFilter>
> <V1>-214151.1400</V1>
> <V2>-27491.7100</V2>
> </Table1>. . . . . . . .
> I am specifying Currency formatting for the textboxes having numeric
amounts
> but it doesn't format - they still appear as they are in the dataset.
> Why would this not work?
> Thanks,
> T
>|||I forgot to include the schema info in the xml file. Once I did that it
worked just fine.
As Anna Roseanadana would say, uh, never mind :)
T
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:OeHsUMthEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I suspect that your report data is being treated as a string. If that is
> correct the currency formatting will affect how your report data is
> displayed.
> What you need to do is to convert the data to a numeric format and then
> apply the currency formatting. The textbox value expression you will need
> should be similar to this:
> =CDbl(Fields!<SomeFieldName>.Value)
> Please see the VB Type Conversion discussion at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vagrptypeconversion.asp
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> news:OegSX3shEHA.1156@.TK2MSFTNGP10.phx.gbl...
> > I have a report that uses the following xml dataset via a DPE I got from
> Teo
> > Lachev:
> > <dsDisplay>
> > <Table1>
> > <AreaGroup>Orange County </AreaGroup>
> > <Col1>96090.8100</Col1>
> > <Col2>310241.9500</Col2>
> > <Col3>95732.6400</Col3>
> > <Col4>123224.3500</Col4>
> > <ShowFilter>show</ShowFilter>
> > <V1>-214151.1400</V1>
> > <V2>-27491.7100</V2>
> > </Table1>. . . . . . . .
> >
> > I am specifying Currency formatting for the textboxes having numeric
> amounts
> > but it doesn't format - they still appear as they are in the dataset.
> >
> > Why would this not work?
> > Thanks,
> > T
> >
> >
>