Is there a column limit on reports?
I had a user create a report with many columns (about 50). There were no filters on the report. They received this error when trying to run the report:
After removing several columns they were able to run the report successfully with the expected number of rows returned (~2500).
Is there a maximum number of columns that someone can add to a report?
Thank you!
Asked by Mariah Rible
on Wed 12/4/24 5:26 PM
Sign In to leave feedback or contribute an answer
Answer (1)
This answer has been marked as the accepted answer
Mark Sayers
Thu 12/5/24 8:40 AM
Hello Mariah,
There is a cell limitation on how many cells the system will return. Likely that is what you were running into prior to trimming down the columns used in the report.
Sincerely,
Mark Sayers
Sr Support Consultant, CS
No feedback
It has more to do with the max request size of setting all the columns in the report. In this case though, I asked internally and we believe this report is/was trying to return bad data. Commonly when we've seen this error it is when a custom attribute has been changed from a multi to a single select. Could that have been the case?
- Mark Sayers
Thu 12/5/24 9:49 AM