RsReportParameterTypeMismatch - When Passing DateTime Parameter To Drill Through Report

All,



I have two reports in my project. One is summary and the other is drill through. In Summary report I have StartDate and EndDate Parameters which are DateTime type. Language settings on my workstation are set to Canadian English, and so are in the IE. When I deploy the reports to the Sharepoint WebParts based reporting portal, the reports run fine individually. However, when I try to drill through from summary report to the detail report, the following error is displayed, where the StartDate is 13/07/2007 (Canadian format dd/MM/yyyy):







The value provided for the report parameter 'StartDate' is not valid for its type. (rsReportParameterTypeMismatch)





Why do the reports run fine individually? Obviously something is wrong with Report Server processing the parameters, that it converts the date format to US English only when passing parameters to drill through report. This problem is eliminated when I change the language settings to US-English on my workstation.



Any ideas how can this be fixed, if at all? It would certainly be not feasible to have all the users change their settings from Canadian to US-English.



Thanks.