SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2012 in Sharepoint Integrated Date problem


SSRS 2012 in Sharepoint Integrated Date problem

Author
Message
tom.hussey
tom.hussey
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 79
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
Attachments
Parameters pre.png (22 views, 31.00 KB)
lokem
lokem
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 37
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.
lokem
lokem
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 37
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search