Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Services / Reporting Services / April 2005

Tip: Looking for answers? Try searching our database.

datetime + sp2?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frank Ashley - 27 Apr 2005 21:36 GMT
In report designer using the data tab when testing the datetime parameters
the datetime is being shown as UK locale and the data is being rendered
properly (UK locale). However, if I then switch to the preview tab the
datetime parameters are being formatted US locale. If I deploy the result is
the same, US style locale.

I have set the report language to English UK the machine locale is set to
UK, IE is set to en-gb. What can I do next?

I was wondering if this is an sp2 issue as sp1 fixed the locale issues.

Thanks
Frank
Reply to this Message
Brian Welcker [MSFT] - 28 Apr 2005 05:40 GMT
What is the VS languge set to?

Signature

Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

> In report designer using the data tab when testing the datetime parameters
> the datetime is being shown as UK locale and the data is being rendered
[quoted text clipped - 9 lines]
> Thanks
> Frank
Reply to this Message
Frank Ashley - 28 Apr 2005 07:58 GMT
VS2003 is set to

Tools | International Settings | Language | Same as Microsoft office
(language neutral)

Office 2003 Enabled langauge is set to English (UK) and default behaviour is
set to English UK.

Hope this helps.

Frank

> What is the VS languge set to?
>
[quoted text clipped - 11 lines]
>> Thanks
>> Frank
Reply to this Message
Brian Welcker [MSFT] - 29 Apr 2005 17:40 GMT
Can you try a non-English locale? I'm stumped.

Signature

Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

> VS2003 is set to
>
[quoted text clipped - 23 lines]
>>> Thanks
>>> Frank
Reply to this Message
Frank Ashley - 30 Apr 2005 09:20 GMT
Hi Brian,

I changed the locale to Finnish and the dates were rendered as dd.mm.yyyy
hh:mm:ss in the data tab but still the drop down on the preview tab showed
mm/dd/yyyy hh:mm:ss

I then tried removing Reporting Services and re-installing (going straight
to sp2, bypassing sp1) but still the same results.

regards
Frank

> Can you try a non-English locale? I'm stumped.
>
[quoted text clipped - 25 lines]
>>>> Thanks
>>>> Frank
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.