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
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices