title: oracle matrix report filling null cells
body: <p>I have made a matrix report in oracle report builder like this</p>
  
  <p><img src="https://i.stack.imgur.com/kxEZ6.jpg" alt="enter image description here"></p>
  
  <p>And here is my query from which report is being calling</p>
  
  <pre><code>SELECT A.p_date,
         L.sup_name,
         Decode(A.perc_typ, 1, 'Buff',
                            2, 'Cow')     PERC_TYPE,
         A.sup_rate                       RATE,
         Decode(A.perc_typ,
         1, Round(( Nvl(A.fat_perc, 0) * Nvl(A.gross_vol, 0) ) / 6, 5),
         2, Round(
            ( Nvl(A.fat_perc, 0) + (
              ( Nvl(A.fat_perc, 0) * 0.22 ) + (
              Nvl(A.lr_perc, 0) * 0.25 ) + 0.72 ) ) *
            Nvl(A.gross_vol, 0) / 13, 5)) VOL
  FROM   mlk_purchase A,
         supplier L
  WHERE  A.sup_cod = L.sup_cod
         AND A.p_date &lt;= Trunc(SYSDATE)
         AND a.p_date &gt;= Trunc(SYSDATE) - 7
  ORDER  BY 1 
  </code></pre>
  
  <p>Problem is that there are are showing empty cells where no data is coming from query. I want to show zero cells instead of empty space. Is there any way to do this in oracle report builder.</p>