two copies of same report on 1 page

  • Thread starter Thread starter Guest
  • Start date Start date
I expect this is a matter of your sorting and grouping. You should sort
first by employee.
 
wendell said:
i got a new problem. it is closely related to my other problem.

pls take a glimpse of this :
http://www.geocities.com/wendellremolador/payslip.jpg

i applied your trick but what currently happened is that, the report shows
all of the data first before showing its respective duplicates.

i'd like the report to show me the first employee's payslip and its
duplicate will be on the same page while the next employee's payslip and
duplicate be on another page and so on, so forth.
Click to expand...


Sorry to take so long getting back to you, but I think I've
got a good excuse - both my mother and mother-in-law arrived
for their summer visit . . .

Anyway, set the main report's record source to:

SELECT Copies.Num,
subreportsrecordsource.keyfield
FROM Copies, subreportsrecordsource

Then set the main report sorting to the keyfield and set the
subreport control's Link Master and Link Child properties to
whatever field is the keyfield. You may(?) have to add an
invisible text box bound to the keyfield in the main
report's detail section to get the Link Master property to
work correctly!?

We probably should have done this in the other report, but I
didn't want to complicate things when there was only going
to be a single record in the subreport.

As an alternative to doing this with a subreport, we could
have crammed it all into a single report, but you may then
have to add a grouping level to simulate the subreport's
page header section and you could have a trouble with a page
footer. You would also need another level of grouping to
replace the subreport's Report Header and Footer sections.
But this is a lot messier and not worth the effort unless
the first approach is too slow to be practical.
 
Back
Top