ygonzales Free User Basic Certified Joined Nov 3, 2016 Messages 27 Reaction score 0 Nov 14, 2016 #1 Dear Team, When trying to generate big reports there is an error: * Report not generated in full because query contains too many records. just interested what is this
Dear Team, When trying to generate big reports there is an error: * Report not generated in full because query contains too many records. just interested what is this
YiannisH_3CX Support Team Staff member 3CX Support Joined May 10, 2016 Messages 11,797 Reaction score 1,779 Nov 14, 2016 #2 Hello there, Please note that the maximum lines of a report is 10000. Anything longer than that will present you with this error.
Hello there, Please note that the maximum lines of a report is 10000. Anything longer than that will present you with this error.
ygonzales Free User Basic Certified Joined Nov 3, 2016 Messages 27 Reaction score 0 Nov 14, 2016 #3 So,if i need more than 10000. is there any thing i can set like as 20000 or even maybe * ?
XanthiZ_3CX Staff member Joined Dec 18, 2015 Messages 42 Reaction score 6 Nov 15, 2016 #4 Hello ygonzales In order to change the Report row limit you need to do the following: 1) Go to Settings > Parameters 2) Search for the parameter REPORT_ROW_LIMIT 3) Edit the parameter and change the limit from 10000 to 20000 and press OK 4) Restart Services If you have any questions please let me know
Hello ygonzales In order to change the Report row limit you need to do the following: 1) Go to Settings > Parameters 2) Search for the parameter REPORT_ROW_LIMIT 3) Edit the parameter and change the limit from 10000 to 20000 and press OK 4) Restart Services If you have any questions please let me know
ygonzales Free User Basic Certified Joined Nov 3, 2016 Messages 27 Reaction score 0 Nov 15, 2016 #5 Thanks, Can you please also clarify in total talking: 2.07:17:46 what does this mean If i count normally in excel it comes up to 55 minutes but what does this number means
Thanks, Can you please also clarify in total talking: 2.07:17:46 what does this mean If i count normally in excel it comes up to 55 minutes but what does this number means