multi column problem

[Tom]

I have a report which prints:

Location (street address)
Service (ELectric or WAter)
Type (KW, KWh or TGAL. Any location will have AT LEAST ONE of these,
possibly all 3.)
My Detail

My detail is 12-24 months of information. I want each type in a separate
column, for a maximum of three columns. I get this. So I feel that I
am..."close". My problems are:

1. I lose a column at the beginning of the report. I get a Location header,
then no detail until the second column. For example, my first location has all
three types. So I "should" get three columns across. Instead I get only two
across, the first being column 2, in the center of the page, the second being
column three, on the right side, then the third on the next page. What am I
doing wrong?

2. When printing a new location, I want to start at the leftmost edge of the
page. In other words, start at/with column one. Can't I start with column one
when I start a new location?

As I'm composing this, I'm beginning to think that perhaps what I need is a
subreport(?) for the detail and modify my existing report for dealing with just
the locations. This is purely a guess, however, as I have not as yet done any
subreport type work. If I'm right about this, could you possibly give me some
detail so as to get me started?

I'm stuck. Any and all ideas/thoughts/help is appreciated. Thanks a lot,

Tom
----------
Here's some detail of my report...

Access 2000.

Sorting and Grouping:
Location (group header)
Service (group header)
Type (group header)
Year
Month

Report Header
Page Header
Location Header (Repeat Section = Yes, so it prints at the top of each column)
Service Header (empty)
Type Header (empty, New Row or Col = After Section)
Detail
Page Footer
Report Footer

Page Setup (Columns = 3)

 

[Marshall Barton]

I have a report which prints:

Location (street address)
Service (ELectric or WAter)
Type (KW, KWh or TGAL. Any location will have AT LEAST ONE of these,
possibly all 3.)
My Detail

My detail is 12-24 months of information. I want each type in a separate
column, for a maximum of three columns. I get this. So I feel that I
am..."close". My problems are:

1. I lose a column at the beginning of the report. I get a Location header,
then no detail until the second column. For example, my first location has all
three types. So I "should" get three columns across. Instead I get only two
across, the first being column 2, in the center of the page, the second being
column three, on the right side, then the third on the next page. What am I
doing wrong?

2. When printing a new location, I want to start at the leftmost edge of the
page. In other words, start at/with column one. Can't I start with column one
when I start a new location?

As I'm composing this, I'm beginning to think that perhaps what I need is a
subreport(?) for the detail and modify my existing report for dealing with just
the locations. This is purely a guess, however, as I have not as yet done any
subreport type work. If I'm right about this, could you possibly give me some
detail so as to get me started?

I'm stuck. Any and all ideas/thoughts/help is appreciated. Thanks a lot,

Tom
----------
Here's some detail of my report...

Access 2000.

Sorting and Grouping:
Location (group header)
Service (group header)
Type (group header)
Year
Month

Report Header
Page Header
Location Header (Repeat Section = Yes, so it prints at the top of each column)
Service Header (empty)
Type Header (empty, New Row or Col = After Section)
Detail
Page Footer
Report Footer

Page Setup (Columns = 3)

Excellent explanation of what you have, which immediately
points out that your "missing" column one is caused be the
New Row or Column setting of After Section for the Type
Header. Not sure about this, but I think you want a Type
Footer with New Row or Column set to After Section.

You also may want a Location Footer with Force New Page set
to After Section.

Off hand, I think(?) that the only(?) reason you might need
a subreport is if you want the Location and Type
headers/footers to span the entire width of the page, not
just the column.

 

[Tom]

Excellent explanation of what you have, which immediately
points out that your "missing" column one is caused be the
New Row or Column setting of After Section for the Type
Header. Not sure about this, but I think you want a Type
Footer with New Row or Column set to After Section.

You also may want a Location Footer with Force New Page set
to After Section.

Off hand, I think(?) that the only(?) reason you might need
a subreport is if you want the Location and Type
headers/footers to span the entire width of the page, not
just the column.

Well, I guess what I DO want is for my LOCATION to span the width of the page,
using 1-3 columns of the detail for each location. Does this sound like we're
going to the land of subreports?

 

[Marshall Barton]

Well, I guess what I DO want is for my LOCATION to span the width of the page,
using 1-3 columns of the detail for each location. Does this sound like we're
going to the land of subreports?

Not yet clear. If you want the Location HEADER SECTION (or
some other header or footer) to span the page width, but the
details in multiple columns, then use a subreport.

If you want each location to start in the left hand column,
it would probably also be easier using a subreport.