SQL Server Reporting Services Calendar Control for Date Parameter (SSAS OLAP)

When building a report in SQL Server Reporting Services, we often use date as parameters. When you create dataset from SQL Server Analysis Services source, by default the date will be treated as string and you will have a drop down list of date. In SQL Server 2005, Reporting Services introduced “calendar control” to allow user select date from calendar (similar to calendar control in ASP.NET). To activate this feature, you simply set the parameter data type to “datetime” instead of “string”, and a nice calendar control will show when you run the report.

So is it the end of story? Definitely NO!

By doing that, a lot of report designers find the report would not be rendered according to the date you select, or most time, it throws an error. For example: