Please Help, Askquestions Xml Questions

Home Tutorialhelp Comment Please help

Comment

Tom

Please help,
December 2, 2009 at 8:57 PM

Hello,
I have a crosstab in a report and I have to take the XML for that crosstab and then it will be read by flex. The issue is the XML format I am getting from the reporting tool is not the one compatible with flex. so I need to change the way it is gertting displayed in XML.
Below is the XML file --
<?xml version="1.0" encoding="UTF-8"?>
<Report TotalPage="1" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="dcTenureDtlByAgeSummary_report1.xsd">
<Page id="1">
<ReportBody>
<Paragraph></Paragraph>
<CTCrossTab>
<PUT_TENURE_DETAIL_CODE>1 - < 3 Years</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>11 - < 16 Years</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>16 - < 21 Years</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>21 years and Over </PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>3 - < 6 Years</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>3 - < 7 Months</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>6 - < 11 Years</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>7 - < 12 Months</PUT_TENURE_DETAIL_CODE>
<PUT_TENURE_DETAIL_CODE>Under 3 Months</PUT_TENURE_DETAIL_CODE>
<PUT_AGE_SUMMARY_CODE>45 - < 55 Years</PUT_AGE_SUMMARY_CODE>
<NAME7>.01</NAME7>
<NAME7>.06</NAME7>
<NAME7>.03</NAME7>
<NAME7>.01</NAME7>
<NAME7>.02</NAME7>
<NAME7>.00</NAME7>
<NAME7>.09</NAME7>
<NAME7></NAME7>
<NAME7></NAME7>
<PUT_AGE_SUMMARY_CODE>45 Years and Under</PUT_AGE_SUMMARY_CODE>
<NAME7>.08</NAME7>
<NAME7>.12</NAME7>
<NAME7>.02</NAME7>
<NAME7>.01</NAME7>
<NAME7>.09</NAME7>
<NAME7>.01</NAME7>
<NAME7>.22</NAME7>
<NAME7>.00</NAME7>
<NAME7>.00</NAME7>
<PUT_AGE_SUMMARY_CODE>55 - 60 Years</PUT_AGE_SUMMARY_CODE>
<NAME7>.01</NAME7>
<NAME7>.02</NAME7>
<NAME7>.01</NAME7>
<NAME7>.00</NAME7>
<NAME7>.01</NAME7>
<NAME7>.00</NAME7>
<NAME7>.03</NAME7>
<NAME7></NAME7>
<NAME7></NAME7>
<PUT_AGE_SUMMARY_CODE>Over 60 Years</PUT_AGE_SUMMARY_CODE>
<NAME7>.01</NAME7>
<NAME7>.03</NAME7>
<NAME7>.01</NAME7>
<NAME7>.01</NAME7>
<NAME7>.02</NAME7>
<NAME7></NAME7>
<NAME7>.06</NAME7>
<NAME7>.00</NAME7>
<NAME7>.00</NAME7>
</CTCrossTab>
<Paragraph1>
<TextSegment1> </TextSegment1>
</Paragraph1>
</ReportBody>
</Page>
</Report>

So basically tehre are three elements - For every Put tenor detail code... the data is separated out for the put age summary code.. and the name7 is the percent of people who lie in that range... the XSD for the above file is ---

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema attributeFormDefault="qualified" elementFormDefault="qualified" version="1.1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:notation name="TYPE" public="ResultToXML"></xs:notation>
<xs:element name="CTCrossTab">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element maxOccurs="unbounded" ref="PUT_TENURE_DETAIL_CODE"></xs:element>
<xs:element maxOccurs="unbounded" ref="PUT_AGE_SUMMARY_CODE"></xs:element>
<xs:element maxOccurs="unbounded" ref="NAME7"></xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="NAME7">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute default="RenderText" name="render" type="xs:string"></xs:attribute>
<xs:attribute default="true" name="DBField" type="xs:boolean"></xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Page">
<xs:complexType>
<xs:sequence>
<xs:element ref="ReportBody"></xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:unsignedInt" use="required"></xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="Paragraph">
<xs:complexType></xs:complexType>
</xs:element>
<xs:element name="Paragraph1">
<xs:complexType>
<xs:sequence>
<xs:element ref="TextSegment1"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PUT_AGE_SUMMARY_CODE">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute default="RenderText" name="render" type="xs:string"></xs:attribute>
<xs:attribute default="true" name="DBField" type="xs:boolean"></xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="PUT_TENURE_DETAIL_CODE">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute default="RenderText" name="render" type="xs:string"></xs:attribute>
<xs:attribute default="true" name="DBField" type="xs:boolean"></xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="Report">
<xs:complexType>
<xs:sequence>
<xs:element ref="Page"></xs:element>
</xs:sequence>
<xs:attribute name="TotalPage" type="xs:unsignedInt" use="required"></xs:attribute>
<xs:attribute name="version" type="xs:decimal" use="required"></xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="ReportBody">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="Paragraph"></xs:element>
<xs:element ref="CTCrossTab"></xs:element>
<xs:element ref="Paragraph1"></xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="TextSegment1">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute default="DSParagraphText" name="Type" type="xs:string"></xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:schema>

I want to change this XSD so that the data in XML file as desired.
I cant explain it here in detail but maybe if we talk about it in detail I can explain.

Please help!
View All Comments | View Tutorial