seeking help for Exploded group & all Subgroups upto Ledger

Discussion in 'Requests' started by zakirhossain_diu, Nov 4, 2019.

    

  1. Dear Admin & experts,
    The followings are the codes i am using to get Detailed Reports as per attachments. Filter attributes not working, additional Index number at group level also not working well for explosion, Now can anyone please tell me what i can apply to get my desired output. I am trying to get like Sales Accounts (a primary group) All subgroups (under sales Accounts) and all ledgers (under subgroups), each group can have multiple subgroups.

    Thank you

    Code:
    [Part: BOdy]
        Top Lines       : TBLine
        Repeat            : TBLine: Combined
        Scrolled          : Vertical
       
    [Line: TBLine]
        Left Fields           : fName
        Right Fields        : fCBal
        Explode               : Body :  $$IsGroup
        Indent                  : 2*$$ExplodeLevel
    
    [Field: fName]
        Use                : Name Field
        Set                 : $Name
        Variables      : Name
    
    [Field: fCBal]
        Use                  : Amount Field
        Set                   : if $$ISDR:$ClosingBalance then $ClosingBalance else -$ClosingBalance
    
    [Collection: Combined]
        Collections          : Grp, Led
        Sort                      : @@Default : $$Alias
       
    [Collection: Grp]
        Type             : Group
        Child Of       : #Name   
       
    [Collection: Led]
        Type                 : Ledger
        Child Of             : #Name
    
     

    Attached Files:



Share This Page