Keeping together records from a subreport - I don't understand!

[Guest]

I've been trying to work this out for a long time and learn things from the
questions already posted but I'm not having any luck.

I have a number of subreports that get split up onto different pages when
they have a number of records in them.
I want to "group" them together so the records for each subform stay on the
same page.

It seems a number of people have had this problem, and I found the following
response:

"Place each subreport in its own section. The trick is to
use Sorting and Grouping to create groups with header and
footer sections. If the subreport's were in the detail
section, then use the record source primary key as the
grouping field. If they were in the report or some group
header or footer section, then group on any constant
expression such as ="Dummy" or =1."


I knwo very little about sorting and grouping and really need a dummies
guide of how to implement this... how do I create groups? My subreports are
in my detail section

Please help... I'm getting desperate!!

 

[Duane Hookom]

You create groups by opening the Sorting and Grouping dialog. I can't think
of any reports that I have ever created that weren't sorting using this
dialog. Once it is open, you do as Marsh had suggested by adding a new
sorting and grouping level. There are Yes/No properties for displaying group
header or footer sections.

 

[Guest]

Do I do this in each subreport? or the main report?
When I open the main report's Sorting and Grouping dialogue it only comes up
with the field names from the query that the report is based on - no
reference to the subreports.

I know that this dialogue sorts records (ie mine is sorted by name of the
group) but I don't know what you mean by placing each subreport in its own
section.

Sorry to be so clueless...

 

[Duane Hookom]

Do this in the main report. There was no mention in the instructions to do
anything related to the subreport except to place the subreport in the newly
created group header or footer.

 

[Guest]

Thankyou!
It worked!
I just realised what he meant by adding new footers... and it all makes sense.
Thankyou for being patient, much appreciated.