title: To show blank in the 1st row (if it is NULL value) in BIRT Reports
body: <p>I created a Report using BIRT Report Design in Eclipse Java EE IDE(Juno Release). In that Report, For the single row it have multiple values for the corresponding one column(I used LISTAGG() oracle function to map that).</p>
  
  <p>(i.e.) Result column have multiple values in the below database table output :</p>
  
  <h2>No    Name    Result     Mark</h2>
  
  <p>1     John    X            32
                XX
                XXX
  2     Joe     X            56</p>
  
  <pre><code>          XX
            XX
  
            XXX
  </code></pre>
  
  <p>3    Andrew                34</p>
  
  <pre><code>          XXX
            XX
  
            XXXX
  </code></pre>
  
  <p>… It have both NULL and NOT NULL values in it.</p>
  
  <p>"If the NULL values are in the middle means its showing the results properly in the Report"</p>
  
  <p>Sample Result am getting in Report output for Joe (.pdf form)</p>
  
  <h2>No    Name    Result     Mark</h2>
  
  <p>2     Joe     X           56</p>
  
  <pre><code>          XX
            XX
  
            XXX
  </code></pre>
  
  <p>Here the problem is, “If First record has a NULL means it is not showing properly in the Report, instead of that NOT NULL value will print in the front and so on…”</p>
  
  <p>Sample Result am getting in Report output for Andrew (.pdf form)</p>
  
  <h2>No    Name    Result     Mark</h2>
  
  <p>3    Andrew     XXX       34
                  XX</p>
  
  <pre><code>            XXXX
  </code></pre>
  
  <p>But we have TWO NULL values present in the Front of Result column for Andrew (As you see sample database table output above)…</p>
  
  <p>Is there any option to show blank in the first row(if it is a null column) for the particular row in the Birt report tool ?</p>
  
  <p>Kindly Help me to Solve this issue… Thank you!</p>