Printing certain records on a subreport

  • Thread starter Thread starter VesG
  • Start date Start date
V

VesG

I have a report that has a Subreport. I'd like to print
the first 2 records from the Subreport with the Main
report page then print all remaining records on the next
page. Is this possible?

Thanks
 
If I create two subreports, how do I make the first
subreport print no more than 2 records?
 
I would add a text box to the detail section:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Then add code to the On Format Event
Cancel = Me.txtCount >2

This will only print two records.
 
That works. Thanks.
I've been trying a few other things, but still can't get
the results I'm looking for.

What I have now is a 2-page report. I'm using 2 subreports
that basically print out the same data. The first
subreport is used to print when there are <=2 records, and
the second subreport prints on the next page if there are
2 records. I have the second subreport position pass the
Click to expand...
bottom margin, so therefore it prints on the next page
(which is what I want it to do). The problem is because
it is positioned there, I will always have 2 pages even
when I only want one (which is when there are <= 2 records
to display). How do I stop the second page from printing
when its <=2 records?

Thanks

Vesg
 
Back
Top