Início > Language and Dates > rsReportParameterTypeMismatch when changing date in DateTime Picker

rsReportParameterTypeMismatch when changing date in DateTime Picker

When viewing a report through the Report Viewer (http://servername:port/reportserver) I get an error message “Der Wert, der für den ParamEndDate-Berichtsparameter angegeben ist, ist für dessen Typ ungültig. (rsReportParameterTypeMismatch)” when changing the date value with the date time picker.
The browser is configured to use German as Language Preference. The time format of the initial value is “16.04.2007 00:00:00”. When changing the value trough the date time picker the format changes to “04/27/2007” and the error message rsReportParameterTypeMismatch appears when clicking “Show Report”. Viewing the Report through the Report Manager (http://servername:port/reports) I don’t have this problem because the intial time format in the date box has no time information (“16.04.2007”).
The problem also does not appear when configure the Internet Explorer language settings to English (USA).

Solution 1:

Change default language of IE of your client in Internet Options – Language. Check if the default language is correct.

Solution 2 :

Change Culture for your reportserver page.
Edit the ReportViewer.aspx webpage. It usually in this directory: “%ProgramFiles%\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\Pages\”

Add Culture attribute to the @Page declaration like this:
<%@ Page Language=”C#” AutoEventWireup=”true” Inherits=”Microsoft.ReportingServices.WebServer.ReportViewerPage” Culture=”cs-CZ”%>

Now the date from the datepicker is presented in the culture specific format (for czech it is dd.mm.yyyy).

 

 

Categorias:Language and Dates
  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: