How to show dynamic data as part of row

Hi 
 
I have a service which returns me resultset that looks like the following: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<response>
<ns6:transactionLogLine>
<ns5:id>111</ns5:id>
<ns5:transactionType>Buy</ns5:transactionType>
<ns5:transactionDate>2010-11-09</ns5:transactionDate>
<ns5:account>1234</ns5:account>
<ns5:res>false</ns5:res>
<ns5:attributes>
<ns5:attribute>
<ns5:txt>color</ns5:txt>
<ns5:value>red</ns5:value>
</ns5:attribute>
<ns5:attribute>
<ns5:txt>weight</ns5:txt>
<ns5:value>10</ns5:value>
</ns5:attribute>
<ns5:attribute>
<ns5:txt>supplier</ns5:txt>
<ns5:value>BAT</ns5:value>
</ns5:attribute>
</ns5:attributes>
</ns6:transactionLogLine>
<ns6:transactionLogLine>
<ns5:id>222</ns5:id>
<ns5:transactionType>Buy</ns5:transactionType>
<ns5:transactionDate>2010-11-09</ns5:transactionDate>
<ns5:account>5555</ns5:account>
<ns5:res>false</ns5:res>
<ns5:attributes />
</ns6:transactionLogLine>
<ns6:transactionLogLine>
<ns5:id>333</ns5:id>
<ns5:transactionType>Buy</ns5:transactionType>
<ns5:transactionDate>2010-11-09</ns5:transactionDate>
<ns5:account>7411</ns5:account>
<ns5:res>false</ns5:res>
<ns5:attributes>
<ns5:attribute>
<ns5:txt>color</ns5:txt>
<ns5:value>yellow</ns5:value>
</ns5:attribute>
<ns5:attribute>
<ns5:txt>type</ns5:txt>
<ns5:value>LCD TV</ns5:value>
</ns5:attribute>
</ns5:attributes>
</ns6:transactionLogLine>
</response>
</pre>
 
In my report i need to show a pdf file that has all the following : 
id = 111 
transactionType = Buy 
transactionDate = 2010-11-09 
account = 7411 
color = red 
wieght = 10 
supplier = BAT 
<<<<<<<<<<<< empty line >>>>>>>>>>>> 
id = 222 
transactionType = Buy 
transactionDate = 2010-11-09 
account = 5555 
<<<<<<<<<<<< empty line >>>>>>>>>>>> 
id = 333 
transactionType = Buy 
transactionDate = 2010-11-09 
account = 7411 
color = yellow 
type = LCD TV 
 
So I need to show the Attributes of each transactionLogLine in its data row....but how? 
They are dynamic, some have no attributes and others have 10 attributes. 
 
Should i use 2 different datasets? How do i link them? 
Or is there a report item that i can use which will allow me to do this? 
Or must i use a data cube (cannot figure it out) ? 
 
When i think of how one does it in xsl transformation then its simple but i cannot think of a way to do it in a Birt report. 
 
Thanks.

Find more posts tagged with

Comments

Saint_77

Ok, i figured it out.
I had to create 2 datasets. 1 for the details and the 2nd one for the attributes....on this one my "Row mapping" was set to :
/soapenv:Envelope/soapenv:Body/ns6:Response/ns6:transactionLogLines/ns6:transactionLogLine/ns5:attributes/ns5:attribute
and in it i also added the ID from the details section above it.

Then i created a Joined Data Set (Left outer Join and used the ID added the attributes section to link the details etc. together)

I then added a table on my page and just added categories for all the Details elements....this way they only appear once on the report.
In the dataRow of the table i put the "Key" and the "Value" for display.

It now displays the way they wanted it ..... so the attributes section is dynamic for each of the details sections.