Hello!
I need help on figuring out how to create multiple reports by entering a single report parameter?
I have to create a single report for each one of our departments (100 departments). Each report provides the same information, but it is unique to the department. The only parameter is [Date]. How can I enter just the date and have Reporting Services create 100 unique reports based on department name. (These reports will then be distributed to the appropriate department folder for viewing) Somehow Reporting Services needs to use the entered date, lookup the first department, generate the report and then repeat the process 100 times!