Force Header & Footer w/ no Detail

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.
 
M

Marshall Barton

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.
 

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

Similar Threads

Section and Page numbering 0
A03 - count in report footer gives me #Error? 0
Automatically insert "Continued" in footer based on existing STYLEREF 2
(headers & footers Issue) I have 2 even pages back to back!! 1
page header on second page of invoice. 3
"Continued" in Header and Repeat Footers 3
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Unique counter in section HEADER 2

Top