Crosstab Report has missing rows

M

MAB

Just a quick question...

I have a crosstab report that works very well, except that when any row has
zero values all the way across, it omits the row altogether. Is there a way
to force the row heading to appear and display the zeros? I know I can make
all of the columns appear, even when they have zero values all the way down.
But I'm having problems with the rows. Thanks!
 
D

Duane Hookom

You would need to join to a table/query that has all the possible row
heading values. You can set the join properties to include all the records
from one "source" and matching from the other.
 
Top