I have a report in SSRS that has one parameter named Employee Name that allows the viewer to filter the report by employee. The parameter is a drop down that has approx 500 employees in the list. I need to export the report for each employee in the drop down (in PDF or Excel). So, if I did this manually as an example, I'd select employee #1 from the drop down, then go to the export drop down menu and select PDF to save it as a file for employee #1 results. Then, I'd repeat this for all 500 employees.
Is there a way to automate this in SSRS? Or another way.
What you’re describing is a Data Driven Subscription. Create a subscription, pick “data driven” rather than standard, and in the dataset you’re prompted for, list all the employees. Then tell it to populate the parameter using a value from that dataset. Easy!