Grouping on a report

[LisaK]

I have a report with Group information. I want to group by the Group number.
There can be multiple group numbers and I want each group number to have it's
own page. I have the sorting and grouping set to group by GrpId. The Group
on is set to Each Value, the Keep Together is set to Whole Group. My report
is still putting more than one GrpId on a page. Any other suggestions?

Thanks.

 

[John Spencer]

add a group footer for the Grpid
Close the Sorting and grouping dialog.
In design view Set New Page to After Group for the group footer.

Or in the group header set New Page to Before Group


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Klatuu]

Select the Group Header bar in design mode. Set the Force New Page property
as needed.

 

[LisaK]

Thanks this worked.

add a group footer for the Grpid
Close the Sorting and grouping dialog.
In design view Set New Page to After Group for the group footer.

Or in the group header set New Page to Before Group


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..