Format Currency Problem

Hello,
I'm running SQL Server & Reporting Services locally on my development PC.
My regional settings are UK English (ie. currency format uses "£").
I create a new report containing a MONEY field and set the Format property
to "C". This does not work - the values are formatted with "$" not "£" as
expected.
Any ideas?
Thanks, JoeFurther information:
I forgot to say that I'm writing the report using Visual Studio .NET 2003.
Also if I specify "£#,###.00" as the value of the Format property, then it
works. However surely "C" should work.
"Joe" wrote:
> Hello,
> I'm running SQL Server & Reporting Services locally on my development PC.
> My regional settings are UK English (ie. currency format uses "£").
> I create a new report containing a MONEY field and set the Format property
> to "C". This does not work - the values are formatted with "$" not "£" as
> expected.
> Any ideas?
> Thanks, Joe|||Check that the Reports Language is set to English (United Kingdom) by
selecting the BODY of the report and looking at the properties.
It looks like all new reports default to US, ignoring the PC's regional
settings.
Dave Hughes
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> Further information:
> I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> Also if I specify "£#,###.00" as the value of the Format property, then it
> works. However surely "C" should work.
>
> "Joe" wrote:
> > Hello,
> >
> > I'm running SQL Server & Reporting Services locally on my development
PC.
> > My regional settings are UK English (ie. currency format uses "£").
> >
> > I create a new report containing a MONEY field and set the Format
property
> > to "C". This does not work - the values are formatted with "$" not "£"
as
> > expected.
> >
> > Any ideas?
> > Thanks, Joe|||David - thanks very much for your reply.
I develop my reports in Visual Studio 2003 - the report body did not have a
Language property - BUT each individual control (eg Chart or Table) did have
the Language property set to "Default". I changed this to "English (United
Kingdom)" and it works.
Thanks for your help!
"David Hughes" wrote:
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe
>
>|||Thanks David.
In VS2003 the report body did not have a Language property. But each
individual control (eg. chart, table etc) did have the Language property. I
set this as suggested & it works!
Cheers,
Joe
"David Hughes" wrote:
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe
>
>|||Actually just realised the Language property is part of the REPORT object,
not the BODY.
You should be able to simply change that one property and everything should
work
Dave
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:D929F73B-C0AE-410B-8B51-E71C21507EA3@.microsoft.com...
> David - thanks very much for your reply.
> I develop my reports in Visual Studio 2003 - the report body did not have
a
> Language property - BUT each individual control (eg Chart or Table) did
have
> the Language property set to "Default". I changed this to "English
(United
> Kingdom)" and it works.
> Thanks for your help!
>
> "David Hughes" wrote:
> > Check that the Reports Language is set to English (United Kingdom) by
> > selecting the BODY of the report and looking at the properties.
> >
> > It looks like all new reports default to US, ignoring the PC's regional
> > settings.
> >
> > Dave Hughes
> >
> > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > > Further information:
> > >
> > > I forgot to say that I'm writing the report using Visual Studio .NET
2003.
> > >
> > > Also if I specify "£#,###.00" as the value of the Format property,
then it
> > > works. However surely "C" should work.
> > >
> > >
> > >
> > > "Joe" wrote:
> > >
> > > > Hello,
> > > >
> > > > I'm running SQL Server & Reporting Services locally on my
development
> > PC.
> > > > My regional settings are UK English (ie. currency format uses "£").
> > > >
> > > > I create a new report containing a MONEY field and set the Format
> > property
> > > > to "C". This does not work - the values are formatted with "$" not
"£"
> > as
> > > > expected.
> > > >
> > > > Any ideas?
> > > > Thanks, Joe
> >
> >
> >|||Even better!
Cheers again
"David Hughes" wrote:
> Actually just realised the Language property is part of the REPORT object,
> not the BODY.
> You should be able to simply change that one property and everything should
> work
> Dave
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:D929F73B-C0AE-410B-8B51-E71C21507EA3@.microsoft.com...
> > David - thanks very much for your reply.
> >
> > I develop my reports in Visual Studio 2003 - the report body did not have
> a
> > Language property - BUT each individual control (eg Chart or Table) did
> have
> > the Language property set to "Default". I changed this to "English
> (United
> > Kingdom)" and it works.
> >
> > Thanks for your help!
> >
> >
> > "David Hughes" wrote:
> >
> > > Check that the Reports Language is set to English (United Kingdom) by
> > > selecting the BODY of the report and looking at the properties.
> > >
> > > It looks like all new reports default to US, ignoring the PC's regional
> > > settings.
> > >
> > > Dave Hughes
> > >
> > > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > > news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > > > Further information:
> > > >
> > > > I forgot to say that I'm writing the report using Visual Studio .NET
> 2003.
> > > >
> > > > Also if I specify "£#,###.00" as the value of the Format property,
> then it
> > > > works. However surely "C" should work.
> > > >
> > > >
> > > >
> > > > "Joe" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > I'm running SQL Server & Reporting Services locally on my
> development
> > > PC.
> > > > > My regional settings are UK English (ie. currency format uses "£").
> > > > >
> > > > > I create a new report containing a MONEY field and set the Format
> > > property
> > > > > to "C". This does not work - the values are formatted with "$" not
> "£"
> > > as
> > > > > expected.
> > > > >
> > > > > Any ideas?
> > > > > Thanks, Joe
> > >
> > >
> > >
>
>|||You do not seem to get the Language property when you just select the
BODY of the report. However, if you select the "View Code" icon to
view the xml of the report and scroll right to the bottom, you will
find the <Language>en-US</Language> tag as the second last line.
Change this to <Language>en-GB</Language. and it will change the
currency to £.
Regards
Wee-Lin
"David Hughes" <spamfree@.freespam.com> wrote in message news:<eaqBXOlxEHA.1296@.TK2MSFTNGP10.phx.gbl>...
> Check that the Reports Language is set to English (United Kingdom) by
> selecting the BODY of the report and looking at the properties.
> It looks like all new reports default to US, ignoring the PC's regional
> settings.
> Dave Hughes
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:904F17E2-6BDC-4660-8BC7-26901184B00F@.microsoft.com...
> > Further information:
> >
> > I forgot to say that I'm writing the report using Visual Studio .NET 2003.
> >
> > Also if I specify "£#,###.00" as the value of the Format property, then it
> > works. However surely "C" should work.
> >
> >
> >
> > "Joe" wrote:
> >
> > > Hello,
> > >
> > > I'm running SQL Server & Reporting Services locally on my development
> PC.
> > > My regional settings are UK English (ie. currency format uses "£").
> > >
> > > I create a new report containing a MONEY field and set the Format
> property
> > > to "C". This does not work - the values are formatted with "$" not "£"
> as
> > > expected.
> > >
> > > Any ideas?
> > > Thanks, Joe