Continuous page numbers between reports

[Tom Kennedy]

I have a time and billing application where the invoice is made up of several reports (an invoice, time exhibit, cost exhibit, etc.). I would like to number the pages consecutively from one page to another even though the pages are not from the same layout but from the several layouts that make up the invoice.

[Raybaudi]

Can each layout contain more than one page ?

IOW: Do a single invoice have the same number of pages as the number of the layouts ?

[Tom Kennedy]

Typically an invoice contains one cover letter page, a time exhibit that contains several pages, a cost exhibit that can contain one or more pages and a time allocation exhibit that is typically only one page. Hope this helps.

[Raybaudi]

Do you have four tables ( cover letter, time exhibit, cost exhibit, time allocation exhibit ), all related to the invoice table by its ID ?

[Tom Kennedy]

Yes.

[Raybaudi]

So you'll need to count all those pages in the script that do the print of the invoice in a way like this:

( you are in the Invoice Table )

Go to related record [ Show only related records ; from table "cover letter " ; with layout " cover letter" ]

[color:red]Go to record [ Last ]

Enter Preview Mode

[color:green]Go to record [ Last ]

Set Variable [ $pages; Value: $pages + Get( PageNumber ) ]

Enter Browse Mode

Go to related record [ Show only related records ; from table "time exhibit" ; with layout "time exhibit"]

[color:red]Go to record [ Last ]

Enter Preview Mode

[color:green]Go to record [ Last ]

Set Variable [ $pages; Value: $pages + Get( PageNumber ) ]

Enter Browse Mode

... and so on with those other layouts.

At the end $pages will contain the total number of pages that you have to print.

You 'll put that $variable into a global field

Edited September 8, 2008 by Guest
wrog order of the steps

[comment]

It needs to be:

...

Enter Preview Mode

Go to Record/Request/Page [ Last ]

Set Variable [ $pages; Value: $pages + Get( PageNumber ) ]

...

You can also set the global field directly, without going through the variable.

Edited September 8, 2008 by Guest

[Raybaudi]

yes, that is the right way to count the pages.

[Tom Kennedy]

Thanks to both of you for your help.