Repeat information on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm wondering if there is a way to print the detail section of a report
several times in a report. I can do it by copy and paste so that there are
identical reports side by side. I'm looking at doing it four times, but side
by side and once above the other.
 
prairiewind said:
I'm wondering if there is a way to print the detail section
of a report several times in a report. I can do it by copy
and paste so that there are identical reports side by side.
I'm looking at doing it four times, but side by side and
once above the other.
Click to expand...

The Detail Section is printed once for each Record, and I am not certain I
understand how you want to position the four copies...

(1) First, how many records are in the Table/Query that is the RecordSource
of your Report?

(2) Do you want to print all the Records in each Detail Section? If so, one
approach would be to create a report that prints the Records, and a main
Report, then embed the same Report in each of four appropriately-placed
Subreports.

(3) Or do you want to print four copies of the first Record, then four
copies of the second Record, etc.? In this case, the simplest way would be
to copy the Controls into four areas of the same Detail Section.

(4) Or do you want something else that isn't obvious to me? If so, please
clarify and perhaps someone can give you a useful suggestion.

Larry Linson
Microsoft Access MVP
 
There are about 250 records in the RecordSource that I'm using. I'll briefly
lay out what I'm wanting.

MainDataLine1 MainDataLine1
SubDataLine1 SubDataLine1

MainDataLine2 MainDataLine2
SubDataLine2 SubDatlaLine2

MainDataLine1 MainDataLine1
SubDataLine1 SubDataLine1

MainDataLine2 MainDataLine2
SubDataLine2 SubDatlaLine2

and so on. In essence, I have four identical reports on one page, one in
each quadrant. Your suggestion/question 2 is the most accurate. I tried
that, but didn't seem to have much luck.

prairiewind
 
I'm having a difficult time getting the subreports to turn out correctly. I
can put four on a page, but they only show the first page of data, not the
next 35 pages as in the original report. Any suggestions as to what I'm doing
wrong? or what I could be doing differently?
 
Back
Top