CODEWITHSUNDEEP
ms-accessreporting
Desert Spider
Desert Spider

Reputation: 778

MS-Access 2003 Report Page Grouping

I have a report that I am having trouble grouping for my output.

"Sorting and Grouping" parameters are set to "Name" and "Ascending"

Group Header :Yes
Group Footer :No
Group On :Each Value
Group Interval :1
Keep together :No

Report Set Up

Page Header
Images, Label, Date
Detail
TextBox: Name
TextBox: UserID
Four SubReports Linked to the Name TextBox
Page Footer: Pg Nbr

I want to group by Name per page. What am I doing wrong?

Upvotes: 0

Views: 1086

Answers (2)

bonCodigo
bonCodigo

Reputation: 14361

Don't you want to GROUP BY :NAME and SORT :ASCENDING ? Assuming you have data returned by your query to populate the report.

According to this Access 2003 MSDN article,

To specify how a group prints on a page,

You can control how the elements of a group are printed in a report by using the KeepTogether property in the Sorting And Grouping window. A group consists of a group header, nested groups (if any), detail records, and a group footer.

  • Open the report in Design view.

  • Click Sorting And Grouping Button image on the toolbar, or on the View menu, click Sorting and Grouping to display the Sorting And Grouping window.

  • In the Sorting And Grouping window, click the field or expression for the group level that you want to keep together.

Set the Keep Together property:

  • Select No to print without regard for where page breaks occur when a group is printed across more than one page.

  • Select Whole Group to print an entire group on the same page.

  • Select With First Detail to print at least the group header through its first detail record on the same page.

  • On the Edit menu, click Select Report. On the View menu, click Properties. Set the GrpKeepTogether property to Per Page.

    Note When you set the Keep Together property to Whole Group or With First Detail, the size of the group (or the portion of a group that includes the group header through the first detail record) determines how Access prints the report. If either the whole group or the header through the first detail record is too large to fit on the page currently being printed, Access advances to a new page and then begins printing the report.

So it could be that you need to change Keep together property.

Upvotes: 0

Fionnuala
Fionnuala

Reputation: 91306

Add a footer to the Group and ..

 Force New Page: After Section

Upvotes: 1

Related Questions