Need Help Creating Invoice Report

  • Thread starter Thread starter Cassandra
  • Start date Start date
C

Cassandra

I am sorry about what looks like multiple posts! I forgot to include two other
groups when I first posted and then mistakenly posted to my previous post when I
tried to repost.

I need help on how to create blank lines on an invoice report. If there are only
a few line items, I need to create blank lines so that Subtotal, Shipping, Sales
Tax and Grand Total will always be at the bottom of the page. Also, if there are
many line items that carry down to the bottom of the page or over to the next
page, I need to have at least one line item on the second page and Subtotal,
Shipping, Sales Tax and Grand Total immediately under the last line item.

Thanks for your help!

Cassandra
 
Cassandra said:
I am sorry about what looks like multiple posts! I forgot to include two other
groups when I first posted and then mistakenly posted to my previous post when I
tried to repost.

I need help on how to create blank lines on an invoice report. If there are only
a few line items, I need to create blank lines so that Subtotal, Shipping, Sales
Tax and Grand Total will always be at the bottom of the page. Also, if there are
many line items that carry down to the bottom of the page or over to the next
page, I need to have at least one line item on the second page and Subtotal,
Shipping, Sales Tax and Grand Total immediately under the last line item.

Thanks for your help!

Cassandra
Click to expand...

I would check out a couple of help topics...the KeepTogether property
and the NewRowOrCol property. You will have to experiment with them to
see if you can use them in your report.

The next topic to review is the MoveLayout, NextReocrd, PrintSection
property. With some programming, a couple of variables judicially used,
and you should be able to do what you want. If you study the TruthTable
for this property in help, you can really pack some power into a
report. It isun't used ofter but it is a handy property.

Ex:
If lngCnt > 20 and lngCnt < 55 then
;print a blank line
Me.MoveLayout = True
Me.nextRecord = False
Me.PrintSection = False
lngCnt = lngCnt + 1
endif
 
Cassandra,
If I understand you correctly, I would simply include the
total, shipping, etc ... as a subform. This way you can
decide how far off the last line you need. If you're
unsure check the Northwind sample database. It contains a
great deal of examples.

HTH
Ray
 
Patrick,

Thank you for responding to my question!

<If you study the TruthTable for this property in help, you can really pack some
power into a report. >
What is the "TruthTable" and what property are you referring to?

Could you explain what your sample code is doing?

Thanks!

Cassandra
 
Back
Top