Count required amount of pages

[Ralph Schwegler]

Hi folx

I have a file invoices with n invoice line, each being max 3 lines long.

How can I figure out how many pages I will need, and how can I manage this?

As far as I understand, printing will be from a layout of the invoice lines. But what else?

Thank you for your valued help.

[bcooney]

Your question suggests that you are not familiar with certain FM features and techniques.

Yes, invoices are best printed from their child line items table. If each line item can be 3 lines long, then you need to make that field tall enough. However, you can use FM's Slide feature to remove white space as well as reduce the size of the body part.

Check out Sliding.

[IEW]

I think I understand your problem.

I use a script to:

count no of items in portal using global $$lines

set $$page to 1

Set $$pageof to 1

If $$lines < = lines on invoice (1-5)

print invoice

if $$lines < = next page of invoice (6-10)

set $$page to 1

set $$pageof to 2

print

set $$page to 2

set page of to 2

print

etc.

The portal must be set up to change initial rows and number of rows to print for each page.

[bcooney]

IEW, are you printing multiple portals? Why? You should print from the line items table.

As for having Page 1 of 2 in a footer, all you need to do is Enter Preview, Go to Last Page, and set a global (gPages) to the Page Number. Then put Page ## or gPages in your footer.

[Ralph Schwegler]

thank you for your help

with some testing, I managed to do something similar. but...

at the end of page one/two/(all but not the final one), I want a footer stating the sum of the lines on that page.

any chance to do that?

[bcooney]

There is technique for end of page summaries (it's not straightforward). I'll see if I can find the thread. If "comment" sees this, perhaps he'll post a link to it, as I believe he's the person who created it.

End of section totals can be created using a trailing sub-summary. End of report, trailing grand summary.