I am executing a report in Cognos and getting its ouptout in XML by specifying the Render Type as XML
The output which i am getting is as follows
<?xml version="1.0" encoding="utf-8"?>
<dataset xmlns="http://developer.cognos.com/schemas/xmldata/1/" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance">
<!--
<dataset
xmlns="http://developer.cognos.com/schemas/xmldata/1/"
xmlns:xs="http://www.w3.org/2001/XMLSchema-instance"
xs:schemaLocation="http://developer.cognos.com/schemas/xmldata/1/ xmldata.xsd"
>
-->
<metadata>
<item name="COM_ID" type="xs:long"/>
<item name="DATE" type="xs:dateTime"/>
<item name="COM_ABOUT" type="xs:string" length="4"/>
<item name="COM_CODE" type="xs:string" length="6"/>
</metadata>
<data>
<row>
<value>15800</value>
<value>2008-01-31T00:00:00</value>
<value>P</value>
<value>C9</value>
</row>
<row>
<value>20836</value>
<value>2008-06-13T00:00:00</value>
<value>B</value>
<value>C9</value>
</row>
</data>
</dataset>
I am finding it difficult to get this xml stream into a .net data type like dataset or into any collection for that matter.
It brings in this data in a format where it creates different tables for metadata,data,row etc..
I would want a single table with the metadata items as the columns and the data rows values as actual rows in the table.
some thing like below in a dataset
COM_ID DATE COM_ABOUT COM_CODE
15800 2008-01-31T00:00:00 P C9
20836 2008-01-31T00:00:00 B C9
Can any one help me in this?
Regards
Swaroop