Running SSRS 2008 R2, SQL Server 2008
I've created a report with multiple tables and a single value parameter for CoID. There are 4 different queries for the 8 tables on the report, so what I did was add a filter for each table for the CoID parameter.
This works great.....however,
Now I need to run the report for multiple CoID's. I've change the CoID to allows multiple values and changed the filter on each table to {CoID_field} IN @CoID. When I run the report (the 8 tables should produce 5 pages), and select 2 CoID's, I only get one report for the last CoID.
What would be the best way to get a full report for each value in the CoID parameter? In other words, I need a 5page report for CoID#1, then 5 pages for CoID#2, etc.
Thank you
Sam
I've created a report with multiple tables and a single value parameter for CoID. There are 4 different queries for the 8 tables on the report, so what I did was add a filter for each table for the CoID parameter.
This works great.....however,
Now I need to run the report for multiple CoID's. I've change the CoID to allows multiple values and changed the filter on each table to {CoID_field} IN @CoID. When I run the report (the 8 tables should produce 5 pages), and select 2 CoID's, I only get one report for the last CoID.
What would be the best way to get a full report for each value in the CoID parameter? In other words, I need a 5page report for CoID#1, then 5 pages for CoID#2, etc.
Thank you
Sam