Hey folks
Can anyone help with this?
I've got a report which has 8 different pages. I've set up pagesets to split the pages by relevant items e.g. the region page splits out into different region pages, site page splits out into one page per site etc.
There are a number of cascading prompts so that when a region is selected in the region prompts it shows the relevant sites in the site prompt etc.
At the momment I've got 1 page set per page so the output shows all region pages and then all site pages. What I need to do now is change that so I get a region page, then the relevant sites then the next region with it's relevant sites etc etc.
Any idea how to do that? I've tried nesting the page sets, adding master detail relationships between the page sets. The sites are now being dispalyed for every region (i.e. every site follows each region). I'm struggling to get that to change.
Can anyone save me from madness and point me in the right direction please???
As always thanks for your help.