Thursday, January 15, 2015

Calendar Date Picker for MDX based Reports in SSRS

Generally any SSRS report contains one date parameter. User never prefers list of values for date parameter, they always want to choose the date value from the Calendar Date Picker. It is very easy to use Calendar Date Picker when we create report against any relational database, but when we create SSRS report against SQL Server Analysis Services then we can’t directly feed Calendar Date Picker value into the MDX query. 

This article will answer for these questions: 

How to feed calendar date picker value into MDX query?
How to use Calendar Date Picker parameter for MDX based reports? 
What are the advantages of Calendar date picker over list of values parameter?

Read Article here