disable split record on sub reports

[Cristiano d.]

Dear listers,
I have one subreport and one page: I'd not to see my subreport records splitted across the pagebreak.

Is it possibile in Access2007?

Thanks in advance

C.

Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Parallel Processing with Correlation
http://www.eggheadcafe.com/tutorial...alk-parallel-processing-with-correlation.aspx

 

[John Spencer]

One way to handle this is to put the sub-report in its own section (group by
primary key in the detail) and put the sub-report in group footer.

Set the group footer's Keep Together property to Yes. The report tool will
then do its best to keep everything for the sub-report on the same page.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Debbie Buchanan]

Saw this answer to another user's question. I have a similar issue. I have a report with 3 sub-reports - all in detail section. Would like to use Group By for each sub-report so I can control page breaks depending on number of records...but how do I use Group By function for a sub-report? When using the Group & Sort tool I'm only allowed to select bound fields...not any of the sub-reports.

Thanks!

 

[John Spencer]

Just Group by the last field you sorted or grouped by again and again and yet
again. Or Group by a constant expression

Then add a group header or footer and put your sub-reports in the individual
group section.

The sorting and grouping dialog might look like
Field/Expression
[PatientLastName] Asc
=1 Ascending
=1 Ascending
=1 Ascending

Make sure you set Group footer to Yes for each of those last 3
Also set Keep Together to yes



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County