Using Oracle Report Builder 6.0, I have created a matrix with group report. The rows are labeled residence code (Hawaii, International) and the columns are the years (1999, 2000). This is what the report should look like:
1989 1990 1991
Mainland156 0 200
International 0 0 0
Hawaii 500 0 550
Pacific 0 0 0
This is what I get:
1989 1991
Mainland 156 200
International 0 0
Hawaii 500 550
Pacific 0 0
The column for 1990 does not display because all the counts are zero.
How do I get a column of all zeros to display on the report?