Reporting Services Header/Body/Footer question

[joshuaguilty]

I have two reports which list the sales of salesperson and their customers.
1st report "Details report" has columns - Salesperson, Customer, Sales
2nd report "Summary report" has columns - Salesperson, Sales
Could I combine the two reports into one with a parameter like @Summary (Y/N). Therefore if 'Y' then run "Summary report" and 'N' for the "Details report". If the above is feasible then will I have to design with two sets of header/body/footer? Would the hidden header/body/footer takes space (which might be ugly even they are invisible). Thank you. (SQL 2005)

 

[Alan0568]

Looks like an ideal scenario for a drill down report. Start with the 2nd report and have the ability to click on salesperson and expand a section showing the salespersons customers if required.

http://www.mssqltips.com/tip.asp?tip=1329

 

[joshuaguilty]

Thank you for the idea.
My 1st report lists like this
Salesperson Customer Sales
111 AAA 100
111 BBB 200
222 CCC 300
222 DDD 400
My 2nd report lists like this
Salesperson Sales
111 300
222 700
The second report NOT ONLY gets rid of "Customer" but also summing up all the customers' sales under that salesperson.
Thanks.