1. In the Report Data pane, highlight Parameters
  2. Switch to Design View in Report Builder
  3. Right-click and select Add a parameter
  4. The Report Parameter Properties dialog box opens.
  5. Select Allow multiple values
  6. Enter a name, a Prompt, and a Data Type
  7. Click Available Values
  8. Select Get values from a query
  9. In Dataset, from the drop-down list, select a dataset
  10. In Value field, from the drop-down list, select a value
  11. In Label field, from the drop-down list, select a label
  12. Click Default Values
  13. Select Get values from a query
  14. In Dataset, from the drop-down list, select a dataset
  15. In Value field, from the drop-down list, select a value
  16. In Label field, from the drop-down list, select a label
  17. Click ok
  18. Select Run on the Home Tab to run the Report
  19. Your parameter will appear as a dropdown at the top of the report
  20. Select an option from the dropdown
  21. Select View report