When you add or edit the query, select the Set save options tab.
Select Create a selection.
Select whether to create a dynamic or static selection.
To create a selection that automatically refreshes each time you use it, select Create a dynamic selection. When you use a dynamic selection in a function, the program searches the database for any new records that meet the criteria of the selection and adds them to the results. For example, if a record does not meet the selection criteria when you first create it because of a data entry error, the selection includes the record the next time you use it if the error is corrected.
To create a fixed set of IDs that does not change, select Create a static selection. For example, if a record that originally met the criteria of the query on which the selection is based changes so that it does not currently meet the criteria, the record ID is still included in the selection each time you use it. The selection contains the same records until you refresh it manually or with an automated process.
To use the selection outside of the program in the Microsoft SQL Server Reporting Services Query Designer, select Show this selection in the Query Designer. If you select this checkbox, the selection appears in the Selections folder of the Field Explorer in Query Designer.
Click Save. The results page appears.