Load data report from xml file

[felipemoreira]

Hi.
I have a report with datasource named "Names", with 2 fields: "name" and "age".
Read json file files works but xml don´t.

My xml file:

Code: Select all

<Names>
   <name>Agencia 1</name>
    <age>2</age>
</Names>

It shows a blank report.
I'm sure that my xml file is not on format expected.

Thanks!

[HighAley]

Hello.

Please, send us a sample with JSON and XML files where we could see all described above.

Thank you.

[felipemoreira]

Hi HighAley.

My json data:

Code: Select all

{
    "Names": [{
        "name": "john",
        "age" : 30
    }, {
        "name": "Abel",
        "age" : 23
    }, {
        "name": "Joe",
        "age" : 34
    }, {
        "name": "Joseph",
        "age" : 12
    }]
}

My xml data:

Code: Select all

<Names>
      <name>Agencia 1</name>
       <age>2</age>
</Names>

My code to load json data:

Code: Select all

var report = new Stimulsoft.Report.StiReport();
var dataSet = new Stimulsoft.System.Data.DataSet("SimpleDataSet");
dataSet.readJsonFile("data/namejson.json");
report.regData(dataSet.dataSetName, "", dataSet);
report.loadFile("js/Names.mrt");
var viewer = new Stimulsoft.Viewer.StiViewer(null, "StiViewer", false);
viewer.report = report;
viewer.renderHtml("report_designer");

My code to load xml data:

Code: Select all

var report = new Stimulsoft.Report.StiReport();
var dataSet = new Stimulsoft.System.Data.DataSet("SimpleDataSet");
dataSet.readXmlFile("data/port_xml.xml");
report.regData(dataSet.dataSetName, "", dataSet);
report.loadFile("js/Names.mrt");
var viewer = new Stimulsoft.Viewer.StiViewer(null, "StiViewer", false);
viewer.report = report;
viewer.renderHtml("report_designer");
report.dictionary.databases.clear();

Follow my report attached.

Thanks.

[felipemoreira]

Follow xml file as datasource attached.

[Ivan]

Hello,

The JS has no native support for the XML format, so we ported simple implementation from the Net.
Therefore, the XML file must have the DataSet name element as the root element.
Please modify your XML-file:

Code: Select all

<DataSetName>
	<Names>
		<name>Agencia 1</name>
		<age>2</age>
	</Names>
</DataSetName>

Thank you.

[felipemoreira]

It worked, thanks Ivan.

[Andrew]

Hello,

Thank you for letting us know about this.

Have a nice day!