Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 today and yesterday as parameter values Expand / Collapse
Author
Message
Posted Friday, March 21, 2014 8:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 366, Visits: 428
In an SSRS 2008 r2 report, I want to set the default value to yesterday's date in a parameter called startdate. In a parameter called enddate, I want to set the default parameter value to todays date.

I have tried the following to set the default values:

=today()

and

=DateAdd("d".-1.today()).

The above does not work.

Thus would you let me know how to set the default parameter values of start date to yesterday's date and the enddate to today's date?
Post #1553512
Posted Friday, March 21, 2014 10:19 AM This worked for the OP Answer marked as solution
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 366, Visits: 428
found answer
Post #1553593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse