I need to create an XML report. I have created a list report and when I run it as an XML report the data items come out as
<value>data item </value>
instead of ther column names
ex.
<ID>idnum</ID>
Is there some way I need to define the tags? The report also needs to have a section with the institution name and info, then another section with the employee info.
Ihave a couple of books but there is not much info in them about XML.
Thanks
Does anyone know how to do an XML report in Cognos?
Thanks
Is there single you are using or multiple quries you are asing to generate the XML report.
XML format doe not support for Charts , Multiple queries( in report page body, but you can have multiple quieries in prompt page support) and Maps"
Producing a Report in XML Format
XML report outputs save the report data in a format that conforms to an internal schema, xmldata.xsd. You can find this schema file in c8_location/bin.
This format consists of a dataset element, which contains a metadata element and a data element. The metadata element contains the data item information in item elements. The data element contains all the row and value elements.
You can create models from reports and other data that conform to the xmldata.xsd schema. This is useful if you want to use a report as a data source for another report, or if you use a database that cannot be read by Framework Manager. In this case, export the data from the data source to an XML file, in conformance with the xmldata schema, and then open the XML file in Framework Manager.
"
Best Regards,
Srinivas Kalyanapu
Thanks for your reply.