Calendar parameter in OLAP report

Hi,

I am trying to find the best way to use a date parameter on a OLAP report and get the calendar pop to be used instead of a dropdown.

Whenever I change from string to datetime for the parameter I (of course) get an error about different data types, since OLAP is returning the fields as strings and formatted.

Any easy (or best) approach to use to get a calendar pop to work with an OLAP report? I am mainly doing this for date range searches and do not want people to pick from huge dropdowns for dates.

Thanks.

I have made a few posts explaining how to use a calendar control with MDX, here is a link to probably the most helpful (as it has examples): http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1506211&SiteID=1

Basically, you need to take the output of the calendar control, CDate() it, then use Format() to generate a string that is compatable with how you have set up your heirarchy members.