"Columns" in a report

I have a report that I’m working on and through trial and error have almost
what I need. The current report is formatted something like this:

SECTOR Field1 Field2 Field3 Field4 Field5 Field6 Field7


The first problem is that whenever there is a new sector I want to start a
new row. Right now it’s not doing that – it’s starting a whole new page. So
instead of a running report which should be about 3 pages, it’s 12 pages long.

The second problem is that right after Field 7 there is supposed to be a
TOTALS column which gives a total but it’s a footer, not a separate column.
Second question is how do I get that to be it’s own column?

I was getting the desired results using 12 sub reports but now the groups
are too big and I can’t get them to fit as there is a limit to the detail
area.

Thanks in advance!

(sorry for the cross posting, posted this in queries first by mistake)