Tuesday, January 5, 2010

Date Picker in OLAP SSRS

1. Change the data type of the Parameter to datetime and remove all default and get query
2. Right click the dataset and change the parameter with the expression as

="[Dim Date].[Date].&["+format(Parameters!FromDimDateDate.Value,"yyyy-MM-dd") +"T00:00:00]"

you are done !!

No comments: