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



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


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">
    xs:schemaLocation="http://developer.cognos.com/schemas/xmldata/1/ xmldata.xsd"
          <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"/>

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?