Large data set producing blank report
Posted: Mon May 22, 2017 1:54 pm
Hello,
My company is using Stimulsoft reports suite for dynamic reporting. Currently, we're using version 2015.3.0.0.
This has been fine until a customer reported receiving a blank report when selecting certain items. We typically restrict the dataset to 1000 rows but this time they selected a large subset. In testing this behavior, I ran a request for a report using 11,000 - 14,000 rows and successfully reproduced the behavior.
Long story short, our code seems to be working fine. The data is accurately queried and returned. However, the following 2 lines seem to be the problem:
When running the above with 1000 or less records, it's working just fine. Large subsets seem to be the problem.
I employed some google magic and surprisingly didn't find a lot of results for this. One issue seemed nearly identical and suggested the following properties on the aspx definition:
No result.
My initial guess would be that the version of Stimulsoft we're using is just running out of memory when trying to process this subset. But I'm not entirely sure as no errors are warnings are being thrown. Any assistance on this matter would be appreciated.
Lastly, while an upgrade to the latest version is absolutely possible, I would prefer to try and get this bug resolved by itself before embarking on that journey.
Initial efforts to upgrade have been... tedious, to say the least.
My company is using Stimulsoft reports suite for dynamic reporting. Currently, we're using version 2015.3.0.0.
This has been fine until a customer reported receiving a blank report when selecting certain items. We typically restrict the dataset to 1000 rows but this time they selected a large subset. In testing this behavior, I ran a request for a report using 11,000 - 14,000 rows and successfully reproduced the behavior.
Long story short, our code seems to be working fine. The data is accurately queried and returned. However, the following 2 lines seem to be the problem:
Code: Select all
report.RegData("tableName",dtAD);
report.Dictionary.Synchronize();
When running the above with 1000 or less records, it's working just fine. Large subsets seem to be the problem.
I employed some google magic and surprisingly didn't find a lot of results for this. One issue seemed nearly identical and suggested the following properties on the aspx definition:
Code: Select all
ClientRequestTimeout="240"
CacheItemPriority="Normal"
ServerTimeout="00:30:00"
My initial guess would be that the version of Stimulsoft we're using is just running out of memory when trying to process this subset. But I'm not entirely sure as no errors are warnings are being thrown. Any assistance on this matter would be appreciated.
Lastly, while an upgrade to the latest version is absolutely possible, I would prefer to try and get this bug resolved by itself before embarking on that journey.
Initial efforts to upgrade have been... tedious, to say the least.