Binding with Scripted Data Set

sriram nagappan

<p>Hi Team,<br><br>
I have designed a report which entirely uses Document Object Model (DOM). The objective of the report is to display the Documents for the customer and along with few more fields like Amount,Currency,Expiry Date which are stored as User Defined Feilds (UDF). The structure is that a Customer can have many documents and each document will have these UDF's Amount,Currency,Expiry Date, etc. In XML file, there can be many Document Tag under REX tag and under each Document Tag, there can be many UDF inner tags.<br><br>
I have attached sample DOM dataset details (xml file) and the rptdesign file. In the report, i have used dataset 'Obligor' to fetch the Documents imported for the customer using Open & Fetch script.<br><br>
The issue here is that i am able to list all the documents of the customer but not able to fetch the User Defined Fields which are inner tags of the Document Tag.  Can you please help on this.

Clement Wong

<p>The solution is attached.  I used <a data-ipb='nomediaparse' href='https://developer.mozilla.org/en-US/docs/Archive/Web/E4X/Processing_XML_with_E4X'>E4X </a>(read my <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1122-parsing-xml-in-birt-with-e4x/'>DevShare post</a> regarding its usage and a sample) to easily parse the XML using a Scripted Data Source / Data Set.  The <em>beforeOpen</em>, <em>open </em>and <em>fetch </em>events have been overwritten.</p>
<p> </p>
<p>The logic to parse the data is in the <em>fetch</em></p>
<pre class="_prettyXprint">
//FOR DEBUG, THIS WORKS ONLY IN COMMERCIAL BIRT
//logger = java.util.logging.Logger.getLogger("birt.report.logger");
//logger.warning (result);

if( currentrow >= totalItems ){
    return false;
}

row["OBJECT_NAME"] = rex.DOCUMENT[currentrow].@OBJECT_NAME;
row["Document ID"] = "unknown";
row["Document Type"] = rex.DOCUMENT[currentrow].@ACA_AD_DOCTY;
row["Document Status"] = rex.DOCUMENT[currentrow].@ACA_AD_CCLCST;


// Loop through the UDFs
for each(var udf in rex.DOCUMENT[currentrow].child('UDF'))
  {
      if (udf.@UDTYNA == "Expiry Date")
          row["Expiry Date"] = java.text.SimpleDateFormat("yyyy-mm-dd").parse(udf.@UDDA);
    else if (udf.@UDTYNA == "Amount")
          row["Amount"] = java.lang.Float.parseFloat(udf.@UDDA.toString());  
    else if (udf.@UDTYNA == "Checker")
          row["Checker"] = udf.@UDDA;                            
  }

currentrow++;
return true;</pre>
<p>Make sure to modify the file location in the <em>beforeOpen</em>.</p>
<p> </p>
<p>I've also addressed your other question in <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/37773-dom-datasource-how-to-sum-the-column-values/'>this thread </a>about adding a total of the amount at the bottom.  It was just as simple as inserting an aggregation report item as I previously suggested.</p>