SSRS 2012 in Sharepoint Integrated Date problem

  • 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.

    Thanks

    Tom

  • We also have the same issue. We have also checked the locale of client OS, client browser, server OS.

    Also tried changing culture on RSViewerPage.aspx and webpart in addition to global culture - no effect.

  • If anyone is still looking for an answer, the only solution/workaround I could think of is modifying all aspx pages with rsviewer on it, specify for example UICulture="en-NZ" in the <%@ Page... tag

    It's not pretty as it breaks formatting of parameter pane.

    Cheers

    Michael

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply