Dear Developers, below i have two collections, in which i am using 1st collection for the main report & now i want to add filter in 1st collection using 2nd collection, i have tried everything but nothing working, please help me [Collection:BWRPartyWiseVch]; Collection-1 for report Type : Vouchers : VoucherType Child of : $$VchTypeSales Belongs to : Yes By : PartyName : $PartyLedgerName Aggr Compute: TotActQty : Sum : $ActualQty Format : $PartyName, 25 Compute : TotBillQty: $$CollAmtTotal:InventoryEntries:$$AsQty:$BilledQty Compute : TotCommRate : $CommissionPerc:Ledger:$PartyName Compute : TotAmount : $$CollAmtTotal:InventoryEntries:$Amount Compute : Commission: $CommissionAmount Fetch : CommissionAmount Sort : @@Default : $Date, $VoucherNumber [Collection: ECReceiptCollection]; collection-2 for filter Type : Vouchers : Ledger Child Of : #BWRPartyName Belongs to : Yes Walk : Ledger Entries Compute : Amount : $AllLedgerEntries[2].Amount Compute : Date : $Date
[Collection: ECReceiptCollection]; collection-2 for filter Parm Var : SSLedgerName : $$RequestObject:$PartyName Type : Vouchers : Ledger Child Of : ##SSLedgerName Belongs to : Yes Walk : Ledger Entries Compute : Amount : $AllLedgerEntries[2].Amount Compute : Date : $Date