Answers.Body: <p>This is because of full group by mode. I feel the latest version of CiviCRM group bys with fields that are mentioned in sort by(order by). Try after clearing the sorting fields. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-18T04:17:49.720Z
Answers.Text: So can we close this as answered?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-17T19:25:03.547Z
Answers.LastActivityDate: 2018-05-17T19:25:03.547Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>The Extended report  Line Item report for price sets was working perfectly fine till recently. </p>
  
  <p>Now the last line is concatenating all first name and last names.  See Screenshot
  <a href="https://i.sstatic.net/GpXO9.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/GpXO9.png" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-18T00:37:17.927Z
Comments.Text: Pradeep's solution worked as outlined below This is because of full group by mode. I feel the latest version of CiviCRM group bys with fields that are mentioned in sort by(order by). Try after clearing the sorting fields.
Comments.UserDisplayName: Vish Ramakonar
Tags: <civireport>
Title: Extended Report - Line Item report for price sets final line concatenating all records
ThreadText: # Extended Report - Line Item report for price sets final line concatenating all records
  
  (Asked by: username_0 on 2018-05-17)
  
  The Extended report Line Item report for price sets was working perfectly fine till recently.
  
  Now the last line is concatenating all first name and last names. See Screenshot
  [![enter image description here](https://i.sstatic.net/GpXO9.png)](https://i.sstatic.net/GpXO9.png)
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_0**: Pradeep's solution worked as outlined below This is because of full group by mode. I feel the latest version of CiviCRM group bys with fields that are mentioned in sort by(order by). Try after clearing the sorting fields.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-05-17. Score: 2 | Accepted answer
  
  This is because of full group by mode. I feel the latest version of CiviCRM group bys with fields that are mentioned in sort by(order by). Try after clearing the sorting fields.
  
  > **Comments:**
  > **username_1**: So can we close this as answered?  
  
  ---
  
  