Page 1 of 1
Load data report from xml file
Posted: Thu May 05, 2016 12:57 pm
by 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!
Re: Load data report from xml file
Posted: Fri May 06, 2016 11:15 am
by HighAley
Hello.
Please, send us a sample with JSON and XML files where we could see all described above.
Thank you.
Re: Load data report from xml file
Posted: Fri May 06, 2016 4:44 pm
by 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.
Re: Load data report from xml file
Posted: Fri May 06, 2016 4:48 pm
by felipemoreira
Follow xml file as datasource attached.
Re: Load data report from xml file
Posted: Mon May 09, 2016 11:14 am
by 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.
Re: Load data report from xml file
Posted: Tue May 10, 2016 6:03 pm
by felipemoreira
It worked, thanks Ivan.
Re: Load data report from xml file
Posted: Wed May 11, 2016 5:40 am
by Andrew
Hello,
Thank you for letting us know about this.
Have a nice day!