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?
>