How we can add auto column in group summary report using TDL

Discussion in 'Tally Developer' started by Praveen Suthar, Aug 27, 2019.

         
  1. Praveen Suthar

    Praveen Suthar New Member


    I have created TCP to get the "Day wise groups" data from tally using TCP file but it is not giving data as I want.
    I need data as attached image

    day wise group.png
    (
    In Tally, We can add the "auto column" as "Daily" using auto column button and can get day wise groups data in "group summary" report.
    )

    Please find my TDL code below

    [#Report: Group Summary]
    Set : GroupName:$$SysName:"Sales Accounts"
    Add: Set: DSPRepeatCollection: "Period Collection New"
    Add: Set: SVPeriodicity : "Day"
    Add:Variable:SVFromDate,SVToDate
    Add:Repeat: SVFromDate,SVToDate
    [#Form: Group Summary]
    Option : Set Auto Option 1 : $$SetAutoColumns:SVFromDate

    [!Form: Set Auto Option1]
    [Collection: Period Collection New]
    Type : Period
    Repeat : "Daily"


    Please help me with this.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    U attached...how you want............. so also attach WHAT you are getting..........
     


  3. Praveen Suthar

    Praveen Suthar New Member


    I am not getting any output from this tdl.

    Please help me in this.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    C
    Certain reports in Tally (e.g. the Group Summary) cannot be overridden by another code except for cosmetic changes like colors, fonts etc.

    You will have to make your own report and duplicate all the conditions of the original "Group Summary", but only change will be your AutoColumn settings.
     


  5. Praveen Suthar

    Praveen Suthar New Member


    ThankYou Amit,


    I have created TCP for this but not getting proper data.
    Not able to change the date in order and balance is also not coming related to date.

    can you please help me with this?

    Please find New code below.

    [#Menu : Gateway of Tally]
    Item : MyTest : Display : MyColReportNew
    [Report : MyColReportNew]
    Form : PSColReportNew
    Variable: DosetAutoColumn,DspRepeatCollection,SVFromDate,SVToDate ;;PSVariable
    Set : DosetAutoColumn : yes
    Repeat : SVFromDate,SVToDate ;;PSVariable
    Set : DspRepeatCollection : PSStockitemCollection
    Set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany
    Set : SVToDate : ##SVCurrentDate
    [Form :pSColReportNew]
    Part :pSColReportNew,PSColReportNewBody
    Bottom Part : PSColReportNewBodyBTM
    ;;Option : Set Auto Option : $$SetAutoColumns:pSVariable
    Option : Set Auto Option : $$SetAutoColumns:SVFromDate
    [Part :pSColReportNew]
    Line :pSColReportNew
    Border : Column Titles
    [Line :pSColReportNew]
    Field : PSColReportNew,PSColSalesQty
    Repeat : PSColSalesQty
    Local : Field : PSColSalesQty : Align : Center
    [Field :pSColReportNew]
    Use : Name Field
    Set As : "Particulars"
    [Field :pSColSalesQty]
    Use : Name Field
    ;;Set As : ##PSVariable
    Set As : ##SVFromDate
    Border : Thin Left
    [Part : PSColReportNewBody]
    Line : PSColReportNewBody
    Repeat : PSColReportNewBody : PSCustomers
    Scroll : Vertical
    Total : PSColSalesQty
    Common Border : yes
    [Line :pSColReportNewBody]
    Field : PSColReportNew,PSColSalesQty
    Repeat : PSColSalesQty
    Local : Field : PSColReportNew : Set As : $Name
    Local : Field : PSColSalesQty : Type : Amount
    Local : Field : PSColSalesQty : Align : Right
    Local : Field : PSColSalesQty : Set AS : $$NettAmount:($BSClosing:Group:$Name):($ForexClosing:Group:$Name)
    [Part : PSColReportNewBodyBTM]
    Use : PSColReportNew
    Local : Field : PSColReportNew : Set As : $$Total:pSColReportNew
    Local : Field : PSColSalesQty: Set As : $$Total:pSColSalesQty
    Local : Line :pSColReportNew : Local : Field : PSColSalesQty : Align : Right
    [Collection : PSStockitemCollection]
    Type : Groups
    ;;Compute : PSVariable : $Booksfrom:Company:##SVCurrentCompany
    set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany
    Repeat : SVFromDate + 1
    ;;[Variable : SVFromDate]
    ;; Repeat : ##DspRepeatCollection

    ;;[Variable : PSVariable]
    ;; Repeat : ##DspRepeatCollection
    [Collection : PSCustomers]
    Type : Groups
    set : SVFromDate : $Booksfrom:Company:##SVCurrentCompany
    Repeat : SVFromDate + 1

    [System:Formula]
    SalesAccounts : $$NettAmount:($BSClosing:Group:"Sales Accounts"):($ForexClosing:Group:"Sales Accounts")
    SalesTotVal : $ClosingBalance:Group:$$GroupSales

    Output :
    upload_2019-8-28_19-26-10.png
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    When you submit codes, please remove all commented items (not needed), as it confuses us, until we see the sign.

    Why have you put SET of SVFromDate in the Collections??
     


  7. Praveen Suthar

    Praveen Suthar New Member


    I am on learning stage. I created this file based on another example.
    It is very closed to end but i am not much familier with repeat.

    Please help me to finish this tcp.
     


  8. drive

    drive Active Member


    Try
    [Collection : PSStockitemCollection]
    Use: Period Collection
     


  9. Praveen Suthar

    Praveen Suthar New Member


    I have used "Period Collection" but the date is not increasing upto till date and also not coming balance as per date

    [#Menu : Gateway of Tally]
    Item : MyTest : Display : MyColReportNew
    [Report : MyColReportNew]
    Form : PSColReportNew
    Variable: DosetAutoColumn,DspRepeatCollection,SVFromDate1
    Repeat : SVFromDate1
    Set : DosetAutoColumn : yes
    Set : DspRepeatCollection : "Period Collection"
    Set : SVPeriodicity : "Day"
    Set : SVFromDate1 : $Booksfrom:Company:##SVCurrentCompany
    [Form :pSColReportNew]
    Part :pSColReportNew,PSColReportNewBody
    Bottom Part : PSColReportNewBodyBTM
    Option : Set Auto Option : $$SetAutoColumns:SVFromDate1
    [Part :pSColReportNew]
    Line :pSColReportNew
    Border : Column Titles
    [Line :pSColReportNew]
    Field : PSColReportNew,PSColSalesQty
    Repeat : PSColSalesQty
    Local : Field : PSColSalesQty : Align : Center
    [Field :pSColReportNew]
    Use : Name Field
    Set As : "Particulars"
    [Field :pSColSalesQty]
    Use : Name Field
    Set As : ##SVFromDate1
    Border : Thin Left
    [Part : PSColReportNewBody]
    Line : PSColReportNewBody
    Repeat : PSColReportNewBody : PSCustomers
    Scroll : Vertical
    Total : PSColSalesQty
    Common Border : yes
    [Line :pSColReportNewBody]
    Field : PSColReportNew,PSColSalesQty
    Repeat : PSColSalesQty
    Local : Field : PSColReportNew : Set As : $Name
    Local : Field : PSColSalesQty : Type : Amount
    Local : Field : PSColSalesQty : Align : Right
    Local : Field : PSColSalesQty : Set AS : $$NettAmount:($BSClosing:Group:$Name):($ForexClosing:Group:$Name)
    [Part : PSColReportNewBodyBTM]
    Use : PSColReportNew
    Local : Field : PSColReportNew : Set As : $$Total:pSColReportNew
    Local : Field : PSColSalesQty: Set As : $$Total:pSColSalesQty
    Local : Line :pSColReportNew : Local : Field : PSColSalesQty : Align : Right
    [Variable : SVFromDate1]
    Repeat :##DspRepeatCollection
    [Collection : PSCustomers]
    Type : Groups

    [System:Formula]
    SalesAccounts : $$NettAmount:($BSClosing:Group:"Sales Accounts"):($ForexClosing:Group:"Sales Accounts")
    SalesTotVal : $ClosingBalance:Group:$$GroupSales
     


  10. Praveen Suthar

    Praveen Suthar New Member


    Hi Admin/Members,

    Please help me on the above code.
     


  11. Praveen Suthar

    Praveen Suthar New Member


    Any Help on above
     


Share This Page