I am new to crystal reports and I am trying to build a report. I have several tables that are linked together by a foreign key. My table hierarchy looks like this:

Company
JobNumber
Platform
Level
Area
Item

I have groups in my report for each one above. The item contains the detail. I need the report to drill down to the item, but how do I get crystal to select all the areas for each level. Each level can have multiple area's. When I supply the parameter for that stored procedure I only can supply one parameter when I need to show all the areas. Any help is appreciated

Thanks