How to create multi pages invoice report

[Vensia]

Dear all,

Please help me how to create multi pages invoice report.
Thanks.

Vensia

 

[Allen Browne]

Please clarify.

Do you mean you want to print 2 copies of the same invoices, such as an
"Original" and a "Copy"?

Or do you mean an invoice with lots of items so that it runs over multiple
pages?

 

[Vensia]

I mean an invoice with lots of items.
I want the invoice footer (such as signature, invoice amount) is printed at
the fixed position and last page, so I put the invoice footer at page
footer. I put several vertical lines at Detail section. Can I make the
vertical line at detail section to be printed until below although the
invoice contains few items ?
Because the invoice footer just printed at the last page, there is a blank
space at the pages before the past page which if it's possible, I can use it
to print several items more. How to do it if it's possible ?
Thanks.

 

[Allen Browne]

Before the days of computers, the printed invoice form would have the
summary at the bottom of the page, because there was no way to know how many
items would be needed at the time the page was printed. This is no longer
the case. In fact, a good argument could be made that placing the summary
immediately after the last item helps prevent the fraudlent addition of
items being typed onto the printed invoice that are not included in the
total at the bottom. Trying to make the computerized invoice fit the
old-school look is counter-productive (i.e. wasted effort that decreases
reliability.)

If you want to do it anyway, it sounds like you have simulated it with
unbound controls in the page footer. This works, but has the side-effect of
making that space unusable on previous pages of the invoice. Another
approach is to identify the last item in the invoice, and in the Format
event of the Detail section, continue to print the space for that item until
you are far enough down the page to print the report/group footer. You can
do that by toggling the report's runtime properties (PrintSection,
MoveLayout, NextRecord) until the report's Top property is far enough down
the page. (Top is in twips, where 1440 twips = 1 inch.) This is still quite
messy if the section CanGrow.

To get vertical lines on the page, use the Line method in the Page event of
the report.

 

[Vensia]

So you mean that it's better I put the invoice summary at the report footer
section than the page footer section ?
For your information, the item description Can Grow.
My user also want there is a total summary for each page and the total
summary will be brought to the next page and placed before the first row of
item. How to do it ?
Why the line width made by Line control and Line method can't be same ?
Thanks.

 

[Allen Browne]

To get a progressive aggregate of the Amount field in a report, add a text
box with these properties:
Control Source =[Amount]
Running Sum Over Group
Format Currency
Visible No
Name txtAmountRS

Now in the Page Footer section, you can add a text box with Control Source:
=[txtAmountRS]

You can set the ScaleMode property if you wish, but I find it easiest to
work in twips.

 

[Vensia]

Thanks for your help. But I want the Amount at the first page bring the
second page and put before the first line of item, and so forth. How to do
it?
Thanks.

To get a progressive aggregate of the Amount field in a report, add a text
box with these properties:
Control Source =[Amount]
Running Sum Over Group
Format Currency
Visible No
Name txtAmountRS

Now in the Page Footer section, you can add a text box with Control Source:
=[txtAmountRS]

You can set the ScaleMode property if you wish, but I find it easiest to
work in twips.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

So you mean that it's better I put the invoice summary at the report
footer
section than the page footer section ?
For your information, the item description Can Grow.
My user also want there is a total summary for each page and the total
summary will be brought to the next page and placed before the first row
of
item. How to do it ?
Why the line width made by Line control and Line method can't be same ?
Thanks.


side-effect
of event
of

 

[Allen Browne]

Use the Page Header to show the running total.
Text box with Control Source of:
=[txtAmountRS]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for your help. But I want the Amount at the first page bring the
second page and put before the first line of item, and so forth. How to do
it?
Thanks.

To get a progressive aggregate of the Amount field in a report, add a
text
box with these properties:
Control Source =[Amount]
Running Sum Over Group
Format Currency
Visible No
Name txtAmountRS

Now in the Page Footer section, you can add a text box with Control Source:
=[txtAmountRS]

You can set the ScaleMode property if you wish, but I find it easiest to
work in twips.

So you mean that it's better I put the invoice summary at the report
footer
section than the page footer section ?
For your information, the item description Can Grow.
My user also want there is a total summary for each page and the total
summary will be brought to the next page and placed before the first
row
of
item. How to do it ?
Why the line width made by Line control and Line method can't be same
?
Thanks.


