CRMFO SQL Reports: too much data & variables Answered
Hi Everybody
We sometimes have the problem that too much data is beeing reported by user defined SQL reports and an error message "data too big" appears.
Can somebody tell me what the maximum is so we can cap the reports.
Is there still no way to have the user pass a variable before hand?
Greetings
Paco
Comments
2 comments
I have moved this to the Question and Answer section as it is not a feature request
The limit is not a fixed set of rows or columns (as you might have many columns but few rows or vice versa) and in some cells of a report, you might show a simple name or number while in another you might have several pages of text.
Instead, the limit is 5.000.000 chars of JSON-data to send (if we made it bigger the transfer mechanism could not handle it; hence the limitation in the first place).
As for variable, it should be possible to use such already: See this link: https://help.boyum-it.com/crmfo/reportsgroup.html
Please sign in to leave a comment.