Report not able to load heavy data

Stimulsoft Reports.JS discussion
Post Reply
ash22
Posts: 3
Joined: Mon Jan 28, 2019 5:54 am

Report not able to load heavy data

Post by ash22 »

Hi
I am facing a problem with loading heavy data. I am using JS version to render data on the report.
I have made many changes to the report i.e. simplify the queries, added indexing on fields but still, it is not working.
I have 12000 records to render, it is working fine with 5000 records.
I am attaching the file and suggest to me if I am doing anything wrong.
Attachments
AttendanceByRegTotalCredits4.mrt
(23.63 KiB) Downloaded 140 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Report not able to load heavy data

Post by HighAley »

Hello, Ashish.

The JS report engine is very limited since it works in a browser.

We see may columns in the data sources, also we the calculated columns.
You could change your SQL query and move all calculations there.
Also, remove all unused columns.

Base on your report template you should get a simple list report with one data band and 13 columns.
It will minify a load on our engine.

Thank you.
Post Reply