Re-orienting a Report Vertically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AMessyGuy - 13 Mar 2008 15:53 GMT

When I create reports they are always oriented horizontally. The column
headings and columns run vertically but each item in a record runs
horizontally. I cannot find a way to rotate this 90 degrees to the left
where the record field headings run along the side of the report and the
record data runs vertically for each record, fitting many records on one page.

For example, if I have Last Name, First Name, Phone Number--when I create a
report each field name runs across the top of the page and each record runs
underneath the field names. I'd like to have each field name running down
the left side with as many "columns" that will fit on a page containing the
record data for each person. So, I may be able to fit five people on a page
this way.

In the Design view of a report it seems like the natural orientation is to
horizontally build up a table. How can I build it vertically, instead. I'm
sure it must be very easy but it escapes me. (I hope this makes sense).

Thanks, as always!

Signature

Home computers are being called upon to perform many new functions,
including the consumption of homework formerly eaten by the dog.

Reply to this Message

Evi - 13 Mar 2008 16:17 GMT

I'm guessing you've created your report using the report wizard. They love
creating Tabular Designs in landscape view (that's the view you are
describing as having now).
The design you are want is called a Columnar design (illogically, in my
opinion, you'd have thought that the horizontal one style would be called
that) and you probably want to have it on paper that is Portrait

Look out for the word Columnar and Portrait in the Wizard (it comes near the
end of the choices it goes through) and use the Option button to have it
make that sort of layout for you.

Meanwhile, if you open your report in Design View you can slide each field
(the text boxes with the field names in them) to where you want it to go.
Keep it in the section of the report where it is now (until you get more
comfortable with doing this). The Section is the the bit between 2 grey
horizontal bars.

Imagine that you are creating a single record and slide so that the fields
appear as you want one record to appear.

As you play around with it, keep looking at the report in Preview view to
see what effect your adjustments make.

Once you've got your field layout, go to File, Page Setup and set a
different number of columns. Make sure that you adjust the column width
there too.

Evi

> When I create reports they are always oriented horizontally. The column
> headings and columns run vertically but each item in a record runs
[quoted text clipped - 17 lines]
> Home computers are being called upon to perform many new functions,
> including the consumption of homework formerly eaten by the dog.

Reply to this Message