Its good to have a calendar control in the new Reporting Services 2005 which wasn't available in the previous version.
Good on you Microsoft but sorry the calendar control isn't working well.
I was working on some reports and i noticed that when previewing the reports in Visual Studio or in the Report Manager site all seems good when i select a date from the date picker it does format accordingly to my culture setting which is en-AU
date format e.g dd/M/YYYY but when i'm loading the reports via the ReportViewer Page or from a webpart which uses the
Report Viewer and select a date using the date picker it sets it back to the American Culture settings which is m/d/yyyy.
I have set the language of the report itself to use English(Australia). You can set this by clicking on the Report on the properties pane >under Misc > Language :
And thats not what i wanted
and i keep getting errors as the dates aren't correct and users won't be happy.
So what i did was when i select the date picker and select a date i noticed it does a post back.
By looking at the
URL string at the bottom of your browser quickly i noticed the Calendar&=LCID =127...
when viewing the reports via the ReportViewer Page or from a webpart which is also using the ReportViewer control
But when viewing the reports from the
Report Manger the URL shows LCID = 3081 as i mentioned above
Solution:
So immediately i knew something was and the last thing that came up my mind was to go directly to the ReportViewer.aspx itself and add the Culture setting like this below
<%@ Page Language="C#" AutoEventWireup="true" Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage"
Culture="en-AU"%>
as we can do that on every page
You can find the page here: C:\program files\microsoft SQL Server\MSQL.3\Reporting Services\ReportServer\Pages
But it depends on where you installed it.
Tip:
If you want to find the path to the page go to your IIS under Default website select ReportServer or Reports Folder > right click Properties...
Hope that helps
posted @ Thursday, June 26, 2008 7:10 PM