Retrive value from xml

Girasole · Post by **Girasole** » Wed Nov 16, 2011 1:30 pm

Hello everyone!
I need to take some value from a xml file that has the follow structure:

COMPANY_NAME
blabla

COMPANY_ADDRESS
Street1

COMPANY_CAP
12345

COMPANY_CITY
NewYork

COMPANY_PROV
NY

COMPANY_EMAIL
Info@AZP.IT

When I try to create a new connection with Xml Data I cannot use the single value because the retrive columns are only FieldName and Fieldvalue and I cannot populate single fields of my report.
How can I do? Can someone help me, please?

Post by **Alex K.** » Thu Nov 17, 2011 1:39 am

Hello,

Please try to use the xml with following structure:

blabla
Street1
12345
NewYork
NY
Info@AZP.IT

And separately file schema.

Thank you.

Girasole · Post by **Girasole** » Thu Nov 17, 2011 3:23 am

Hi!
Unfortunatly I can't change the xml because it is automatically generated from a system that I use to do my report.
Other times I use that approach, but this one.....:dumb:
Is there another way?

Post by **Andrew** » Thu Nov 17, 2011 9:21 am

Hello,

For working with data, we use standard .NET tools, who are not able to work with data in this form.
You need in your application to handle this data and send them to the report.
For example, you can read this xml into dataset, convert table to other format, and then send this new table to the report via report.RegData (yourTable).

Thank you.