I have about 50 reports that were originally created to be run 'ad hoc' by a user; with one date parameter.Typically the user would put in the current date, and execute the report. Now I'm trying toi schedue the same reports to create snapshots daily. I would like to pass the current date that it executes as the parameter; but I haven't been able to figure out how to do this. Is there way to do this without going in and modifying all of my reports? thanks

Hi, Did you try default value for parameter? Thanks, Albert Ye

Hi alk1234, As Albert suggested, I’m afraid you need to modify all these reports and specify default value to the date parameter. For example, in order to pass the current date to the parameter by default, please specify the default value to the expression =Now(). After deployed the report to Report Server, a checkbox Has Default will be displayed after report parameter in the Properties\Parameters page. If you accept it, the scheduled snapshot will execute by using the default value which you specified. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.