| Author |
Topic |
|
Serge
Starting Member
44 Posts |
 Posted - 2008-12-16 : 12:03:19
|
| Hi,I have a problem where my SSRS server is different to my data server, and by the looks of things SSRS datatime format is different to the data server. The problem is that if I request a report from 01/11/2008 (dd/mm/yyyy) to 01/12/2008 (dd/mm/yyyy) from my local machine, the SSRS then treats it as US format, and requests data from the data server in the period of one day!? o_0 i.e. it submits it to data server as from 11/01/2008 to 12/01/2008... which is total nonsense. Especially I have schedules set up and every time the report gets triggered the dates and the data inside it is messed up...I am really sick and tired of UK and US dates differences.Is there are a way to tell SSRS treat datetime variable in UK format. Without reinstalling the whole damn thing????Please helpThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 12:08:30
|
| what is the language settings set for report? |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-12-16 : 23:10:24
|
| Hi,I previously had the same issue.....But When I deployed the report then it was working fine for me.....check this post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108798[/url] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 00:02:13
|
| i would say its either problem with language settings of report or regional or language settings of machine. Also have you applied sp2 lately? |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-17 : 03:49:58
|
| Yeah, I had SP2 deployed and I think this is when it started to happen. Language English UK. I have tried with changing language setting on the report itself but still the same... I will try changing language settings on the SSRS machine. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-17 : 03:59:59
|
You can set language in the report itself.Change the language element in the end of rdl file.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 04:07:19
|
quote:
Originally posted by Serge
Yeah, I had SP2 deployed and I think this is when it started to happen. Language English UK. I have tried with changing language setting on the report itself but still the same... I will try changing language settings on the SSRS machine.
is this happening only on report viewer or is it happening even when you view report in report manager? |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-17 : 04:22:49
|
| I just found out that my sql data server has been installed with US date format! Is there are a way I can tell SSRS that any date should be treated in dd/mm/yyyy format? This is turning out to be a complete nightmare! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 04:26:17
|
quote:
Originally posted by Serge
I just found out that my sql data server has been installed with US date format! Is there are a way I can tell SSRS that any date should be treated in dd/mm/yyyy format? This is turning out to be a complete nightmare!
cant you change the regional/language settings of your server to UK english? |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-17 : 04:32:00
|
quote:
Originally posted by visakh16
quote:
Originally posted by Serge
Yeah, I had SP2 deployed and I think this is when it started to happen. Language English UK. I have tried with changing language setting on the report itself but still the same... I will try changing language settings on the SSRS machine.
is this happening only on report viewer or is it happening even when you view report in report manager?
Both I am afraid... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 04:34:11
|
| then easiest way is to change the format of date setting in server. otherwise you've do formatting in all reports in all places where you use date fields |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-17 : 05:12:40
|
quote:
Originally posted by visakh16
then easiest way is to change the format of date setting in server. otherwise you've do formatting in all reports in all places where you use date fields
I was under impression that once installed, you can no longer change it... Can someone please point me out how do I do that?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 05:31:10
|
| http://support.microsoft.com/kb/173907 |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-17 : 09:08:10
|
quote:
Originally posted by visakh16
http://support.microsoft.com/kb/173907
I will get my lazy DBA's on it... Thanks a lot!One question though, if I already have a massive database, changing date format, what implication am I likely to face? I mean there are lots of SPROC's that pass date variables in and get data back, by changing date format will they be screwed up or will the server properly format them? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-17 : 10:27:53
|
Did you see response made 12/17/2008 : 03:59:59 ?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-22 : 05:44:39
|
| I did, and unfortunately it didn't do anything.The issue I reckon is due to different localisation setting on SSRS server and SQL main DataBase.I had a deeper look in to it and what I have new server for SSRS set up. So will see what's up with it once I migrate across. But this date issue is really unacceptable! Don't really want to go on about MS and how poor their practices are but at the end of the day, in this case it is very clear how poor some of their products are! Really! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-22 : 05:47:15
|
Worked for me.Our servers are on US locale and changing the setting described above worked for us having dates displayed in swedish date format as yyyy-mm-dd.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-12-22 : 06:45:18
|
| Well, my report is set to "en-GB" and I don't think there would be an issue if both SSRS and SQL main database were running on the same blade no matter what locale its set to. However I think my problem is the fact that they are both on different blades with different locale settings, which at the end of the day screws me... o_0I will keep fighting the battle, once I got some ideas I will let you know! |
|
|
|
|
Date Format Issue SSRS