Display clob xml from oracle into crystal report

Hi, i have a xml based clob column in an oracle table.i need to fetch multiple xml rows from the table each containing below xml, extract 30-35 tags out and display in crystal report and export it as excel.pls help.primarily i need to be able to export the crystal report in excel format.I can do the extraction of data via query...but is there any ready made option of xml to excel in crystal report? Finally how to export the report to excel format?


How to fetch oracle cursor containing few varchar columns and 1 clob column containing xml in c#.
And parse the xml received to get few specific nodes.I want to parse on C# asp.net as db is taking too long.
The xml is as given below:

<?xml version="1.0" encoding="UTF-8"?>
<tns:Envelope xmlns:acc="urn:com:COMPANY:accounts" xmlns:bme="http://ibbus.COMP.com/2009/bus-message-envelope" xmlns:dsc="urn:com:COMPANY:remittance" xmlns:enrich="urn:com:COMPANY:FINALHUB:enrichment" xmlns:fxpm="urn:com:COMPANY:usrouter:fxpm" xmlns:isoPmtStsRpt="urn:iso:std:iso:20022:tech:xsd:pacs.002.001.03" xmlns:ns11="urn:com:COMPANY:FINALHUB:eodp" xmlns:ns7="urn:com:COMPANY:FINALHUB:bankrefdata" xmlns:ns8="urn:com:COMPANY:usrouter:tms" xmlns:pain="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02" xmlns:phub="urn:com:COMPANY:FINALHUB" xmlns:tns="http://www.w3.org/2003/05/soap-envelope" bme:version="1-0">
              <bme:From type="http://ibml.COMP.com/coding-scheme/bmesystem">FINALHUB</bme:From>
              <bme:To type="http://ibml.COMP.com/coding-scheme/bmesystem">PRPC</bme:To>
                           <bme:Schema location="FINALHUB-v1-3.xsd" namespace="urn:com:COMPANY:FINALHUB" version="1-1"/>
              <phub:Message version="1-3">
                           <phub:Disclosures version="1-0">
                                                       <dsc:TrfrCcyAmt Ccy="USD">12345.00</dsc:TrfrCcyAmt>
                                                       <dsc:FeeCcyAmt Ccy="USD">0.00</dsc:FeeCcyAmt>
                                                              <dsc:Amt Ccy="USD">0.00</dsc:Amt>
                                                       <dsc:TotalCcyAmt Ccy="USD">12345.00</dsc:TotalCcyAmt>
                                                       <dsc:TrfrCcyAmt Ccy="USD">12345.00</dsc:TrfrCcyAmt>
                                                       <dsc:FeeCcyAmt Ccy="USD" Estimated="false">9.85</dsc:FeeCcyAmt>
                                                       <dsc:TotalCcyAmt Ccy="USD" Estimated="false">12335.15</dsc:TotalCcyAmt>
                                                <dsc:Nme>BARCLAYS BANK PLC</dsc:Nme>
                                         <dsc:DsclmrInfo lang="English">
                                                <dsc:Ustrd><![CDATA[The recipient may receive less due to fees charged by the recipient's bank and foreign taxes.]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[In the event you provide an incorrect account number or recipient institution identifier, you could lose the transfer amount.                                                                           ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[You can cancel for a full refund within 30 minutes of payment, unless the funds have been picked up or deposited. You have a right to dispute errors in your transactions.                              ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[If you think there is an error, contact us within 180 days at 212 of http://www.vvv.com You can also contact us for a written explanation of your rights.                            ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[For questions or complaints about Bessemer Trust contact: Consumer Financial Protection Bureau  (TTY/TDD) (855)729-2372 http://www.vvv.gov.]]></dsc:Ustrd>
                                         <dsc:DsclmrInfo lang="Spanish">
                                                <dsc:Ustrd><![CDATA[El beneficiario podría recibir menos dinero debido a las comisiones cobradas por el banco del beneficiario e impuestos extranjeros.]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[Puede cancelar el envío y recibir un reembolso total dentro de 30 minutos de haber realizado el pago, a no ser que los fondos hayan sido recogidos o depositados.                                       ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[Los fondos pueden recibirse previo a la fecha indicada arriba.                                                                                                                                          ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[Números de cuenta o código SWIFT BIC incorrectos pueden causar que el remitente pierda la cantidad de la transferencia. Verifique esta divulgación cuidadosamente.                                      ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[Usted tiene el derecho de discutir errores en su transacción. Si cree que hay un error, contáctenos dentro de 180 días al 14999 o www.vvv.com.                                        ]]></dsc:Ustrd>
                                                <dsc:Ustrd><![CDATA[También puede contactarnos para obtener una explicación escrita de sus derechos.                                                                                                                        ]]></dsc:Ustrd>
                                                <dsc:Nme>Consumer Financial Protection Bureau</dsc:Nme>
                                                       <dsc:AddressLine>1-1112 (TTY/TDD)  </dsc:AddressLine>
                                                              <dsc:CountryName> </dsc:CountryName>
                                         <dsc:OrgRmtInfo version="0-8">
                                                                     <dsc:CountryName>United States</dsc:CountryName>
                                                       <dsc:DbtCcyAndAmt Ccy="USD">12345</dsc:DbtCcyAndAmt>
                                                                     <dsc:CountryName>United States</dsc:CountryName>
                                                       <dsc:CrdtCcyAndAmt Ccy="USD">0</dsc:CrdtCcyAndAmt>
                                                       <dsc:TrfrFeeCcyAmt Ccy="USD">0</dsc:TrfrFeeCcyAmt>
                                                              <dsc:Amt Ccy="USD">0</dsc:Amt>
                                                       <dsc:Ustrd>UserId: U0914-62933 | Corpid: CHASESRV | UserName: QATestone  QAtestone</dsc:Ustrd>
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DevildibAuthor Commented:
Pls ignore below section from above questioni am sorry.it was a copy paste error.
Pls consider everything except below section from above.

How to fetch oracle cursor containing few varchar columns and 1 clob column containing xml in c#.
And parse the xml received to get few specific nodes.I want to parse on C# asp.net as db is taking too long.
The xml is as given below:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DevildibAuthor Commented:
Closing this one
slightwv (䄆 Netminder) Commented:
If the end-game is Excel, why involve Crystal Reports at all?

I use OpenXML with .Net to get data from Oracle into an xlsx file.


As far as parsing, I covered that in your previous questions:
I would probably start with LINQ.

There are MANY LINQ examples out there:

Since you only want 4 nodes, LINQ might be overkill but the other method is using the older XPATH stuff and probably not any faster.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.