SQL report show result in one line of group
===

Hello I am trying to reach the follwoing result:

ID | Part | QTY| Boxes| Reference<br/>
1|ABC123|20|0 |REF0001<br/>
2|ABC345|10|0 |REF0001<br/>
3|ABC487|5 |1 |REF0001<br/>
4|SEF453|4 |0 |REF0002<br/>
5|ABDS12|82|4 |REF0002<br/>
6|EFR488|64|0 |REF0003<br/>
7|XCV345|58|0 |REF0003<br/>
8|SSFS33|23|3 |REF0003<br/>

Right now I get<br/>
ID | Part | QTY| Boxes| Reference<br/>
1|ABC123|20|1 |REF0001<br/>
2|ABC345|10|1 |REF0001<br/>
3|ABC487|5 |1 |REF0001<br/>
4|SEF453|4 |4 |REF0002<br/>
5|ABDS12|82|4 |REF0002<br/>
6|EFR488|64|3 |REF0003<br/>
7|XCV345|58|3 |REF0003<br/>
8|SSFS33|23|3 |REF0003<br/>

As you can see, the qty of boxes per reference repeat each row and i need to appear only one per reference.

