Regarding Sales order report help

Dear all Tdl experts,

I am trying to write one Report on Sales order Items Pending Report, here i don't need the order number based outstanding. i need aggregated qty total of pending Items.

Example :-

1. Item A 30pcs

2. Item B 40 kgs

here I have written the collection as.

[Collection: ptyordernosrc]

Type : Ledger Sales Orders
Child Of: "Arasan"
Filter : PositiveClosingBalance
Cleared : No
Fetch: Name, PartyName, stockitemName

[Collection: ptyorderitemoutstanding]

Source Collection: ptyordernosrc
By: yrajsoRstockitemName :$stockitemName
Aggr Compute: yrajitembalance:sum:$closingBalance

this collection is working , But It displays only one item.

Please kindly let me know what collection should i use to achieve the result?

Thanks in Advance.

Thanks lot.

 

Check your Filters on Source Collection. That may filter your records