Adding Default Date to Reports Parameters in SSRS Reports

Adding Default Date to Reports Parameters in SSRS Reports

Many times while creating Reports you have to set a default value for your Datetime Parameter like for eg
 Startdate will be one year or one month or one day back and FinishDate like Current Data these Parameters will filter your Report Data between thsese Dates

 Suppose you want to show customer details of 1 year by default In these type of scenarios we have to set the Parameter Default Values.
Below is the Procedure how to add default Date to Report ParameterIn our Case we will add Start Date as 1 year back DateFinishDate as Current DateOpen Design

 View of Your ReportSelect Parameter

 -Add new ParamterName it to StartDate DataType

-DateTimeNow go to Default value

 -Specify Value-Addclick on Fx button and Right Expression

=Dateadd("M",-12,Now())
or
 =Today().AddYears(-12)

click ok

Next for FinishDate Parameter

Select Parameter

 -Add new ParamterName it to StartDate DataType

-DateTimeNow go to Default value

 -Specify Value

-Addclick on Fx button and Right Expression

=Now()
or
=Today()

click ok
Preview your Report Two Parameters will be thereStartDate-1 year back Date from Current DateFinishDate-CurrentDateNow you can filter your Report Based on these Parameters.


Note:In our Example we have taken Start Date as 1 year back Date from Current Date

 if you want to show one month back from Current date then alter your expression

 =Dateadd("M",-1,Now())

if you want to show one Day back from Current date then alter your expression

=Dateadd("d",-1,Now())