We have a report that has a default parameter from a query. The Parameter Properties tab has the following properties:
- Parameter Name: today
- Data Type: DateTime
- Has Default: Checked
- Default Value: “Override Default” button
- Null: no
- Hide: Unchecked
- Prompt User: Checked
- Display Text: today
This report was set to render from a report snapshot and accidentally scheduled to run during a maintenance window. Since the server was not available, the report never ran.
The next day I did the following:
1. I clicked the “Override Default” button.
2. Entered yesterday’s date.
3. Checked the “Create a report snapshot when you click the Apply button on this page” option on the Execution tab.
4. After the snapshot was created, went back to the Parameters tab.
5. Cleared the default value and unchecked the Has Default box.
Now the report will not run as scheduled. The Execution tab has an error that says “Default report parameter values are missing.”
How can I get the report to use the preset default value in the RDL file again?