Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Form with Duplicate Detail Lines

Status
Not open for further replies.

Irwin

IS-IT--Management
Jan 21, 2002
25
US
The report form I am trying to create is an Check with a Top/Bottom stub with the voucher in the middle.
Prevously within procedural code I able to reset the record number to print the bottom stub and printing with a Generic/Text printer. The was working great in W95 & W98, but W2K & XP it doesn't. So I wanted to use a report form. Does anyone have any thoughts on how I can print the same detail lines on the top & bottom stub?

Thank You All in Advance,
Irwin
 
Make your report/page layout the size of the check including the stub. Then, copy / duplicate the fields on both the top portion and bottom portion.


Dave S.
[cheers]
 
Irwin -

In my retail system check printing routine, I created two different reports, one for the detail and one for the voucher, then ran them over the same data set as many times as needed. This allows you to keep track of detail lines so that in one check paying multiple invoices you could have more detail lines then would print on one stub:

Print Stub Report (first detail set)
Print Check Report with "Void"
Print Stub Report (first detail set)
update "lines" count
eject
(repeat as needed to cover all invoices)

Print Stub report(nth detail set)
Print actual check amount
Print Stub report (nth detail set)
eject

Another solution would be to extract the stub detail and check figures into variables before calling the report then update the data on successful printing.

Steve
 
Dave & Steve,
Thank you both for your reply, I will try your suggestions.

Thanks again,
Irwin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top