I am trying to group by information in Discoverer but results are not coming out as I expect.
Imagine this, we have sales orders, each sales order has many lines (items within the order). I want to group by orders, so each row will represent only the order number (without lines for each item).
To do that I am using the group sort option at the sales order number column, but yet the results are not getting grouped. Please see picture http://s12.postimg.org/b35pe46jx/Capture.png.
Try doing the report in Cross-Tab format.