Creating reports and dashboards | Stimulsoft community forum

Hello everyone,
I am currently working with Stimulsoft Reports.WEB in an ASP.NET Core environment and have encountered several challenges related to performance and dynamic data binding.
My setup involves generating reports with large datasets (100k+ records) using a combination of business objects and SQL data sources. How can I efficiently handle large datasets (100k+ records) and implement dynamic runtime data source switching in Stimulsoft Reports.WEB (ASP.NET Core) while avoiding performance degradation and slow PDF export without having to rebuild the report template each time?

Handling large datasets in Stimulsoft Reports.WEB can get heavy quickly, so instead of loading 100k+ records directly into the report, it’s better to implement server-side filtering, paging, or aggregation before binding the data. Using SQL queries or stored procedures to return only the needed subset can significantly improve performance and PDF export speed. For dynamic data source switching, you don’t need to rebuild the template—just swap the data source at runtime via code (e.g., updating the report’s Dictionary or BusinessObjects and calling RegData again), then re-synchronize without reloading the full template. Also consider enabling caching and optimizing report components (like limiting heavy bands or images) to reduce rendering overhead.

Hello,

Also, please see the following articles:
https://www.stimulsoft.com/en/blog/arti ... ng-reports
https://www.stimulsoft.com/en/blog/arti ... rts-part-2
https://www.stimulsoft.com/en/blog/arti ... rts-part-3

Thank you.