Report w/o multiple ship costs

[stattech]

I am trying to make a sales summary rewport.



Each Invoice has an associated shipping expense and may have several lineitems. In a summary report, how can I prevent the 'sum of shipping' from being tabulated for each 'Qty*Sell Price' instead of only once per invoice#?

Thanks

[stattech]

I am trying to make a sales summary rewport.

Each Invoice has an associated shipping expense and may have several lineitems. In a summary report, how can I prevent the 'sum of shipping' from being tabulated for each 'Qty*Sell Price' instead of only once per invoice#?

Thanks

I have attached the report design in case anyone can make sense of my problem.

Would appreciate your help.

Thanks!