Report Formatting

A

awach

I have a report with a header and detail section. The report is designed like:
Customer Name (header)

type wholesalecost retailcost (detail)

And is printed like:
Customer Name1
type1 1 3
type2 1 2
type3 2 4

type1 1 2 *this is actually for a different
customer
type2 5 10
type3 4 5

What I would like it to be printed like is
Customer Name1
type1 1 3
type2 1 2
type3 2 4
***new page
Customer Name2
type1 1 2
type2 5 10
type3 4 5.....

When I try changing the setup to include columns it doesn't work. It cuts
each section into columns? Any ideas on how to do this? Thanks!
 
D

Duane Hookom

All sorting and grouping in reports is handled by your settings in the
Sorting and Grouping dialog. It looks like you only need to set the Sorting
to Customer and then display the Group Header/Footer. You can set the
section properties to page break before or after the section.
 
A

awach

I tried that but still all of the groups are appearing on the left hand side
of the page. If I add columns after doing that the groups just appear more
compact but, again, don't stretch over to the other side or the middle of the
page. Any ideas?
 
D

Duane Hookom

I guess I don't understand what you have and what you are attempting to do.
Why are you adding columns? Your "What I would like it to be printed like
is" doesn't seem to have columns...
 
Top