Get Relevant ledgerNames in Group Vouchers Report

Hi

I want to add a column in group vouchers report which show the Ledger Names of the vouchers which belongs to the #GroupName being shown.

collection being used in default Group Voucher report is "Vouchers of Group". At first I used field $LedgerName , but it only show the first Ledger name in the vouchers.

If a voucher has 3 or more ledger names then I want to show only those which belongs to the group in questions. I can get all ledger names of the voucher by "$$FullList:AllLedgerEntries:$LedgerName" . But how to filter names from this which belongs to #GroupName

Code:

[#Line: DSP VchDetail]
    Add:Left Field: Before:DSP VchLedAccount:KA_DSP LedgerName

[Field: KA_DSP LedgerName]
            Use: name field
            Set As:@@KA_LedNamesOfGroup
            Style: Small
            Align:Left
            Width       : 100; @@NameWidth
            Invisible:(##IsLedgerReport)

[#Line: DSP VchAccTitles]
    Add: Left Field:Before: DSP VchAcctTitle : KA_DSP NameTitle

[Field: KA_DSP NameTitle]
            Use:  Name Field
            Set as: @@KA_locName
            Width       : 25
            Indent      :  2
            ;Background:yellow
            Align:Left
            Invisible:(##IsLedgerReport)
[System:Formula]
    KA_locName: $$LocaleString:"Ledger Names"
    KA_LedNamesOfGroup: $$FullList:AllLedgerEntries:$LedgerName

 

Thanks for responding
The issues is where to put it. I cant filter the default Vouchers of Group collection . Next i can filter AllLedgerEntries inside vouchers of group collection. But how do i put it here -> $$FullList:AllLedgerEntries:$LedgerName ? it doesn't allow filters

How to make this filtered collection from AllLedgerEntries collection of a voucher?

 

Anyone can help?

 

it is working fine

[#Line: DSP VchDetail]
Add:Field: After: DSP VchDate:KA_DSP LedgerName

[Field: KA_DSP LedgerName]
Use: name field
Set As: $$FullList:AllLedgerEntries:$LedgerName
Style: Small
Align:Left
Width : 100; @@NameWidth
;Invisible##IsLedgerReport)

 

Its working because there is no filter in fulllist. My original question is different. how to filter the list and display.

 

Try This
KA_LedNamesOfGroup: $$FullList:AllLedgerEntries:$AllLedgerEntries[1,@@Isgrp].LedgerName
IsGrp : $$IsLedOfGrp:$LedgerName:##GroupName
for ledger entries parent " $$FullList:AllLedgerEntries:$LedParent"

 

First of thanks of showing interest!. The way the filter you suggested is printing a comma list of the FIRST Matched from group and repeat it equal to count of all $LedgerNameS in $AllLedgerEntries . I am attaching a bad debt voucher and how its displayed in report.

2 ledgers (VI & VE (Sorry, I had to hide names)) and of concern for me for the current group. But Group Vouchers Report will display the first ledger (VI) and repeat it in comma

What i actually Want particulars to show as VI, VE