Formatting dates using regional settings

When presenting a date in a report, I want Reporting Services to use the
regional settings on the client to determine this. Is this possible. The
following post from Charles Kangai on 8/12/2004 said that this was possible.
However when I follow his instructions, Reporting Services still presents
the date in the US format (presumably using the "Language" property of the
object, set to "default" in my report) whereas my regional settings are set
to UK date format (both short and long date).Thanks for that.
The report level language property was set to US which was why it wasn't
working.
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:9609E7E7-5091-4631-BE18-CE0C4B9B2F50@.microsoft.com...
> Hi,
> Make sure the Report's Language property and the textbox's Language
property
> are both set to Default. Then set the Format property of your textbox to
"d"
> (Short Date) or "D" (Long Date), without the double quotes. It should
display
> according to the setting in your Regional Settings. I have just tried it
> again after reading your post, and it works.
> Charles Kangai, MCDBA, MCT
> "GML" wrote:
> > When presenting a date in a report, I want Reporting Services to use the
> > regional settings on the client to determine this. Is this possible.
The
> > following post from Charles Kangai on 8/12/2004 said that this was
possible.
> > However when I follow his instructions, Reporting Services still
presents
> > the date in the US format (presumably using the "Language" property of
the
> > object, set to "default" in my report) whereas my regional settings are
set
> > to UK date format (both short and long date).
> >
> >
> >

Formatting C# code, specifically curlys {}

1. For some reason, my Debug menu had many options missing. I found some
help that said go to Tools/Import & Export Settings and Choose Reset All. I
did it, and chose C# Developer and now my Debug menu is fully restored.
However, I did lose all of my other customzied settings, i.e. fonts, colors,
etc...
2. In my environment, before I did #1 above, when I keyed in two curly's
like this: {}, it would automatically move the ending curly to a new line
underneath. So, example:
I type this: {}
I get this after pressing enter:
{
}
For some reason, this no longer works.
3. I've changed settings in: Tools/Options/Text Editor/C#/Formatting.
Specifically the 'Automatically format completed block on }'. I'm not sure
if this is even the correct setting, but I tried anyway. I've also tried
the other settings in that screen and nothing happens.
Can someone advise if they've seen or fixed this problem? It worked for me
this morning, I reset my environment to get my Debug menu, and now it doesnt
work anymore.
Kind regards,
JrWhoops. Wrong group. Sorry.
"JrMcG" <JrM@.noemail.noemail> wrote in message
news:%23KRJGv$qGHA.4508@.TK2MSFTNGP04.phx.gbl...
> 1. For some reason, my Debug menu had many options missing. I found some
> help that said go to Tools/Import & Export Settings and Choose Reset All.
> I did it, and chose C# Developer and now my Debug menu is fully restored.
> However, I did lose all of my other customzied settings, i.e. fonts,
> colors, etc...
> 2. In my environment, before I did #1 above, when I keyed in two curly's
> like this: {}, it would automatically move the ending curly to a new line
> underneath. So, example:
> I type this: {}
> I get this after pressing enter:
> {
> }
> For some reason, this no longer works.
> 3. I've changed settings in: Tools/Options/Text Editor/C#/Formatting.
> Specifically the 'Automatically format completed block on }'. I'm not
> sure if this is even the correct setting, but I tried anyway. I've also
> tried the other settings in that screen and nothing happens.
> Can someone advise if they've seen or fixed this problem? It worked for
> me this morning, I reset my environment to get my Debug menu, and now it
> doesnt work anymore.
> Kind regards,
> Jr
>

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

Format a Date field in the Regional Settings format.

