If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Getting the XML report output in a .Net Dataset

Started by swar80, 17 Mar 2009 09:13:46 AM

Previous topic - Next topic

swar80

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