Monday, September 17, 2012

Set Current Month,Year as a Default Parameter in SSRS

Introduction

                  Set Default value to Parameter  @Year=Year(Now())
                  Set Default value to Parameter @Month=Month(Today)(This gives you integer value of Month 1 to 12) or  =MonthName(Month(Now)) (This gives you the string value like January,February,March etc.)


Please Note that you have to add value in Parameter.                

0 comments:

Post a Comment