report design question

rbuser

I have questions on how to design a customer / invoice report in MS SQL7.
I have a master customer table and detail invoice table. I need a report
displaying each customer (full address, phone # ....) on its own page and
then starting on the next page, listing all the invoices. Should the
subreport be a child or section report ? I would also like to have 2 copies
of the invoice listing printed with 2 different heading on each one. Can I
set the # of copies of the subreport only? and where do I change the heading
(pplabel) if I can set the # of copies?

Thank you

rbuser

I'm not sure but, guessing a little:
1. The invoice should be a subreport of the customer report.
2. Check the PrintBehavior property of the subreport. There's a pbSection type
that seems to do what you want.

For the second question: You can change the number of copies of the subreport to
two and use a variable to see wich copy are you printing. Check the properties
of the report to do that.

As i said, i'm guessing, hope it helps instead of creating errors to you

rbuser

Where do I change pagenumber variable and where should I check the
pagenumber variable?

Thanks

rbuser

Check TppReport's PageNo and AbsolutePageNo and AbsolutePageCount properties in
the Online help.