In SSRS 2005 I have a report with two date parameters and in the BIDS environment when I run the report if I've selected a date which can't be read into mm/dd/yyyy such as 30/06/2009, I get this error: "An error occurred during local report processing. The value provided for the report parameter 'End' is not valid for its type." If I select two dates which can be read into mm/dd/yyyy the report runs fine and dates are displayed in the UK date format so 06/07/2009 is 6 July not 7 June.
Some more information:
1. In the code for the .rdl file I've changed en-US to en-GB which is my usual practice
2. In the report designer, the parameters for the start and end date are non-queried, default values entered in text box as 01 Jan 1980 for start date and 31 Dec 2049 for end date
3. In the report designer, the t-SQL executed by the report is EXEC MyStoredProc @Start, @End and in the stored procedure I've set the date format to dd/mm/yy (btw the stored procedure runs fine in SQL Server).
4. The server OS for the installation of SSRS2005 has UK language and regional settings
Thanks in advance for any help.