Wednesday, October 17, 2007

DateTime-picker problem in Reporting Services 2005

If you are in a situation where you are using a localized version of Internet Explorer, that is anything else than the English version or your browser has been set up to use another locale than English, then you will run into trouble when using the datetime picker in SSRS.
The datetime picker is shown in your reports when you are having report parameters defined as DateTime..

The fact is that Report Server interprets the date selected in the picker as English, however the picker writes the date as it's supposed to in the local language. You get a rsReportParameterTypeMismatch error.

The fix, which is described by Microsoft here , is to change the page definition of the Report Viewer Page and insert your own culture on that particular page by adding the culture property of the aspx page.

1 comments:

Anonymous said...

it's been a year, post something else!