SQL Server Reporting Services Calendar Control for Date Parameter (SSAS OLAP)
User Rating: / 18
Written by Chen Tian Yang   
Friday, 20 February 2009 03:47

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:

Comments (8)
8 Wednesday, 20 October 2010 09:56
I am beginner in SSRS..knowing very little about it...however this articl;e helped me to get what I was looking for.
7 Friday, 19 March 2010 11:39
I got the output but the date format of the calender control is mm-dd-yyyy and i need the format dd-mm-yyyy
6 Thursday, 12 November 2009 16:50
I am using SQL Query in SSRS instead of an MDX. How would I be able to ensure that the Date value I picked using the Calendar control is formatted correctly in to my SSRS.
5 Wednesday, 20 May 2009 00:15
Vidas M.

This article, and also article in following link:

provides step by step instructions how to use SSRS calendar control with SSAS. It works, just follow instructions precisely...
4 Tuesday, 19 May 2009 11:27
when we create Report using Analysis Services,then how can we use calendar control in report,as no such control is given in that,,

Please help me out

Thanks in Advance
3 Monday, 11 May 2009 05:33
Thank u for post this one.
I got output.
2 Friday, 08 May 2009 11:48
Vidas M.

I tried same approach before and can confirm that this works. Just you have to make sure you enter correct MDX that build unique date member. Here is another similar description how to do that:

1 Friday, 08 May 2009 09:38
I tried but unfortunately it did not work!

Tags: article, ssrs

XL Cubed