I need to build a weekly report/search/something that gives me a view into our Vendor Bills this year. I need to see this by department and include the original Bill amount, payment amount, and remaining amount. The problem is that the payment amount is at the header level and the department is at the line level. So now I'm getting a blank amount paid, not to mention the obvious problems with the amount remaining.

Any suggestions would be helpful.

Right now criteria is set to this year, department X, main line false
Results are Date, doc Number, department, type, vendor:name, status, memo(main), amount. These have been grouped