Hide/Limit Records in a Report

S

Steve Hughes

Hi, I have a subreport that contain upto 63 records. However I can only fit
32 lines on a singe page and then the remainder goes onto the next page. I
want the report to stay on a singe side, therefore I want to limit one report
to 32 records and then display the remaining records on another report. I
have created a count field within the report, however how do I prevent one
report showing records after number 32 and the other only showing records
after 32.

Any help would be grately appreciated. Tahnks
 
A

Allen Browne

Create 2 queries to feed the 2 reports.
In query design view, open the properties box.
Set the Top Values property to 32 for one query, and 31 for the other.

You will need to sort these queries in opposite ways. For example, if you
sort on a field named ID, the first will need to be Ascending, and the seond
query Descending.

(On the reports, you can sort them any way you wish. This is just for
selecting the TOP records.)
 

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

Similar Threads

Why do I get a Page Break after each record? 7
Report Not Showing All Records 0
Subreport messing up spacing of report 4
Limit Records Shown Per Report 5
blank subreports appearing on every record of report 0
Hide subreport and main report record if subreport running sum is zero 9
Report limits on subreports 3
Force page after 20 records 0

Top