Creating reports and dashboards | Stimulsoft community forum

I hope someone can help us.

We have issues rendering a report with a JSON file.

We have an API that requests information from a DB with MariaDB; the API waits until the result and then transforms the data into a JSON format.

When the API is finished, send the file to the report, and Stimulsoft does his job, but in this case it never ends because the size of the file is 300 MB, and my computer (using the designer) and any explorer (Chrome, Edge, Firefox, Opera...) after 1 hour or more, depending on the RAM, get out of memory.

So I decide to run tests on my computer.

Windows 10
Core i7
32 RAM

Case 1
File: json
Size: 301 MB

Results

a) It takes 20 minutes to load the file.
b) Then the preview—after 30 minutes the RAM is released, and the report just shows the design without data.

Case 2
File: CSV
Size: 80 MB (We transform the 300 MB JSON file into an 80 MB CSV file.

Results

a) It took less than 1 minute to load the file.
b) Then the preview took 25 min (a better result).

Case 3

MariaDB connection

Results

a) The database resolves the SQL in 2 minutes
b) Rendering the report took 1 hour, and for some reason the connection is released after the report shows all pages (I don't know why).

All tests were because our customers came from an old system with Crystal Reports integrated; this old system used Interbase (2009) and Crystal Reports v8 (2000).

The JSON and CSV files contain 337321 rows.

Fisrt test rendering 337321 rows in Crystal Reports took 3 minutes, so I made a second test with 573545 rows, and the result took 9 minutes.

Is there another option to show it quickly?

I attached a ZIP file that contains:
1. JSON and CSV reports.
2. CSV and JSON files

Hello,

Please send also data_item_categories.json file.

Also, please clarify which version you are using. And try to check the last release build.

Thank you.

Of course, sorry for that

Hello,

In the JS version, we are recommended to split it into several parts and then merge in one:
https://github.com/stimulsoft/Samples-R ... 20One.html

Thank you.

Hello,

We ran a test splitting our file, but we got the same result and others' observations, for example.

Two splits with 1000 rows each one.

Both reports render 4 pages; after the merge, the page number was reset to 1 of 4 when reaching the last page. It's because we created two reports and then merged them, but our report has 3 levels of groups. Imagine if we grouped the information by brand; the result would be two results: one total in the last page of the first report and the second total in the last page of the second report.

Hello,

Rendering your report, for example, in Node.JS takes about 30 seconds, and then you can open the saved MDC file in the viewer.

Thank you.