Post reply

Export to XML, Not getting desired format

  • May 14, 2012 at 5:43 am

    #255825

    Hi All,

    i am facing a problem while exporting report data to XML. i am not getting the desired format. my output should be

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

    <RenewalEdgeMessage MessageId="1348" MessageType="Integration Object" IntObjectName="Quote_For_B2B" IntObjectFormat="RenewalEdge Hierarchical">

    <ListOfQuoteForB2b>

    <Quote>

    <SoldToAccount>

    Arrow ECS Canada Ltd.

    </SoldToAccount>

    <SoldToAddressCity>

    Englewood

    </SoldToAddressCity>

    <SoldToAddressCountry>

    United States

    </SoldToAddressCountry>

    <SoldToAddressPostalCode>

    80112

    </SoldToAddressPostalCode>

    <SoldToAddressState>

    but after changing the dataelementoutput to "auto" and dataelementstyle to "element" i am getting this format.

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

    - <Report xsi:schemaLocation="QuoteDetailsForB2BXml http://reportserver?%2FQuoteDetailsForB2BXml&rs%3AFormat=XML&rc%3ASchema=True" Name="QuoteDetailsForB2BXml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="QuoteDetailsForB2BXml">

    - <ListOfQuoteForB2b>

    - <Details_Collection>

    - <Details>

    <QuoteNumberWithRevision>RE-QTE-ORE-202921-GEN-01</QuoteNumberWithRevision>

    <new_existingbilltoaddressidname>TIE - THE INFORMATION EXPERTS-PETACH TIKVA-7 MARTIN GEHL STREET</new_existingbilltoaddressidname>

    <CurrencyCode>US Dollar</CurrencyCode>

    <NetAppListPrice>4043.70</NetAppListPrice>

    <CommentstoCustomer>No Mapping</CommentstoCustomer>

    <QuoteExpirationDate>2012-04-07T00:00:00</QuoteExpirationDate>

    <QuoteName>QTE-ORE-202921-GEN-01</QuoteName>

    <DoNotShipBeforeRequestDate>No Mapping</DoNotShipBeforeRequestDate>

    <Opportunity>OPP-ORE-202921-GEN</Opportunity>

    <PartnerReseller>WE!</PartnerReseller>

    <PriceList>No Mapping</PriceList>

    <BillToAddressStreet>PO BOX 10340</BillToAddressStreet>

    <BillToAddressCity>PETACH-TIKVA</BillToAddressCity

    here some extra tag is coming, those are <Details_Collection>

    - <Details>

    i don't want these tags, how to remove these from the generated xml.

    any kind of help will be highly appreciated.

    thanks,

    Ghanshyam

  • May 14, 2012 at 7:06 am

    #1487081

    My guess is that you have a grouping in your report that is causing the details node.

  • May 15, 2012 at 7:36 am

    #1487674

    Thanks daniel for your reply,

    you are correct i was having row grouping in my report that's why details tag was coming, after removing grouping its disappears 🙂

    thanks..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply