Date Picker RS2005SP2 useless

I read a lot of posts in this forum, but none of them provide a solution.

Probably it is related to SP2 as many report, I have SP2 as well...

A funny situation:
I have a report parameter @.date, datatype datetime, so I can use the datepicker control.

But, even when not using this @.date parameter in my dataset, I still get the error:

The value provided for the report parameter 'date' is not valid for its type. (rsReportParameterTypeMismatch)

Of course it has to do with regional settings and languages etc... But at my international client's site, workstations are in any regional setting and servers are in en-US, nothing I can do about that.

Come'on Microsoft, don't tell us this datePicker is only for the US market?

Thank You MS!

Apparently it is now solved in the Cumulative update package 2 for SQL Server 2005 Service Pack 2

See http://support.microsoft.com/kb/936305, bug n_ 50001284

Date Picker in US Format after SP2

Updated SQL 2005 to SP2 and Reporting Services Date Picker now has dates defaulting to US format (MM/DD/YYYY) instead of our previous English-Australian (DD/MM/YYYY). Both the clients and server are set to English Australian regional settings in the O/S and the reports are composed for English Australian language. Reports have correct format in Visual Studio development and re-deploying them had no effect. Everything was fine under SP1 - not sure what is going on. Any ideas?

I have had so much trouble with date fields that I now keep them as text fields in Reporting Services and pass then through to SQL Server as VarChars(). Using three letters for the month (Jan, Feb, Mar etc) is the best way to may sure that SQL Server gets it right. I always set a default in the format "12 Apr 07 13:00" so the use sees what format is required. This means not using the date control but in my applications we time as well as date and the date control doesn't do this anyway.

The problem seems to be that there are many places to set the "country" or "language" etc.

Places that I can think of are:-

1. Control Panel/Regonal and Language Settings.

2. SQL Server using Set Language (or Set DateFormat). I believe that this affects the current session and so must be used in every report query.

3. Intenet Explorer, which is relevant when accessing Report Server.

I am not sure which SP I have but the patch level is 9.1.2153.

|||After doing some more analysis; I have found that if a datetime parameter prompt is placed after two parameters that cascade, then the correct date format (in our case English-Australian DD/MM/YYYY) is used in the Date Picker (probably due to the language settings in the client and report). Otherwise you get the US Date format (MM/DD/YYYY). This means that if you have datetime parameters on their own or even with drop downs, multi-selects etc.. then you could be in for trouble. I could be mistaken but this seems like a bug in SQL 2005 SP2.|||The problem has now been narrowed down to the Reporting Services Sharepoint web parts: rswebparts.cab (v2.0). Reports run with the correct date picker format from the report server but are incorrect if they are run from the SharePoint report viewer web part. I believe these web parts were not updated in SP2 (see http://msdn2.microsoft.com/en-us/library/ms159772.aspx)|||We get this same problem outside of sharepoint after sp2. If you go directly to the reportserver (http://yourserver/reportserver) and navigate to the report you may find the same. This problem has surfaced after the sp2 upgrade - strange thing is that is does not occur if we run the report via report manager - I expect why the sharepoint is showing the problem is because it is making a direct call to the reportserver.

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 Picker control returning date is US format

SQL 2005 SP2 + hotfix build 3152
I'm a newbie to reporting services and I am just learning and testing at the
moment. I am based in the UK.
I have set up a report with two parameters that are both dates.
When running the report in the IDE or http://ServerName/Reports dates picked
from the calendar control return as DD/MM/YYYY
When I run the report through http://Servername/ReportServer the date is
returned to the web page as MM/DD/YYYY.
I have found that if I choose a date like 02 Feb so I can run the report and
then use the date picker again without exiting, it then returns DD/MM/YYYY.
My client PC is set to UK English and I have checked my IE settings (I have
tried firefox too). The server is all set to UK english. I have checked the
settings on IIS as well.
I have tried forcing the culture to "en-GB" in web.config.
It's interesting to note that the report services log files (eg
ReportServerWebApp__03_16_2007_14_29_30.log) contains en-US.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
9.00.3152.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServerWebApp__03_16_2007_14_29_30.log</Path>
<SystemName>myservername</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>On 16 mar, 16:05, "Paul Cahill" <a...@.anon.com> wrote:
> SQL2005 SP2 + hotfix build 3152
> I'm a newbie to reporting services and I am just learning and testing at the
> moment. I am based in the UK.
> I have set up a report with two parameters that are both dates.
> When running the report in the IDE orhttp://ServerName/Reportsdates picked
> from the calendar control return as DD/MM/YYYY
> When I run the report throughhttp://Servername/ReportServerthe date is
> returned to the web page as MM/DD/YYYY.
> I have found that if I choose a date like 02 Feb so I can run the report and
> then use thedate pickeragain without exiting, it then returns DD/MM/YYYY.
> My client PC is set to UK English and I have checked my IE settings (I have
> tried firefox too). The server is all set to UK english. I have checked the
> settings on IIS as well.
> I have tried forcing the culture to "en-GB" in web.config.
> It's interesting to note that the report services log files (eg
> ReportServerWebApp__03_16_2007_14_29_30.log) contains en-US.
> <Header>
> <Product>MicrosoftSQLServer Reporting Services Version
> 9.00.3152.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>GMT Standard Time</TimeZone>
> <Path>C:\Program Files\MicrosoftSQLServer\MSSQL.3\Reporting
> Services\LogFiles\ReportServerWebApp__03_16_2007_14_29_30.log</Path>
> <SystemName>myservername</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
> <OSVersion>5.2.3790.131072</OSVersion>
> </Header>
Exactly the same problem here, it is caused by SP2 and his new date-
picker control. Anyone knows if MS is working to correct this?. Thanks.

Date Diffrent between "reports" & "reportserver"

I have a problem with the dates and "datetime" picker in my report
(sqlserver 2005 sp2).
My reginal settings on the server are: "hebrew" - "Isreal".
I have a report with a datetime picker.
If I'm opening the report from: http://myserver/REPORTSERVER and I'm
writting in the datepicker textbox the value "01/04/2008", and then
click on the calander icon it opens on the on the 4th of january 2008.
If I'm opening the report from: http://myserver/REPORTS and I'm
writting in the datepicker textbox the value "01/04/2008", and then
click on the calander icon it opens on the on the 1th of april 2008.
Does anybody know this bug and how to wotk with it?
Thanks.I'm not sure which is getting what you want. Is Reports getting you want you
want?
When you say opening it from reportserver how are you doing this? Are you
using URL integration in your app? Jump to URL from another Report? Or some
other way?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nicknack" <roezohar@.gmail.com> wrote in message
news:bad0a977-4b16-4561-a661-ac0b35437d4b@.s37g2000prg.googlegroups.com...
>I have a problem with the dates and "datetime" picker in my report
> (sqlserver 2005 sp2).
> My reginal settings on the server are: "hebrew" - "Isreal".
> I have a report with a datetime picker.
> If I'm opening the report from: http://myserver/REPORTSERVER and I'm
> writting in the datepicker textbox the value "01/04/2008", and then
> click on the calander icon it opens on the on the 4th of january 2008.
> If I'm opening the report from: http://myserver/REPORTS and I'm
> writting in the datepicker textbox the value "01/04/2008", and then
> click on the calander icon it opens on the on the 1th of april 2008.
>
> Does anybody know this bug and how to wotk with it?
> Thanks.