March 15, 2007 at 11:07 am
We have SQL 2005 running SSRS and using the Sharepoint 2003 RS web parts for normal users.
After installing SP2, the web parts now change the date selected from the pop up calendar into US format instead of the normal UK format (as per BIDS report properties). These reports have not been changed for months and I even redeployed one of them to see if that fixed this 'bug' but it didn't.
The strange thing is if I use the report manager URL <server>/reports/blah... then the pop up calendar posts the dates in UK format as expected, so it is just the web parts usage which is causing this error but I can't see any location formatting in the sp_full.css file
Another side issue is that via the web parts, when the report displays it changes the blue section to be the report manager grey/brown colour. As this was the case back in SS2000 web parts I guess that SP2 has corrupted something, is SP2b out yet? 🙂
Any Ideas?
TIA.
April 4, 2007 at 7:50 am
I also have this same problem since applying SQL Server 2005 SP2.
Everything possible is set to UK English, but when you select a date for a report parameter from the date picker it displays in US format MM/DD/YYYY but interprets it in UK format DD/MM/YYYY.
I found that if you first run the report with a date that is valid in either US or UK format e.g. 01/01/2007, the second and subsequent execution of the report will display and treat the selected date as UK format. This is not a satisfactory work around.
I am working with a Windows XP SP2 client with IE 7.0. A colleague working with Vista as a client does not have this problem.
If you get a satisfactory solution please let me know.
April 4, 2007 at 7:58 am
I have raised this as a support incident with MS, and will post the resolution, if any, once resolved.
I didn't know that vista didn't experience the problem, I'll test that here.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply