Creating reports and dashboards | Stimulsoft community forum

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?

Hello,

Please try to use the xml with following structure:

blabla
Street1
12345
NewYork
NY
Info@AZP.IT


And separately file schema.

Thank you.

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?

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.