Calling SSRS report from another report

Question

I an new to working with SSRS and creating reports.

I have created a simple 1 page report from one datasource and 6 datasets.

Report takes one parameter: EmployeeId -- and generates 1 page report for that employee.

So far all good!!

Now, I want to create another report which takes a DepartmentId. This report should generate report for all x number of employees in the department and have x number of pages.

Is there any way I can reuse the report I created earlier (the one with EmployeeId as parameter) to generate the later report I described?

Thank you :)

Answer 1

You could probably use a subreport, if the DepartmentId is available per Employee (i would assume it is) then that would probably be your best bet