Reporting Services SQL Server Reporting Services Calendar Control for Date Parameter (SSAS OLAP)
| SQL Server Reporting Services Calendar Control for Date Parameter (SSAS OLAP) |
| 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: Read more... |
Tags: article, ssrs
This article, and also article in following link:
http://www.ssas-info.com/analysis-services-articles/54-reporting-services/1527-using-date-parameters-in-reporting-services-reports-built-against-data-cubes
provides step by step instructions how to use SSRS calendar control with SSAS. It works, just follow instructions precisely...
Please help me out
Thanks in Advance
I got output.
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:
http://www.ssas-info.com/analysis-services-articles/54-reporting-services/1527-using-date-parameters-in-reporting-services-reports-built-against-data-cubes