Maggie,
I'm not clear on which piece is giving you trouble. Are you having trouble with the query itself, or with passing the values from the main report to the drill report(s)?
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices