Changing the format of date parameters on SSRS 2012
Had an issue today where the date parameters were being forced into US data format and not using any of the regional settings from the OS or SharePoint.
This has apparently been fixed in SQL 2012 SP1 CU5 update but i have not confirmed this.
Has a workaround that required you to add a culture into the RSViewerPage.aspx located in
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\ReportServer
or
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\LAYOUTS\ReportServer
in SharePoint 2013
You need to add UICulture="en-GB"
to the end of
<%@ Page language="C#" Codebehind="RSViewerPage.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.SharePoint.UI.RSViewerPage,Microsoft.ReportingServices.SharePoint.UI.ServerPages,Version=11.0.0.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91" %>
The full string looks like
<%@ Page language="C#" Codebehind="RSViewerPage.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.SharePoint.UI.RSViewerPage,Microsoft.ReportingServices.SharePoint.UI.ServerPages,Version=11.0.0.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91" UICulture="en-GB"%>
If you are using Windows 2012 i had to save the updated file to a different location and then copy the file in and gain the correct permissions.
via Buzz Blog http://paulbuzzblog.wordpress.com/2014/01/10/changing-the-format-of-date-parameters-on-ssrs-2012/
   Paul is a an expert SharePoint and Project Server developer and is responsible for designing and implementing custom solutions on client systems using the latest SharePoint and .NET technologies.
Paul has extensive experience with SharePoint systems across all sizes of implementation, ranging from small to large farms and has an excellent understanding of all the elements of SharePoint. This article has been cross posted from paulbuzzblog.wordpress.com (original article) |
SharePoint (and Project Server) Shenanigans 