Friday, February 3, 2012

SSRS-Putting Date Range in Footer Area

Add a text box, placeholder in the footer area. Double click on ''. Put the below code in the expression. 'MonthFromDate' and 'MonthToDate' are variables which are accepting values entered by the user. 

=FormatDateTime(Parameters!MonthFromDate.Value, DateFormat.longdate) " - " FormatDateTime(DateAdd("d", -1, Parameters!MonthToDate.Value), DateFormat.LongDate)