Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Converting Dates/Report Parameter

Author  Topic  tomann Starting Member 1 Post Posted - 2009-08-24 : 05:01:16 I have a problem in a date report parameter. The report uses an parameter to select the date. The parameter is shown as dd,mm,yyyy but returns a value MM,dd,yyyy to the parameter. Therefore, the report returns an error when I select a date from the parameter calendar. This is the error: An error occurred during local report processing. The value provided for the report parameter 'Parameter1' is not valid for its type. The only way I can get the report to work is to manually enter the date format in MM/dd/yyyy. Is there any way to fix this issue? Can I change the format of the date when it is selected in the parameter?