Using date parameters in Reporting Services reports built against data cubes
I've came across a newsgroup question today, that I thought that I would blog about. When you create a report in Reporting Services against a SQL AS data cube and create a parameter against a date dimension the VS Report Designer creates a string type parameter. Most of the time when you are dealing with dates it's much easier for the end user to use the calendar to select a date. This is only available if you set the parameter to a DateTime type, however this then breaks the query.
Read more...Tags: ssrs