Print more than one report?

[Rolf Rosenquist]

It is normal to print a report with for instance several groups. But is it
possible to print reports with one page per group? I have been trying to
make one report for each customer. That is, every week should all the
customers orders be printed, but instead of normal grouping in one single
report, I want one report for each customer.

Any suggestions how to achieve that?
/ Rolf

 

[fredg]

It is normal to print a report with for instance several groups. But is it
possible to print reports with one page per group? I have been trying to
make one report for each customer. That is, every week should all the
customers orders be printed, but instead of normal grouping in one single
report, I want one report for each customer.

Any suggestions how to achieve that?
/ Rolf

Group the report by customer in the report's Sorting and Grouping
dialog:
View + Sorting and Grouping

Then set the Group Header Force New Page property to Yes.

Be aware that any data, information in the Report Header will only
appear with the first Group, so place that information in the Page or
Group Header if you need it to show for each customer.

 

[fredg]

Group the report by customer in the report's Sorting and Grouping
dialog:
View + Sorting and Grouping

Then set the Group Header Force New Page property to Yes.

Be aware that any data, information in the Report Header will only
appear with the first Group, so place that information in the Page or
Group Header if you need it to show for each customer.

Ooops, I clicked too soon.
This line:
Then set the Group Header Force New Page property to Yes.

should have read:
Then set the Group Header Force New Page property to Before Section.

 

[Rolf Rosenquist]

Can´t find what you suggest. In the top of sorting and grouping there are
Field/expression and sorting.

Below that are 5 lines for (and now I do my own translation from Swedish to
English) Group header, Group footer, New group for, Group interval and Hold
together. In neither of those 5 there is anything about New page.

Have I missed your point? I am using Access 2000.
/ Rolf

 

[fredg]

Can´t find what you suggest. In the top of sorting and grouping there are
Field/expression and sorting.

Below that are 5 lines for (and now I do my own translation from Swedish to
English) Group header, Group footer, New group for, Group interval and Hold
together. In neither of those 5 there is anything about New page.

Have I missed your point? I am using Access 2000.
/ Rolf

After you create the Customer Group Header by clicking Yes in the
Group Header box, close the Sorting and Grouping dialog.
Then, in Design View, add the Customer Name control to the Header, as
well as any other controls needed.

Next, click anywhere in the Group Header (or on the Group Header bar)
to display the Group Header properties box. Click on the Format tab.
Set the Force New Page property to Before Section.

 

[Rolf Rosenquist]

OK, now I understand.
I am happy to see that it works exactly as I want!
Many thanks for your help.

Regards
/ Rolf