Report Page Seperation

[David]

The source of my report has a lot of fields, but these 2 are the most
important. [invoicenumber] [ticketnumber] There are multiple tickets per
invoice number, so the invoice number remains the same for as many rows in
each invoice. When I try to generate the report it fills the report with as
many tickets as it can without paying any attention to the invoice number.
I want the report to display all the tickets for each distinct invoicenumber
and then move to the new page for the next invoice number and display all
the tickets for that invoice. I hope I explained it well. Any ideas on how
to set the report to go to a new page with each new invoice number?

Thanks,

Dave

 

[fredg]

The source of my report has a lot of fields, but these 2 are the most
important. [invoicenumber] [ticketnumber] There are multiple tickets per
invoice number, so the invoice number remains the same for as many rows in
each invoice. When I try to generate the report it fills the report with as
many tickets as it can without paying any attention to the invoice number.
I want the report to display all the tickets for each distinct invoicenumber
and then move to the new page for the next invoice number and display all
the tickets for that invoice. I hope I explained it well. Any ideas on how
to set the report to go to a new page with each new invoice number?

Thanks,

Dave

Group the report by InvoiceNumber.

Here's how.
In Report Design View, click on View + Sorting and Grouping

On the Field/Expression line write:
InvoiceNumber

In the lower panel select Yes for Group Header.
Save the changes.

Then set the InvoiceNumber Group Header ForceNewPage property to
BeforeGroup


Place the [InvoiceNumber] control in the Group Header.

Place the [TicketNumber] control in the Detail Section.

Run the report.

 

[David]

Great that did the trick!

Do you know how to reset the page count for each new invoice number?

I would like it to say page 1 of 1 for each invoice or page 2 of 2...

Thanks!

The source of my report has a lot of fields, but these 2 are the most
important. [invoicenumber] [ticketnumber] There are multiple tickets per
invoice number, so the invoice number remains the same for as many rows
in
each invoice. When I try to generate the report it fills the report with
as
many tickets as it can without paying any attention to the invoice
number.
I want the report to display all the tickets for each distinct
invoicenumber
and then move to the new page for the next invoice number and display all
the tickets for that invoice. I hope I explained it well. Any ideas on
how
to set the report to go to a new page with each new invoice number?

Thanks,

Dave

Group the report by InvoiceNumber.

Here's how.
In Report Design View, click on View + Sorting and Grouping

On the Field/Expression line write:
InvoiceNumber

In the lower panel select Yes for Group Header.
Save the changes.

Then set the InvoiceNumber Group Header ForceNewPage property to
BeforeGroup


Place the [InvoiceNumber] control in the Group Header.

Place the [TicketNumber] control in the Detail Section.

Run the report.

 

[fredg]

Great that did the trick!

Do you know how to reset the page count for each new invoice number?

I would like it to say page 1 of 1 for each invoice or page 2 of 2...

Thanks!

The source of my report has a lot of fields, but these 2 are the most
important. [invoicenumber] [ticketnumber] There are multiple tickets per
invoice number, so the invoice number remains the same for as many rows
in
each invoice. When I try to generate the report it fills the report with
as
many tickets as it can without paying any attention to the invoice
number.
I want the report to display all the tickets for each distinct
invoicenumber
and then move to the new page for the next invoice number and display all
the tickets for that invoice. I hope I explained it well. Any ideas on
how
to set the report to go to a new page with each new invoice number?

Thanks,

Dave

Group the report by InvoiceNumber.

Here's how.
In Report Design View, click on View + Sorting and Grouping

On the Field/Expression line write:
InvoiceNumber

In the lower panel select Yes for Group Header.
Save the changes.

Then set the InvoiceNumber Group Header ForceNewPage property to
BeforeGroup


Place the [InvoiceNumber] control in the Group Header.

Place the [TicketNumber] control in the Detail Section.

Run the report.

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages]
= [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the VBA code, change Me!Salesman to
Me![InvoiceNumber]

 

[David]

Thanks Fred! It worked! I have to admit that it was a bit more complicated
then I originally anticipated. lol Thanks for helping me with this one. I
placed the page n of n in the form header instead of the footer. I just had
to move the code to the header and it works great.

Thanks!!

Dave

Great that did the trick!

Do you know how to reset the page count for each new invoice number?

I would like it to say page 1 of 1 for each invoice or page 2 of 2...

Thanks!

On Wed, 29 Nov 2006 11:55:31 -0500, David wrote:

The source of my report has a lot of fields, but these 2 are the most
important. [invoicenumber] [ticketnumber] There are multiple tickets
per
invoice number, so the invoice number remains the same for as many rows
in
each invoice. When I try to generate the report it fills the report
with
as
many tickets as it can without paying any attention to the invoice
number.
I want the report to display all the tickets for each distinct
invoicenumber
and then move to the new page for the next invoice number and display
all
the tickets for that invoice. I hope I explained it well. Any ideas
on
how
to set the report to go to a new page with each new invoice number?

Thanks,

Dave

Group the report by InvoiceNumber.

Here's how.
In Report Design View, click on View + Sorting and Grouping

On the Field/Expression line write:
InvoiceNumber

In the lower panel select Yes for Group Header.
Save the changes.

Then set the InvoiceNumber Group Header ForceNewPage property to
BeforeGroup


Place the [InvoiceNumber] control in the Group Header.

Place the [TicketNumber] control in the Detail Section.

Run the report.

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages]
= [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the VBA code, change Me!Salesman to
Me![InvoiceNumber]