Contact Centers, CRM Customer Engagement

 View Only

  • 1.  REPORT DESING ON CMS

    Posted 01-09-2020 04:28 PM
      |   view attached
    HEllo,

    Today i was trying to get a custom report working (report designer), but this didn't work. All the time i recieved  a "the column must be in GROUP BY List" error.

    I only get this error when i try to make a report from scratch. Not form the wizard and the a blank template.

    What should i do to prevent this error.

    The database items where:

    dsplit.ACDCALLS
    dsplit.ACWTIME
    dsplit.ACDTIME
    I didn't make any changes at the "WHERE"

    Why do i get the group by error? I tryed.... GROUP BY ACDCALLS,
    GROUP BY ACWTIME
    etc
    etc

    Sorry for the bad English

    ------------------------------
    Oscar Emilio Muñoz Gonzalez
    Ingeniero Telematico
    WalterBridge
    ------------------------------


  • 2.  RE: REPORT DESING ON CMS

    Posted 01-13-2020 09:13 AM
    ​We would need the entire query to be able to troubleshoot it. My best guess without seeing the query is that you do not have the SELECT and GROUP BY clauses of your query built correctly. If you make changes at the start (SELECT) of the query, you have to also make changes in the rest of the query. What changes are needed are dependent upon your SELECT and FROM clauses.

    ------------------------------
    John Williams
    Architect, Voice
    Maximus
    Albany NY
    ------------------------------

    Original Message


  • 3.  RE: REPORT DESING ON CMS

    Posted 01-13-2020 09:54 AM 
    hi John, could you send me the designed report and help me validating the query?


    ------------------------------
    Oscar Emilio Muñoz Gonzalez
    Ingeniero Telematico
    WalterBridge
    ------------------------------

    Original Message


  • 4.  RE: REPORT DESING ON CMS

    Posted 01-13-2020 10:11 AM
    ​I would not be able to send you the report you're trying to create. Un poquito hablo español.

    But if you send me the query, I would be willing to help you look for the cause of the error.

    I think the most likely cause is that your SELECT and GROUP BY clauses do not reference the same columns. This is a common problem in multiple SQL interpreters.

    Do all columns in a SELECT list have to appear in a GROUP BY clause

    I could be wrong. I would need to see the query to know for sure.

    ------------------------------
    John Williams
    Architect, Voice
    Maximus
    Albany NY
    ------------------------------

    Original Message


  • 5.  RE: REPORT DESING ON CMS

    Posted 01-13-2020 10:24 AM
    I send you the cms report, the only thing I want to achieve is that in the detail of the days when I consult two Skill the one in a single line by date

    ------------------------------
    Oscar Emilio Muñoz Gonzalez
    Ingeniero Telematico
    WalterBridge
    ------------------------------

    Original Message