Specific size report

[CosmaL]

Hello friends!

I've got the following problem and your help is valuable!!!

I've got an invoice form (with subform) which generates a report (printable invoice).

Report fields and design:
Reports header: Comany and invoice info
Detail header: subreport with purchased products, totals.
Report footer: order manager, order responsible info

The problem is that even i've got 1 product or 10 products in subform (report's detail section), report changes size according to the records, taking sometimes a half A4 size, sometimes an 1/4 A4 size, or a whole A4.

How can i "lock" the size in a specific size format? ex for 20 products and then report totals and etc? I'd like to have the report always printed in A4 size, having totals and order responsible info in the bottom of the page.

Thank you in advance!

Costas

 

[Isskint]

One way to do it is to use VBA in the format event of the report in conjunction with a counter.

have a look at this post on this forum http://www.access-programmers.co.uk/forums/showthread.php?t=221102

 

[CosmaL]

Thanks!

I've solved it by making a reference at the subreports totals on main report footer.

it's working!