Project Code report

Hi im having problems creating a Project Code Report, in one in SAP Business One is good, but i would like to see the account name beside the Account code and omitt certain codes i.e. sales etc - this i can do by the Where statement (T1.Segment_0 < [%1] which im happy enough with.

im having problems in the Query Generator.

I cannot get the Debit and Credit to total up and cannot seem to group by Project Code.

Any help in this matter, would be appreciated.