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
On 11/9/2010 1:44 PM, Debbie Buchanan wrote:
> 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!
>
>> On Monday, August 30, 2010 7:08 AM Cristiano d. wrote:
>
>> 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.
>
>
>>> On Monday, August 30, 2010 10:00 AM John Spencer wrote:
>
>>> 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
>>>
>>> Cristiano d. wrote:
>
>
>>> Submitted via EggHeadCafe
>>> Visual Studio Async CTP Overview
>>> http://www.eggheadcafe.com/tutorials...-overview.aspx
Similar Threads
