How to create dynamic page sets based upon user's prompt selections?

[psrpsrpsr]

I have a reporting requirement to display page sets of a crosstab report based upon prompt selections. So for example, the user selects 2 Regions - those should be output. If they select 2 Regions and 10 States - those should all be output. What are the best practice to do this, and how can it be achieved? (I am still new to page sets)

| Region |   | State    |   | Time Zone |
|--------|---|----------|---|-----------|
| North  |   | Alabama  |   | East      |
| South  |   | Arkansas |   | North     |
| East   |   | ...      |   | South     |

Thanks

[Stepharia]

You can do this by doing the following:
Create a data item that uses a prompt token expression

Code Select Expand

#prompt('pBreak','token')#
On the prompt page create a value prompt for this pBreak parameter and set it up to use static values.
The use values for your static values should be the names of the data items they can select to break by including the square brackets e.g. [Region], [State], etc.
On your report page add the new pagebreak data item as a property to the relevant crosstab.
Go to Report Pages and drag in a Page Set, set the query for the page set to your main query where the pagebreak data item is and add that data item as a property then go into the Grouping & Sorting on the Page Set and add the data item to the Groups section.
Finally drag your existing page into the detail pages under the group you've created.
Hopefully this works for you, if you have trouble with the results check what your data item is returning, it should returning the same information as the item selected i.e. if you selected [Region] it should give you the data from Region not just text saying '[Region]'.