D
Dennis
All,
I am running Access via Office XP Pro on Windows 7.
Background:
I am working on an invoice "form" report. (By form I mean the actual form
that I will hand the customer versus an data entry form.) I have it pretty
much working thanks to different members on this form, but I have another
question.
For this report Work Order number is also used as the invoice number.
The report is comprised of the following parts:
Main report: row source is qrytblWorkOrder table (Invoice rcd)
WorkOrder Header - Grouped by Work Order / Inv No #
Detail
Page Footer
Sub-report – row source is qrytblWorkOrderDet table (transactions)
WorkOrder Header - Heading for detail line via Repeat Section = Yes
Grouped by Work Order / Inv No #
Detail
WorkOrder Footer - Invoice totals
Here are my questions.
1. After each invoice (group) on the main report prints, I want to reset
the values Page and Pages. I want the first page of each invoice to be page
1, the second page 2, etc. for each invoice. And I want to be able to print
Page x of y in the page footing of the invoice where “y†is the number of
pages for the specific invoice.
2. I want to be able to have my details print across the pages. I was
testing my report and I move my sub-report down a couple of lines. Before I
did that, all of my details printed on the first page. After I moved down
the sub-report in design mode, all of the details printed on the second page
and none printed on the first page. The first page was 3/4 empty.
I have set the Keep Together property of the Sub-report, WorkOrder Header
and Detail section of the sub-report to No. But that did not change anything.
Any suggestions?
Thanks,
Dennis
I am running Access via Office XP Pro on Windows 7.
Background:
I am working on an invoice "form" report. (By form I mean the actual form
that I will hand the customer versus an data entry form.) I have it pretty
much working thanks to different members on this form, but I have another
question.
For this report Work Order number is also used as the invoice number.
The report is comprised of the following parts:
Main report: row source is qrytblWorkOrder table (Invoice rcd)
WorkOrder Header - Grouped by Work Order / Inv No #
Detail
Page Footer
Sub-report – row source is qrytblWorkOrderDet table (transactions)
WorkOrder Header - Heading for detail line via Repeat Section = Yes
Grouped by Work Order / Inv No #
Detail
WorkOrder Footer - Invoice totals
Here are my questions.
1. After each invoice (group) on the main report prints, I want to reset
the values Page and Pages. I want the first page of each invoice to be page
1, the second page 2, etc. for each invoice. And I want to be able to print
Page x of y in the page footing of the invoice where “y†is the number of
pages for the specific invoice.
2. I want to be able to have my details print across the pages. I was
testing my report and I move my sub-report down a couple of lines. Before I
did that, all of my details printed on the first page. After I moved down
the sub-report in design mode, all of the details printed on the second page
and none printed on the first page. The first page was 3/4 empty.
I have set the Keep Together property of the Sub-report, WorkOrder Header
and Detail section of the sub-report to No. But that did not change anything.
Any suggestions?
Thanks,
Dennis