Prefacing that I believe the larger issue here is table design; however, that's not something I can fix at the moment.
Here is an example:
Correct me if I'm wrong, but if I'm generating a report by line item, then I really need the query to have one row per item. Otherwise, the report won't know how to handle that.
So, to accomplish this, I need each row with TIMB as the EdbSpc gone; but the data from the TIMB rows placed in the first row.
Thanks