Reports: one record per page

D

Dave

I have a report of orders with no header or footer, just a detail section.

I want each record (order) to appear on its own page.

I select the orderid in the Sorting and Grouping dialog box and experiment
with various "Keep together" options. However, none of them will produce
what I want: only one order record per page. I always get more than one
order per page.

What am I doing wrong?
 
M

Marshall Barton

Dave said:
I have a report of orders with no header or footer, just a detail section.

I want each record (order) to appear on its own page.

I select the orderid in the Sorting and Grouping dialog box and experiment
with various "Keep together" options. However, none of them will produce
what I want: only one order record per page. I always get more than one
order per page.


Just set the detail section's ForceNewPage property to
Before Section.
 
D

Dave

Thanks guys

I tried the "Before Section" property value and my first page was blank. So
I switched to "After Section" and it gives me what I need.

Thanks again.
 
M

Marshall Barton

The blank page you got by using Before Section is probably a
blank Report Header section. If that's the case, you may
want to Make the header invisible.
 

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