Hi
How is it possible to format a date field according to the Regional Settings
Short (or Long) Date Format?
It seema that I can hard-code the format as dd/MM/yyyy (which is the date
format in my country), but dates formatted like that may be misleading if
the report is run by users of our software in other countries.
Thanks
Barry Flynn"Barry Flynn" <Anonymouse> a écrit dans le message de news:
uMbfBdR8HHA.1204@.TK2MSFTNGP03.phx.gbl...
> Hi
> How is it possible to format a date field according to the Regional
> Settings Short (or Long) Date Format?
> It seema that I can hard-code the format as dd/MM/yyyy (which is the date
> format in my country), but dates formatted like that may be misleading if
> the report is run by users of our software in other countries.
> Thanks
> Barry Flynn
>
>
You may have to deal with the Language Property of the report.
Patrick|||I'm a bit confused.
Maybe more than a bit... :)
I can see where I can set a Language property for a Table, or a TextBox.
(I can't see where to set it for the Report as a whole.)
But, setting such a property seems to me to be going in the wrong direction.
I want dates to display correctly no matter what country the report is being
run in.
How is setting a specific Language going to achieve that?
Thanks
Barry
"pi" <pisambert@.free.fr> wrote in message
news:%23oR5I6R8HHA.5980@.TK2MSFTNGP04.phx.gbl...
> "Barry Flynn" <Anonymouse> a écrit dans le message de news:
> uMbfBdR8HHA.1204@.TK2MSFTNGP03.phx.gbl...
>> Hi
>> How is it possible to format a date field according to the Regional
>> Settings Short (or Long) Date Format?
>> It seema that I can hard-code the format as dd/MM/yyyy (which is the date
>> format in my country), but dates formatted like that may be misleading if
>> the report is run by users of our software in other countries.
>> Thanks
>> Barry Flynn
>>
> You may have to deal with the Language Property of the report.
> Patrick
>

format 0.00 decimal value

Is there any option/settings in SQL server to return 0 decimal value as
"0.00"
not
".00"
I can do it by converting all results to varchar(), but is there any easy
way? may be server settings?
thanks
L
Formatting of decimal data is done by the front end, not the server.
So the problem is with Query Analyzer, or whatever tool you are using.
If it is QA there is no feature like you are asking for.
Roy Harvey
Beacon Falls, CT
On Wed, 29 Nov 2006 13:43:01 -0800, LLT
<LLT@.discussions.microsoft.com> wrote:

>Is there any option/settings in SQL server to return 0 decimal value as
>"0.00"
>not
>".00"
>I can do it by converting all results to varchar(), but is there any easy
>way? may be server settings?
>thanks
>L
|||I am using QA. The same in DTS when I extract data into txt file. Strange,
but float is returned with leading 0 as "0.00", decimal and money without as
".00". When number converted to string using cast() or str() leading 0 is
shown for all numbers.
You can run in in QA.
select 'money, with varchar cast', cast(cast (0.00 as money) as varchar(10))
select 'money, no varchar cast', cast(0.00 as money)
select 'decimal(10,2) with varchar cast', cast(cast (0.00 as decimal(10,2))
as varchar(10))
select 'decimal, no varchar cast', cast(0.00 as decimal(10,2))
select 'float, with varchar cast', cast(cast (0.00 as float) as varchar(10))
select 'float, no varchar cast', cast(0.00 as float)
"Roy Harvey" wrote:

> Formatting of decimal data is done by the front end, not the server.
> So the problem is with Query Analyzer, or whatever tool you are using.
> If it is QA there is no feature like you are asking for.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 29 Nov 2006 13:43:01 -0800, LLT
> <LLT@.discussions.microsoft.com> wrote:
>

format 0.00 decimal value

Is there any option/settings in SQL server to return 0 decimal value as
"0.00"
not
".00"
I can do it by converting all results to varchar(), but is there any easy
way? may be server settings?
thanks
LFormatting of decimal data is done by the front end, not the server.
So the problem is with Query Analyzer, or whatever tool you are using.
If it is QA there is no feature like you are asking for.
Roy Harvey
Beacon Falls, CT
On Wed, 29 Nov 2006 13:43:01 -0800, LLT
<LLT@.discussions.microsoft.com> wrote:

>Is there any option/settings in SQL server to return 0 decimal value as
>"0.00"
>not
>".00"
>I can do it by converting all results to varchar(), but is there any easy
>way? may be server settings?
>thanks
>L|||I am using QA. The same in DTS when I extract data into txt file. Strange,
but float is returned with leading 0 as "0.00", decimal and money without as
".00". When number converted to string using cast() or str() leading 0 is
shown for all numbers.
You can run in in QA.
select 'money, with varchar cast', cast(cast (0.00 as money) as varchar(10)
)
select 'money, no varchar cast', cast(0.00 as money)
select 'decimal(10,2) with varchar cast', cast(cast (0.00 as decimal(10,2))
as varchar(10))
select 'decimal, no varchar cast', cast(0.00 as decimal(10,2))
select 'float, with varchar cast', cast(cast (0.00 as float) as varchar(10))
select 'float, no varchar cast', cast(0.00 as float)
"Roy Harvey" wrote:

> Formatting of decimal data is done by the front end, not the server.
> So the problem is with Query Analyzer, or whatever tool you are using.
> If it is QA there is no feature like you are asking for.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 29 Nov 2006 13:43:01 -0800, LLT
> <LLT@.discussions.microsoft.com> wrote:
>
>