Report with related fields

[falkaholic]

I'm doing a invoice print layout. Where i have a header with the customer info etc. Then th body which is related lineitems for the invoice. Followed by a footer with the totals etc.

But it seems that the body shows all the lineitems from all invoices. Is there somthing I can change to make it only show certain ones?

Before this way I used a portal but it could go for more then one page so i need they ability to print muiti-page.

[danjacoby]

One idea:

In the related file (the one with all the line items), create a leading sub-summary when sorted by the key field (the field used to determine the relationship). Then script to sort on the key field and print the results.

Additionally, you might want to have the sub-summary part break before each occurence -- that way, each invoice will be on its own page(s).

You might also want to have the file perform a find to locate just those invoices you want to print, then sort, etc.

HTH,

Dan

[falkaholic]

ok. it monday.

i should have thought of using a find.

thanks