Default parameter value

Question

Can a report have a default parameter value without prompting for data? Such as making a report that automatically only pulls data from yesterday? From the last 7 work days, etc?

Answer 1

Use calculations based on CurrentDate. To get yesterday's date, use CurrentDate - 1, or if you only want records from the last week, filer out any records dated before CurrentDate - 7

This can either be implemented as an optional parameter (which defaults to yesterday if you leave it blank) or if you never want to prompt the user for input, skip the parameter entirely and place your formula directly into the record selection formula editor.

Answer 2

You can also do what 4444 said in the Select Expert:

{date_field} = CurrentDate - 1 //For yesterdays data

{date_field} = CurrentDate - 7 //For the last weeks data