Before the days of computers, the printed invoice form would have the
summary at the bottom of the page, because there was no way to know
how
many
items would be needed at the time the page was printed. This is no longer
the case. In fact, a good argument could be made that placing the summary
immediately after the last item helps prevent the fraudlent addition
of
items being typed onto the printed invoice that are not included in
the
total at the bottom. Trying to make the computerized invoice fit the
old-school look is counter-productive (i.e. wasted effort that decreases
reliability.)

If you want to do it anyway, it sounds like you have simulated it with
unbound controls in the page footer. This works, but has the side-effect
of
making that space unusable on previous pages of the invoice. Another
approach is to identify the last item in the invoice, and in the
Format
event of the Detail section, continue to print the space for that item
until
you are far enough down the page to print the report/group footer. You
can
do that by toggling the report's runtime properties (PrintSection,
MoveLayout, NextRecord) until the report's Top property is far enough
down
the page. (Top is in twips, where 1440 twips = 1 inch.) This is still
quite
messy if the section CanGrow.

To get vertical lines on the page, use the Line method in the Page event
of
the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I mean an invoice with lots of items.
I want the invoice footer (such as signature, invoice amount) is
printed
at
the fixed position and last page, so I put the invoice footer at
page
footer. I put several vertical lines at Detail section. Can I make the
vertical line at detail section to be printed until below although the
invoice contains few items ?
Because the invoice footer just printed at the last page, there is a
blank
space at the pages before the past page which if it's possible, I
can
use
it
to print several items more. How to do it if it's possible ?
Thanks.


Please clarify.

Do you mean you want to print 2 copies of the same invoices, such
as
an
"Original" and a "Copy"?

Or do you mean an invoice with lots of items so that it runs over
multiple
pages?

Dear all,

Please help me how to create multi pages invoice report.
Thanks.

 

[Vensia]

Thanks Allen for helping.

Use the Page Header to show the running total.
Text box with Control Source of:
=[txtAmountRS]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for your help. But I want the Amount at the first page bring the
second page and put before the first line of item, and so forth. How to do
it?
Thanks.

To get a progressive aggregate of the Amount field in a report, add a
text
box with these properties:
Control Source =[Amount]
Running Sum Over Group
Format Currency
Visible No
Name txtAmountRS

Now in the Page Footer section, you can add a text box with Control Source:
=[txtAmountRS]

You can set the ScaleMode property if you wish, but I find it easiest to
work in twips.


So you mean that it's better I put the invoice summary at the report
footer
section than the page footer section ?
For your information, the item description Can Grow.
My user also want there is a total summary for each page and the total
summary will be brought to the next page and placed before the first
row
of
item. How to do it ?
Why the line width made by Line control and Line method can't be same
?
Thanks.


Before the days of computers, the printed invoice form would have the
summary at the bottom of the page, because there was no way to know
how
many
items would be needed at the time the page was printed. This is no longer
the case. In fact, a good argument could be made that placing the summary
immediately after the last item helps prevent the fraudlent addition
of
items being typed onto the printed invoice that are not included in
the
total at the bottom. Trying to make the computerized invoice fit the
old-school look is counter-productive (i.e. wasted effort that decreases
reliability.)

If you want to do it anyway, it sounds like you have simulated it with
unbound controls in the page footer. This works, but has the side-effect
of
making that space unusable on previous pages of the invoice. Another
approach is to identify the last item in the invoice, and in the
Format
event of the Detail section, continue to print the space for that item
until
you are far enough down the page to print the report/group footer. You
can
do that by toggling the report's runtime properties (PrintSection,
MoveLayout, NextRecord) until the report's Top property is far enough
down
the page. (Top is in twips, where 1440 twips = 1 inch.) This is still
quite
messy if the section CanGrow.

To get vertical lines on the page, use the Line method in the Page event
of
the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I mean an invoice with lots of items.
I want the invoice footer (such as signature, invoice amount) is
printed
at
the fixed position and last page, so I put the invoice footer at
page
footer. I put several vertical lines at Detail section. Can I make the
vertical line at detail section to be printed until below although the
invoice contains few items ?
Because the invoice footer just printed at the last page, there is a
blank
space at the pages before the past page which if it's possible, I
can
use
it
to print several items more. How to do it if it's possible ?
Thanks.


Please clarify.

Do you mean you want to print 2 copies of the same invoices, such
as
an
"Original" and a "Copy"?

Or do you mean an invoice with lots of items so that it runs over
multiple
pages?

Dear all,

Please help me how to create multi pages invoice report.
Thanks.