Looping through a report with subreports.

[less1die]

I have a report with three sub-reports inside of it. Currently when it opens, it asks for a US State, then based on what State the user types in, it runs the report ans sub-reports for that state. What I want to do is somehow, with one click, generate the reports for all 50 states at once. Eliminating the need for the user to have to type in one at a time. Any help would be appreciated.

[Bob Fitz]

Can you show us the SQL of the query on which the main report is based.