Re-orienting a Report Vertically

A

AMessyGuy

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!
 
E

Evi

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
 

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