fixed details height in report (invoice)

[bartdc]

Hi,

First of all: Happy New Year!

I'm having a problem. I'm writing an invoice program that works well, but the report for the invoice is the trouble part.. For the layout of the invoice I want a header, the detail part which should consist of a table with a fixed height and the footer.

I want to create a table with borders that shows the invoice lines and on the bottom part the totals, if needed on more than one page. When I draw vertical lines in the detail part of the subreport they only show up for each invoice line, causing a gasp with the bottom part of the table. I found a way to fix this problem, but it only works for the first page of the invoice...

Sketch of what it should look like:

+-----------+----------+------+
|article | quantity | price|
+-----------+----------+------+
|article 1 | 1| 10|
|article 2 | 1| 15|
| | | |
| | | |
+-----------+----------+------+
| Total | $123 |
+----------+------+


Sketch of what it now looks like:

+-----------+----------+------+
|article | quantity | price|
+-----------+----------+------+
|article 1 | 1| 10|
|article 2 | 1| 15|


+-----------+----------+------+
| Total | $123 |
+----------+------+

Please note that invoices can be longer than 1 page, so just drawing longer lines or setting the "can grow" to "no" won't help here.

Can someone please give me a hint how to do this best or direct me to an example?

Thanks a lot,
Bart

 

[dhookom]

Have you considered moving the details to a fixed height subreport? You might set the background of the subreport to transparent and place the lines on the main report, behind the subreport.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[bartdc]

Thanks Duane,

Yes I did try that. The result was that the lines didn't continue on the 2nd page or if I made them long enough (max 55cm) there would be 4 empty pages..

Thank you for your help,
Bart

 

[dhookom]

You could try draw the lines in the main report with the Line method in the On Page event. This would create the lines on every page of the main report.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[bartdc]

I hoped that there would be a better method, but this will do fine

Thanks for your kind help Duane.
Bart