Report - Columnar and tabular

[pat]

I am trying to create a report that would basically look
like the following:

name: Joe
Ref: PO 152222
Ref2: SKU 5555
Dest: LAX

Vessel Closing Date ETD ETA
100 9/25/03 9/28/03 10/15/03
200 9/26/03 9/28/03 10/16/03

I have a main form with the top data and the subform has
the bottom information its a 1 to many relationship.

The query that generates the report is ok, it reflects 2
records accross, if I run a report that goes accross its
fine. The problem is when I have part of the report going
down and the other accross.

Thanks in advance for your assistance.

Pat

 

[Duane Hookom]

I assume you have a subreport that is multi-column and want the columns to
display down and then across. Subreports don't work this way. There are
somewhat difficult work-arounds.

If I miss-understood your question then please try again.

 

[pat]

I have a main form and a sub form but not a subreport.
Maybe thats where I have gone wrong?

Any advise.

Thanks.

Pat

 

[Duane Hookom]

I wouldn't print forms. Use reports instead.

 

[pat]

I am generating my report from a query. The problem is
that I need half of the report to be tabular and then part
columnar. This works fine in my forms and in the queries
but when I generate a report it only wants to give me a
one on one even if I have a one to many.

Thanks for your assistance.

Pat

 

[Duane Hookom]

You can create a group header based on your main table and place the main
table fields in it. Place your detail fields in the detail section. This is
much like the invoice report in the Northwind sample database.