Forcing data to a new page

[EricVonSkip]

I have a stored proc that is pulling all the data I need.

What I am trying to accomplish is the correct layout.

I need to group by client and have totals for each client.

I have multiple clients that I want to show on each page with similiar data. Then go to a new page and show the next set of similiar data.

Group Header1 ClientA
Details1 ClientA
Group Footer1 ClientA

Group Header1 ClientB
Details1 ClientB
Group Footer1 ClientB

------NEW PAGE---------

Group Header2 ClientA
Details2 ClientA
Group Footer2 ClientA

Group Header2 ClientB
Details2 ClientB
Group Footer2 ClientB

I really need to do this with out subreports bcse of the time each subreport takes to run....or is there a way to force the subreports run in parallel.

 

[Ngolem]

So what is your criteria for the different data

just set up your report like this

Group 1 header {Table.New page criteria}
Group 2 header {Table.client}
Details
Group 2 footer
Group 1 footer (enable the "New Page After" in section Expert

that should do it

Jim Broadbent