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

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


(
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.

 

I am not getting any output from this tdl.

Please help me in this.

 

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 SColReportNew]
Part SColReportNew,PSColReportNewBody
Bottom Part : PSColReportNewBodyBTM
;;Option : Set Auto Option : $$SetAutoColumnsSVariable
Option : Set Auto Option : $$SetAutoColumns:SVFromDate
[Part SColReportNew]
Line SColReportNew
Border : Column Titles
[Line SColReportNew]
Field : PSColReportNew,PSColSalesQty
Repeat : PSColSalesQty
Local : Field : PSColSalesQty : Align : Center
[Field SColReportNew]
Use : Name Field
Set As : "Particulars"
[Field SColSalesQty]
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 SColReportNewBody]
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 : $$TotalSColReportNew
Local : Field : PSColSalesQty: Set As : $$TotalSColSalesQty
Local : Line SColReportNew : 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 :

 

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.

 

Try
[Collection : PSStockitemCollection]
Use: Period Collection

 

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 SColReportNew]
Part SColReportNew,PSColReportNewBody
Bottom Part : PSColReportNewBodyBTM
Option : Set Auto Option : $$SetAutoColumns:SVFromDate1
[Part SColReportNew]
Line SColReportNew
Border : Column Titles
[Line SColReportNew]
Field : PSColReportNew,PSColSalesQty
Repeat : PSColSalesQty
Local : Field : PSColSalesQty : Align : Center
[Field SColReportNew]
Use : Name Field
Set As : "Particulars"
[Field SColSalesQty]
Use : Name Field
Set As : ##SVFromDate1
Border : Thin Left
[Part : PSColReportNewBody]
Line : PSColReportNewBody
Repeat : PSColReportNewBody : PSCustomers
Scroll : Vertical
Total : PSColSalesQty
Common Border : yes
[Line SColReportNewBody]
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 : $$TotalSColReportNew
Local : Field : PSColSalesQty: Set As : $$TotalSColSalesQty
Local : Line SColReportNew : 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

 

Hi Admin/Members,

Please help me on the above code.

 

Any Help on above