Force Header & Footer w/ no Detail

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

I have a report that is sorted by Employee then category 1
transactions and category two transactions.

Report header
Page Header
Employee Header
Category Header
Detail
Category Footer
Employee Footer
Page Footer
Report Footer

Even if there are no category 1 transactions I would like
the category header and footer to print. How can I make
this happen when there are no transactions? (I'd prefer
that no header or footer print for category 2 when there
are no category 2 transactions.)

Any suggestions would be appreciated. Thanks.
 
Erin said:
I have a report that is sorted by Employee then category 1
transactions and category two transactions.

Report header
Page Header
Employee Header
Category Header
Detail
Category Footer
Employee Footer
Page Footer
Report Footer

Even if there are no category 1 transactions I would like
the category header and footer to print. How can I make
this happen when there are no transactions? (I'd prefer
that no header or footer print for category 2 when there
are no category 2 transactions.)
Click to expand...

The report's record source query will have to use a Left
Join from a table that includes all categories to the
table/query you're currently using.
 
Back
Top