Report Portal

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

 

2007-2015 VidasSoft Systems Inc.