1.How many prompts have you got in the report
2. Then select it from list of values from advance button
3.Use cascading LOV to get desired list only (read cascading prompts )
4. Use report filters in interactive mode
Also check drill filters option in the report
.
haider 
(BOB member since 2005-07-18)