Reports 2.0: Allow for more than 2000 rows in a table
CS Reports & Dashboards
Reports appear to have a 2000 row limit when displaying a table which prevents valuable information being displayed on a dashboard. Why is there a limit? Any downside to making it unlimited?
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Increasing the limit can have performance implications as multiple reports are loaded in a dashboard, which can lead to timeouts. How often do you come across this limitation? Will providing an export to CSV option solve your use case? Please let me know.
Thanks,
Sumesh
For example, I may build a report that has 5000 rows, and when it displays, I see only the first 2000 rows. I wish there was a notation that my report is truncated. This avoids confusion we have encountered whereby we *thought* a report was complete and tried to apply a filter to surface data we know is in the report. Because the data we sought was beyond the first 2000 rows, our filtering didn't find what we were looking for, and it took us forever to figure out this was due to a truncated report.
Until the balance between performance and display can be solved, a great interim step would be to add a notation to a report when it has been truncated to 2000 rows on-screen.
The first 2000 rows can be returned initially, but the user should have the option to get the full data set.
thanks
Kristin
Just so that i understand, for what type of reports do you use UI views? Except for the scorecard mass edit views, you should be able to build all UI view reports in report builder. Please let me know if that's not the case.
Thanks,
Sumesh
thanks for responding. The UI View in question is one that was created by our project manager Bryan. It is for our sales people looking for specific customers who have many different combinations of criteria...a specific location, product, number of employees, referenceable, etc, etc. I had asked in the past about using report builder for this, but Bryan said that using report builder takes away the ability of using 'or' in our searches. Which is important for the search functionality.
Thanks!
~Anne
Adding to this.. even though the report UI shows 2000 also the export to excel gives me only 2000. So really this is a HUGE limitation!
I would really want this to be a P1 especially as we are growing our adoption in our organisation quickly now.
Thanks
Naquiyah
In feb release, following changes will be implemented.