date picker in RS doesn't follow regional setting -- sql server reporting services

sql server reporting services : date picker in RS doesn't follow regional setting

minority
6/12/2007 11:22:16 PM

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!

minority
6/13/2007 7:24:41 PM

anybody?

Stefan
6/26/2007 12:00:00 AM

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...
[quoted text, click to view]

Paul Cahill
6/28/2007 4:55:10 PM

Thanks Stefan.

Worked great for me en-GB

Paul Cahill

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn