Sort report by country

  • Thread starter Thread starter Pic
  • Start date Start date
P

Pic

I have a flat database that simply keeps track of contact information.
From it I print out an address book, sorted first by country then by
last name.

Is it possible to arrange the report so that each country starts on a
new page? Further, can those sections have the name of the country in
a header?

Thanks in advance,
Pic
 
I have a flat database that simply keeps track of contact information.
From it I print out an address book, sorted first by country then by
last name.

Is it possible to arrange the report so that each country starts on a
new page? Further, can those sections have the name of the country in
a header?

Thanks in advance,
Pic
Click to expand...

In Report Design View, Click on View + Sorting and Grouping.

In the Field/Expression column enter the [Country] field.
In the lower panel, select Group Header Yes.

Then add the [LastName] field in the Field/Expression column (under
the Country).
Set both fields to Sort Ascending

Save the changes.
In Design view, add the [Country] control to the Country Group Header.
Then display the group header property sheet.
Click on the Format tab.
Set the ForceNewPage property to
Before Section

Save the changes. Run the report.
Each country name should be shown in the Group Header.
Each new country will start a new page.
 
Make a report based on the table. Then select View->Sorting and Grouping (
or choose it via right clicking on the report ). Add country as a sort
option and choose to include a group header. Click OK.

On your form you should now have a header for country. Right click on it
and select properties, look for the "force new page" option and make it yes.

Finally, drag your country field from your field list into the group header
section... and the rest of your desired fields into the report detail section.
 
Back
Top