When you create your report, you need to add a new parameter definition (that's in the same window where you write the SQL where clause):
- Go to Parameter definition and click on new
- Enter the name (e.g. administrators) and the runtime prompt in the respective text boxes
- Make sure you pick Watchlist as your parametr type
- Click Apply Now the watchlist will be a selectable item in the Insert Param box in the SQL where clause and you can use it in your sql query (e.g. UserNAme IN (${administrators}))
When you run the report, there will be a drop down list with all the defined watchlists on the server. The one you choose will be passed as a runtime parameter.
