Displaying null records in a a report

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hello,

I have a "Contract Status" report that essentially places
a "contract" into 10 categories (you can think of these as
process stages) depending on contract variables.
Contracts are grouped by Employer, and the user is
prompted to enter the Employer when the report is
launched.

So, an Employer may have hundreds of contracts throughout
the 10 status categories. My problem is that if a
contract category has no records, the category
header/title doesn't display in the report. I want the
report to list all the contract categories on the report,
and list the contracts that go under each category so it
plainly reads as that status category not having any
contracts in it rather than the report looking like it is
missing something.

For example, this is how the report displays now -
---------------------------------
Contract Status 7:
A
B
C

Contract Status 9:
Y
K
R
--------------------------------------
I want the report to display:
--------------------------------------
Contract Status 7:
A
B
C

Contract Status8:

Contract Status 9:
G
H
I

etc......
 
Hi Scott.
The way to do this is to base your report on a query where
you set the relation between your Contract Category and
the related table(s) in inlcude ALL from the Contract
Category and only those from the related tables where data
is present.
Than, grouping on the category will show all.
Hope this helps.
Fons
 
Back
Top