This article explains how to create a query that leverages variables. This allow to dynamically query the datasource and so reduce the time necessary to retrieve the results.
- Select a SQL data source (date parameters can be applied also to other datasource but the procedure might slightly change)
- Create the query you wish (without date parameters). You can use the drag & drop feature or write the query by your own.
- Create two variables of type date to store the start and end date
- Right click on the query you created and click on Properties than click on Edit in the Conditions section
- A window will appear allowing you to write your filter condition in some clicks. For filtering rows between the start and end date you could write some like that
- Select the database column that you want to use in the comparison.
- Select the comparison method
- Choose the right variable
In order to select the variables, click on the icon on the right and select the Variable option
Your table should now able to retrieve only the data of the data range you selected.