date picker in RS doesn't follow regional setting

hi all,
i've just updated my sql server 2005 with sp1 and sp2.
i want my report date format to change according to regional setting,
therefore i've set the report property for language as User.Language.
i've also enter the format i wanted in IE option..
how do i set the report parameter of type datetime to follow the
format of regional setting?
my date parameter has default value which i query from a table.
for e.g. if my regional setting is UK and the default date is
9/7/2006, the date picker will display date at 7 september 2006
instead.
please help... thanks!anybody?|||https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=271928
The following solution helped me:
Change Culture for your reportserver page.
Edit the ReportViewer.aspx webpage. It usually in this directory:
"%ProgramFiles%\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\Pages\"
Add Culture attribute to the @.Page declaration like this:
<%@. Page Language="C#" AutoEventWireup="true"
Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage"
Culture="de-DE" %>
Regards,
Stefan
"minority" <kokpenglow@.gmail.com> schrieb im Newsbeitrag
news:1181787881.409498.256650@.g37g2000prf.googlegroups.com...
> anybody?
>|||Thanks Stefan.
Worked great for me en-GB
Paul Cahill
"Stefan" <stefan@.nospam.nospam> wrote in message
news:e#k506$tHHA.4572@.TK2MSFTNGP02.phx.gbl...
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=271928
> The following solution helped me:
> Change Culture for your reportserver page.
> Edit the ReportViewer.aspx webpage. It usually in this directory:
> "%ProgramFiles%\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\Pages\"
> Add Culture attribute to the @.Page declaration like this:
> <%@. Page Language="C#" AutoEventWireup="true"
> Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage"
> Culture="de-DE" %>
>
> Regards,
> Stefan
>
> "minority" <kokpenglow@.gmail.com> schrieb im Newsbeitrag
> news:1181787881.409498.256650@.g37g2000prf.googlegroups.com...
>> anybody?
>

date picker format

hi all,

i've just updated my sql server 2005 with sp1 and sp2.

i want my report date format to change according to regional setting, therefore i've set the report property for language as User.Language.

how do i set the report parameter of type datetime to follow the format of regional setting?

my date parameter has default value which i query from a table.

for e.g. if my regional setting is UK and the default date is 9/7/2006, the date picker will display date at 7 september 2006 instead.

please help.... thanks!

i've also enter the format i wanted in IE option..

|||If you have a parameter of datetime, and the report language setting is user!langauge, and the datetime in IE is not coming out as expected, then you do not have you local regional settings set up correctly.|||

thanks for your reply adolf...

my pc regional setting:

Regional Options tab:

Standard and formats:

English (United Kingdom)

Short date: 14/06/2007

Long date: 14 June 2007

Location: United Kingdom

Advanced tab:

Language for non-Unicode programs:

English (United Kingdom)

anywhere else to check? thanks!

|||In IE but I think you said you already checked this:

IE: tools - options - general - [languages...] -

There may be something else to check, if the above doesn't work let me know and I'll try and find out|||

in IE, Language: English (United Kingdom) [en-gb]

still not working... is it because of the default value of the parameter? but it's displaying the correct format for the date...

thanks for your help

Date format in ms sql

I have computer with Serbian standards and formats (Regional Settings).

I use datepicker control to select date, but when I try to insert it into database (DatePicker1.Value) it throws error.

What should I set up in order to be able to insert date into ms sql 2000 database, without having to change Regional settings?

This is last question for tonight

Thanks,
Milan

If you use parameters, rather than trying to build up the SQL INSERT into a string.

http://aspnet101.com/aspnet101/tutorials.aspx?id=1

|||Very simple. nice and clean solution.

You just make me close bunch of open browser tabs and windows with Google's results

Thanks a lot.

date format according to regional setting

hi all,

is it possible to format a datetime value in report to display according to the shortdate format set in pc's regional setting ?

i manage to get the parameters to display according to the format in regional setting but is it possible for fields in report to follow shortdate format ?

btw, i can't seem to find the setting for report language under report tab in vs.

i could find language under Tools -> Options -> International Settings -> Language. is it the same thing? cos i've been reading other related posts and seems like the setting can be found under report tab..

Thanks!

Yes, you can specify the format and language style property in the report in order to do that. For detailed information about setting the language property, you can take a look at this page http://msdn2.microsoft.com/en-us/library/ms156493(SQL.90).aspx

|||

hi Fang,

thanks a lot for the swift answer. thanks a lot for pointing me to the url. had been searching high and low through the help file.

i have another problem i.e. i use stored procedure for some of the datasets and the dateformat will cause an error. i know there's a set language function for stored proc but how can i retrieve the pc's regional setting and specify it in the stored proc ?

thanks again!

|||You can pass in User!Language as a query parameter to the stored proc.|||

hi Fang,

i've tried but got this error in RS:

SET LANGUAGE failed because 'en-GB' is not an official language name or a language alias on this SQL Server.

is it the configuration in regional setting?

thanks!

date field not standardize

my problem is about how to standardize format date while storing data

- > my pc set regional setting as mm/dd/yyyy
-> ms sql server just followed this format (i guess)
->date field using data type datetime


i have web page that required user insert date with format dd/mm/yyyy

after that i'll convert that value to ->mm/dd/yyyy

it seem to be okay at first . but when i try to insert this date value it will start to be suck all my day.

date value -> 05/11/2003 (that mean 05 November 2003)
suppose that data store to table -> 11/05/2003

but this is what happen to my table ->05/11/2003 . so it take 05 as month and 11 as day. but when i try insert more then 10 day it's okay 15/12/2003

sorry if my word not very clear. but i really need help on thisIf you are transferring the date as a string then use yyyymmdd - it is unambiguous (yyyy-mm-dd is not).