Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rmason
Starting Member
12 Posts |
 Posted - 2006-04-10 : 06:56:52
|
| Hi,I'm sure this is a widely understood issue for non US developers but I can't seem to find a definitive solution.The Issue:I add a parameter to a report and assign the DateTime data type to it. When I run the report I can choose a date from the Calendar control and it populates the field with what looks like the correct date, e.g. 04/01/2006 (4th Jan 2006). I put a text box on the report to display the parameter value and it returns "01 April 2006". And what's more confusing is that the field containing the parameter at the top of the report has now changed to 01/04/2006.Interestingly if I rerun the report without changing anything the two values toggle between 01/04/2006 and 04/01/2006...? As if there is some internal conversion going on...?My locale is set up as English (United Kingdom) as is the language for the report under Report Properties.I'm sure there is a simple solution/work around for this 'feature' of SSRS. If you know it please share!!Many thanks,Rob. |
|
|
rmason
Starting Member
12 Posts |
Posted - 2006-04-10 : 09:52:31
|
| Right I have just worked out that this is only an issue when you run the report in BI Dev Studio. Once deployed and run from the report manager it's OK. So I guess this is just a bug within the development environment???Rob. |
 |
|
|
|
|
|
UK Date Format for Date Parameter