Page 1 of 1
multi json datasets from ajax request in PHP report
Posted: Wed Mar 01, 2023 8:28 pm
by SigmaOne
Hello :
I am using multi json datasets from ajax request in PHP report the report appears empty on databand but when I use one dataset it works normally
Re: multi json datasets from ajax request in PHP report
Posted: Fri Mar 03, 2023 3:44 pm
by Lech Kulikowski
Hello,
Please send us a sample that reproduces the issue for analysis.
Thank you.
Re: multi json datasets from ajax request in PHP report
Posted: Sat Mar 04, 2023 9:35 pm
by SigmaOne
var report = new Stimulsoft.Report.StiReport();
var dataSet1 = new Stimulsoft.System.Data.DataSet("table_1");
var dataSet2 = new Stimulsoft.System.Data.DataSet("table_2");
dataSet1.readJson(<?php echo ($DataSource->GetData1ById($fin_app_id)); ?>);
dataSet2.readJson(<?php echo ($DataSource->GetData2ById($fin_app_id)); ?>);
report.loadFile("../reports/mrt_files/rpt_101.mrt");
report.dictionary.databases.clear();
report.regData("json", "table_1", dataSet1);
report.regData("json", "table_2", dataSet2);
report.dictionary.synchronize();
viewer.report = report;
function onLoad() {
viewer.renderHtml("viewerContent");
}
when I view the report it show blank databand but when I delete table_2 it run normally
Re: multi json datasets from ajax request in PHP report
Posted: Mon Mar 06, 2023 9:22 pm
by Lech Kulikowski
Hello,
Also, please send your report for analysis.
Thank you.
Re: multi json datasets from ajax request in PHP report
Posted: Wed Mar 08, 2023 7:43 pm
by SigmaOne
hello this sample of of requested files
Re: multi json datasets from ajax request in PHP report
Posted: Thu Mar 09, 2023 10:04 pm
by Lech Kulikowski
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
Re: multi json datasets from ajax request in PHP report
Posted: Thu Mar 09, 2023 10:06 pm
by SigmaOne
hello
I am waiting
thanks for replying
Re: multi json datasets from ajax request in PHP report
Posted: Mon Mar 13, 2023 10:35 pm
by Lech Kulikowski
Hello,
Please check the following code:
report.dictionary.databases.clear();
report.dictionary.dataSources.clear();
report.regData("json", "json", dataSet1);
report.regData("json", "json", dataSet2);
report.dictionary.synchronize();
Thank you.