Databand stops filtering data when record count is more than 5000 records
Posted: Fri Jul 17, 2020 11:52 am
Hi Team,
I am using a DataBand in StimulSoft report. Stimulsoft report plugin is integrated in our Web Application and we design the reports through our application's UI. This report is connected to a data source and DataBand is connected to a table.
Problem Statement: Data source Table row count to which databand is connected, if it goes beyond 5000 records, then filter doesn't work, report doesn't load and throws an error "There are too many records returned. Please refine the filter criteria". Please see attached the screenshot.
When the number of records in the underlying table is less than 5000 records, filter works fine and report gets loaded successfully.
Version of Stimulsoft Dlls that we are referencing is 2019.1.1.0, please refer attached screenshot showing the dlls that we are using.
Could you please assist us here. Please let us know if you need any other information.
Thanks,
Shoaib
I am using a DataBand in StimulSoft report. Stimulsoft report plugin is integrated in our Web Application and we design the reports through our application's UI. This report is connected to a data source and DataBand is connected to a table.
Problem Statement: Data source Table row count to which databand is connected, if it goes beyond 5000 records, then filter doesn't work, report doesn't load and throws an error "There are too many records returned. Please refine the filter criteria". Please see attached the screenshot.
When the number of records in the underlying table is less than 5000 records, filter works fine and report gets loaded successfully.
Version of Stimulsoft Dlls that we are referencing is 2019.1.1.0, please refer attached screenshot showing the dlls that we are using.
Could you please assist us here. Please let us know if you need any other information.
Thanks,
Shoaib