- To make reports more useful, it will be necessary to allow end users to input values prior to running a report to determine which records will be displayed via parameters. To add parameters, simply right click in the Parameter area of the Report Data window and click Add Parameter
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/319-300x183.png)
- Enter the Name and Prompt of the parameter and choose the Data type
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/320-1024x935.png)
- If the parameter(s) are not included in the dataset query, they can be inserted editing the query text. Double click on the dataset.
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/321-270x300.png)
- In the display query window, modify query to add parameters. Click Query Designer.
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/322-979x1024.png)
- For date parameters, enter new statement in WHERE clause of query such as dv.EffectiveDate between @EffDateFROM and @EffDateTHRU
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/323-1024x291.png)
- Report Design tab now shows date parameters, double click on Eff Date FROM and Eff Date THRGU parameters to modify Data Type properties and change from text to Date/Time
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/324-1024x867.png)
- On Preview tab, enter parameter values and click View Report
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/327-1024x636.png)
![](https://2023.calmhsa.org/wp-content/uploads/2024/01/328-1-1024x120.png)