“An error has occurred during
report processing. (rsProcessingAborted) Query Execution Failed for Dataset
“GetAll”. (rsErrorExecutingCommand) Error convirting data type nvarchar to
Datatime.”
The problem is caused by the language settings within Internet Explorer. More particular the date formatting that is used in different parts of the world. In my case Belgium/Europe we use the following formatting: dd/mm/yyyy while in the US the date format is mm/dd/yyyy. This date formating causes the report to fail, therefore following error is displayed:
"Error convirting data type nvarchar to Datatime."
In order to get the correct date formating which the report is expecting, you need to add the EN-US language to Internet Explorer:
Open Internet explorer, Go to
Internet Options, Appearance and select language.
Move En-US to first place and click ok.
Wow, what a solution
ReplyDelete