Crosstab Report has missing rows

  • Thread starter Thread starter MAB
  • Start date Start date
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!
 
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.
 
Back
Top