Edentity Web Systems
You solve creative. We crack code.
/Header/WhoWeAre.jpg
 

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.

  1. 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.
  2. 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") + "]"

  3. When previewing the report, you will find Calendar controls appearing for Date filters and working fine now.

« Back to Blog Main Page |

0 Comment(s)

Leave Comment

Name:
Comment:  
 
Security Check: 
 
 
Edentity Web Systems Inc.
Suite 201
40 Spadina Ave.
Toronto ON
M5V 2H8
Tel:
416.591.2500
Fax:
416.352.5270
Home | Who We Are | What We Do | Clients & Brands | Careers | Contact

Copyright © 2010 Edentity Web Systems Inc. Privacy Policy