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...
 

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