Report question?

  • Thread starter Thread starter deercreek
  • Start date Start date
D

deercreek

I have a report question if anyone could help. I have a query that I
want to drive a report. The query can have multiple lines of
information driven by an id field. When I make my report I would like
to be able to show everything on one page. Also I want to be able to
show certain column headings only once like name for instance, but
other fields I would like to show the multiple lines of information I
have. Is this Possible?
 
Obviously, DeerCreek, if there is more than one page worth of data, it will
require more than a single page. But for those fields that you'd like to
print once, use Grouping (View, SortingAndGrouping in Design View). For
example, if you were printing out customer orders, and wanted to sort by
customer, and group all of a customers' orders together for output something
like:

Abbott Laboratories

Order # Invoice Amt
--------------------------
12345 $1,000,000
23456 $534,000

Merck

Order# Invoice Amt
--------------------------
12353 $750,000

....etc.

you'd sort and group by Customer.

Hope that helps.

Sprinks
 
Back
Top