How would I modify the report?
Hello Jordan,
You can use the Report Builder from SSRS to modify the report: Getting Started with Report Builder
Please follow the below links
Custom Reports for List of Applications , Deployment Types and Content Source
Hi Jordan,
According to your description, you want to use report parameter to dynamically control the dataset. Right?
In Reporting Services, we can either add the parameter in where clause like: where column in (@parameter). Or you can concatenate query string and parameter value into an entire query. Please refer to links below:
Walkthrough: Control Dataset Query Dynamically based on SSRS Report Parameters
MS Reporting Services Dynamic SQL
Regards,