05/07/2009
Using Calendar Control for Date Filters in Analysis Services Reports
Posted by
Henry Ji
The Time Dimension filters by default appear as dropdown list boxes when designing Analysis Services reports within Visual Studio. However, users will expect Calendar controls for date filters in the reports. Here is the solution for using calendar control for date report filters.
- Under the Layout tab in Report Designer, go to Report Parameters and change the Data Type of the date filters to DateTime and changed Available values to Non-queried.
- Under the Data tab in Report Designer, go to Parameters of Dataset and change the Value text of the date parameters to use expressions like
="[Time].[Date].&[" + Format(CDate(Parameters!FromTimeDate.Value, "yyyy-MM-ddT00:00:00") + "]"
- When previewing the report, you will find Calendar controls appearing for Date filters and working fine now.
« Back to Blog Main Page
|