C
cyrus05 via AccessMonster.com
Hi all,
Here I am with another problem. I tried to find out solution but couldnt find
any specific answer.
I am printing an invoice and its copy (two per page vertically one after
another) on a pre ptinted A4 paper with the fixed size of the detail sections.
Detail section can not have more than 7 rows (records) and does not show
further rows (records) it any. I would like to use a conditional page break
but couldn't figure out how and on which report or sub report to put it on.
Here how the reports have hierarchy.
Main Report (A4 paper)
Main Report Header
Sub Report 1 (Actually the original invoice, customer copy)
(Report Header contains invoice number, customer code, name,
date)
Details contains Sub report_detail (contains detail of the
items in invoice)
(Report Footer contains sums of the invoice)
Main Report Footer
Sub Report 2 (Copy of the report 1, office copy)
(Report Header contains invoice number, customer code, name,
date)
Detail contains Sub report_detail (same subreport_detail
as in Sub Report 1)
(Report Footer contains sums of the invoice)
Everything is alligned perfectly on the pre-printed A4 paper and works great
unless there are more than 7 items in the invoice, only first 7 are displayed.
How can i use a page break so that the remaining items get printed on the
next page (pre-printed) and then the sums are printed, also keeping in mind
that copy of each invoice (page) is to be printed on the same page vertically
below it.
I ll appretiate any solution even if we need to modify the whole structure.
Thanks in advance.
Here I am with another problem. I tried to find out solution but couldnt find
any specific answer.
I am printing an invoice and its copy (two per page vertically one after
another) on a pre ptinted A4 paper with the fixed size of the detail sections.
Detail section can not have more than 7 rows (records) and does not show
further rows (records) it any. I would like to use a conditional page break
but couldn't figure out how and on which report or sub report to put it on.
Here how the reports have hierarchy.
Main Report (A4 paper)
Main Report Header
Sub Report 1 (Actually the original invoice, customer copy)
(Report Header contains invoice number, customer code, name,
date)
Details contains Sub report_detail (contains detail of the
items in invoice)
(Report Footer contains sums of the invoice)
Main Report Footer
Sub Report 2 (Copy of the report 1, office copy)
(Report Header contains invoice number, customer code, name,
date)
Detail contains Sub report_detail (same subreport_detail
as in Sub Report 1)
(Report Footer contains sums of the invoice)
Everything is alligned perfectly on the pre-printed A4 paper and works great
unless there are more than 7 items in the invoice, only first 7 are displayed.
How can i use a page break so that the remaining items get printed on the
next page (pre-printed) and then the sums are printed, also keeping in mind
that copy of each invoice (page) is to be printed on the same page vertically
below it.
I ll appretiate any solution even if we need to modify the whole structure.
Thanks in advance.