reports question

Discussion in '3CX Phone System - General' started by ygonzales, Nov 14, 2016.

Thread Status:
Not open for further replies.
  1. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    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
     
  2. YiannisH_3CX

    YiannisH_3CX Support Team
    Staff Member 3CX Support

    Joined:
    May 10, 2016
    Messages:
    5,456
    Likes Received:
    355
    Hello there,

    Please note that the maximum lines of a report is 10000. Anything longer than that will present you with this error.
     
  3. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    So,if i need more than 10000. is there any thing i can set like as 20000 or even maybe * ?
     
  4. XanthiZ

    3CX Support

    Joined:
    Dec 18, 2015
    Messages:
    46
    Likes Received:
    7
    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 ;)
     
  5. ygonzales

    Joined:
    Nov 3, 2016
    Messages:
    12
    Likes Received:
    0
    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
     
Thread Status:
Not open for further replies.