2 Questions about Report Formatting

G

Guest

Hello:

What I am attempting to do is to write a system that print checks (I may
have made multiple posts regarding various problem concerning this system). I
apologize for having to make multiple posts.

I've now gotten to the portion where I am actually formatting the output of
the print out.

The secitons are now divided into 3.

1. Check Header (Contains the main body of the Check face, Date, Number,
Customer information, etc.)
2. Detail Section that pulls in all the transaction recrods that has this
Check Number.
(Invoice #, Date, References, act as stub 1 to give to the costomer along
with the check).
3. Check Footer (contains a subform that contain essentially the same
information as Detail section, with a few different fields to act as stub 2
for us to keep).

My first question is, the stub section has been divided into 2 columns on
the pre-printed check paper.
e.g.
Invoice | Reference Inovice | Reference

I would like to be able to have the transaction parts (the items pulled from
the detail section) to be able to print on the 2nd set of columns once there
are more than say 10 records.
e.g.
Invoice 1 | Reference1 Invoice 11 |
Reference 11
Invoice 2 | Reference2 Invoice 12 |
Reference 12
Invoice 3 | Reference3 etc.
x
x

Is it possible to set the size of the detail section? I've also tried to
have the page setup to say 2 columns and records from top to down and then
right. But so far, all the records, no matter if it's 1 record or 12 records
still end up printing on 1 column.

Question 2:
Somewhat to do with my 1st question. The sub form in the footer was put
there to make Stub 2. However, depending on what size the detail section end
up being, this portion gets moved up and down too, so it will never start
printing at a set portion. I would like this portion to print from the same
spot on the paper, and have the records line up the same way as the one on
stub 1 (e.g. left, top to bottom, right).

The Header portion prints from the same spot every time with no problem. But
it's the details and the footer part that always give me trouble. I'd
appreciate any help about these issues.

I hope I was not too confusing in my explanation.

Thank you,

Shohoku79
 
D

Duane Hookom

Make sections 2 and 3 as subreports and remove details from the main report
record source. Set the height of the subreports as required.
 
G

Guest

Thank you Mr. Duane. That did the trick. Before I was stuck on how to make a
duplicate section of the detail section for the stub 2 section. I ended up
making a subform to display the data. But I never thought of to use just the
detail section for the entire paper and use two subreports.

Thank you very much once again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top