title: creating group and analyzing data from array list in birt
body: <p>I am using mongo db in birt reports. I have data set which contains an array of object like in the picture.</p>
  
  <p><a href="https://i.stack.imgur.com/9e03R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9e03R.png" alt="enter image description here"></a></p>
  
  <p>deviceStatus is an array which contains child object like status,erroCode,deviceName etc.</p>
  
  <p>I want to create the group for deviceName in the report when I create the group, it is created in this form : </p>
  
  <pre><code>[ "CardReader" , "CashAcceptor" , "CashDispenser" , "ChequeAcceptor" , "EmiratesIdScanner" , "PinPad" , "JournalPrinter" , "ReceiptPrinter" , "StatementPrinter" , "SignpadScanner"]
  </code></pre>
  
  <p>I want it to be grouped in the broken form like : </p>
  
  <pre><code>CardReader
  CashAcceptor
  CashDispenser ..
  </code></pre>
  
  <p>Also the errorCode is coming in this form from data set :</p>
  
  <pre><code>[ "97080301" , "97080302,97080303" , "" , "" , "" , "" , "" , "" , "" , ""]
  </code></pre>
  
  <p>In the same way I want to break the error code and status code from array form to each row for each deviceName like.</p>
  
  <pre><code>CardReader  97080301
  CashAcceptor 97080302,97080303
  CashDispenser 
  </code></pre>
  
  <p>I am new to birt , please someone help. thanks in advance.</p>
  
  <p>After Applying Veeram's answer , errorCode is not showing in the report but its there in preview results :</p>
  
  <p>1 : 
  <a href="https://i.stack.imgur.com/QOwox.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QOwox.png" alt="enter image description here"></a></p>
  
  <p>2 :</p>
  
  <p><a href="https://i.stack.imgur.com/GDMSn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GDMSn.png" alt="enter image description here"></a></p>