Hello all, Hope you can help me out. Scenario;
SSRS 2012 in Sharepoint Foundation 2010. Basic select between two dates report with date parameters. When I run this in Sharepoint and pick a date, e.g. '01/06/2012' the parameter box displays date in UK "DD/MM/YYYY" format, correct so far. When I hit apply the report runs and returns the correct data, however the dates in the parameter box have switched to what in this example would be "06/01/2012", if I have selected a date like "22/06/2012" (26th June 2012) when I hit apply it will switch the dates around and append a time (always 12:00:00 AM). The Server location is set up as English United Kingdom, the browser language preference is en-GB. To check the server settings were ok I installed a native SSRS on the same server and do NOT encounter the same problems.
I have tried setting the language of the report to en-GB and User!Language, neither changed it. The Sharepoint site collection Locale is English (United Kingdom). I have tried setting the .NET Globalization to en-GB and set Enable Client Based Culture to to True. No luck. I added a placeholder to my Report with the User!Language built in field in it. From the same browser (different tabs) I ran the report in SSRS Native and from Sharepoint; SSRS Native returned en-GB, SSRS SharePoint integrated en-US. Not sure what else I can do. Hope you can all help.