Creating reports and dashboards | Stimulsoft community forum

Hello

I have prepared a report with data from Api in json format. It works. Now I would like to feed the report with this data, but I want to provide the path from the code.
I tried the following:

String reportPath = context.getRealPath("/reports/report.mrt");
StiReport report = StiSerializeManager.deserializeReport(new File(reportPath));

report.getDictionary().clear();
StiJsonDatabase db = new StiJsonDatabase();

db.setPathData("https://abc.pl:1091/api/printdata");

report.getDictionary().getDatabases().add(db);
report.getDictionary().connect();

System.out.println(report.getDictionary());

report.render();
StiWebViewerOptions options = new StiWebViewerOptions();
options.getToolbar().setZoom(97);
options.getToolbar().setViewMode(StiWebViewMode.SinglePage);

return new ReportViewerOptions(report, options);

It doesn't work.
what's wrong?

Hello

You should setup Database name
is not necessary

It still doesn't work.

In designer when I manually add data I get dialog window 'select data': :

After I have:
I think the problem is that I don't do 'select data' when I add data in the code

I saw in debuger I have no info in dataSource about my data. How add (register) data into dataSource

I solved the problem. I replaced path data in databese object:

StiJsonDatabase db = (StiJsonDatabase)report.getDictionary().getDatabases().get("data-test");
db.setPathData("https://abc.pl:1091/api/printdata/id/5");

Thank's

Hello,

Thank you for the information.