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.