I am create 1 udf field in ledger master and open verious ledger under this udf filed i want to create report for balance report base on udf base field value my code is below [#Menu : GateWay Of Tally] Add : Item : Before : @@locDisplay : Account Balanceisplay: Account Balance [Report: Account Balance] Use : DSP Template Title : "Account Balance" Form : Account Balance Set : SVFromDate : $$MonthStart:##SVFromDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Variable : SVFromDate, SVToDate [Form: Account Balance] Parts : Bal Main Tital,Bal Main Tital1,Account Report,New Account Report Details Button : PrintButton, ExportButton,ChangePeriod Space Left : 4 mms Space Right : 4 mms Height : 100% Page Width : 100% Page Set Always : SV Print Orientation : "Portrait" Bottom Toolbar Buttons : BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 Page Break : AC ClPageBreak, AC OpPageBreak [Part : AC ClPageBreak] Line : DSP ContLine order : Full Thin Top [Part : AC OpPageBreak] Parts : Bal Main Tital, Bal Main Tital1, Account Report Vertical : Yes Space Top : 1 ;;3 [Part: Bal Main Tital] Line : BlTital [Line : BlTital] Field : BlTital1 Space Top : 1 mms Space Bottom: 1 mms [Field :BlTital1] Use : Name Field Info : ##SVCurrentCompany Align : Center Width : 100% Screen Style : Large Align : Center [Part: Bal Main Tital1] Line : BlTital1 [Line : BlTital1] Field : BlTital2 Space Top : 3 mms Space Bottom: 3 mms [Field :BlTital2] Use : Name Field Set as : "Member Wise Balance Report For The Period "+@@DSPDateStr Width : 100% Screen Align : Center [Part: Account Report] Line : Balhead Common Borders : Yes [Line : Balhead] Field : SrNo,memid,memacty,memname,mcds,mshr,mln,mfdr,mrd Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Column Titles Space Top : 1.5 mms Space Bottom: 1.5 mms [Field: SrNo] Use : Name Field Set as : "Sr.No" Border : Thin Left Width : 7 Type : String Align : Center [Field: memacty] Use : Name Field Set as : "AcTy" Border : Thin Left Width : 7 Type : String Align : Center [Field: memid] Use : Name Field Set as : "Memid" Border : Thin Left Width : 7 Type : String Align : Center [Field: memname] ;COST CENTER NAME Use : Name Field Type : String Width : 80 Border : Thin Left Right Align : Center Set as : "Member Name" [Field: mcds] Use : Name Field Type : String Width : 20 Border : Thin Left Right Align : Center Set as : "CDS" [Field: mshr] Use : Name Field Type : String Width : 20 Border : Thin Left Right Align : Center Set as : "SHARE" [Field: mln] Use : Name Field Type : String Width : 20 Border : Thin Left Right Align : Center Set as : "LOAN" [Field: mfdr] Use : Name Field Type : String Width : 20 Border : Thin Left Right Align : Center Set as : "FDR" [Field: mrd] Use : Name Field Type : String Width : 20 Border : Thin Left Right Align : Center Set as : "RD" [Part: New Account Report Details] Part: Account Report Details Break On : $$IsEmpty:$Memcdx [Part: Account Report Details] Line : BalDetails,Account Report Total Break On : $$IsEmpty:$Memcdx Repeat : BalDetails : balbrij Common Borders : Yes Scroll : Vertical Total : Dmcds,Dmshr,Dmln,Dmfdr,Dmrd [Line : BalDetails] Field : DSrNo,Dmemid,Dmemacty,Dmemname,Dmcds,Dmshr,Dmln,Dmfdr,Dmrd Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Thin Top [Field: DSrNo] Use : Amount Base Field Set as : if $Memcdx=" " then " " else $$Line Border : Thin Left Right Width : 7 Type : Number Align : Center Format : "NoZero" [Field: Dmemacty] Use : Name Field Set as : if $Memcdx=" " then " " else $Mactyx Border : Thin Left Right Width : 7 Type : String Align : Center [Field: Dmemid] Use : Name Field Set as : if $Memcdx=" " then " " else $Memcdx Border : Thin Left Right Width : 7 Type : String Align : Center [Field: Dmemname] ;COST CENTER NAME Use : Name Field Type : String Width : 80 Border : Thin Right Align : Left Set as : if $Memcdx=" " then " " else $Memnmx ;--------------------------------------------------------- [Collection: ALedCC] Source Collection : balbrij Fetch : LedgerName,Name,ClosingBalance,Dmcds,Dmshr,Dmln,Memcdx,Memnmx,Mactyx By : Ledger Name : $Memcdx Aggr Compute : Dmcds : sum: if $Mactyx="CDS" then $ClosingBalance else 0 Aggr Compute : Dmshr : sum: if $Mactyx="SHR" then $ClosingBalance else 0 Aggr Compute : Dmln : sum: if $Mactyx="LN" then $ClosingBalance else 0 Aggr Compute : Dmfdr : sum: if $Mactyx="FDR" then $ClosingBalance else 0 Aggr Compute : Dmrd : sum: if $Mactyx="RD" then $ClosingBalance else 0 Search Key : $Memcdx+$Memnmx ;-------------------------------------------------------------------------- [Field: Dmcds] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$CollectionFieldByKey:$DmcdsMySearchKey:ALedCC MySearchKey : #Dmemid+#Dmemname Format : "NoZero,CrDr,Decimal:2," [Field: Dmshr] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$CollectionFieldByKey:$DmshrMySearchKey:aLedCC MySearchKey : #Dmemid+#Dmemname Format : "NoZero,CrDr,Decimal:2" [Field: Dmln] Use : Amount Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$CollectionFieldByKey:$DmlnMySearchKey:ALedCC MySearchKey : #Dmemid+#Dmemname Format : "NoZero,Cr,Dr,Decimal:2" [Field: Dmfdr] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$CollectionFieldByKey:$DmfdrMySearchKey:aLedCC MySearchKey : #Dmemid+#Dmemname Format : "NoZero,CrDr,Decimal:2" [Field: Dmrd] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$CollectionFieldByKey:$DmrdMySearchKey:aLedCC MySearchKey : #Dmemid+#Dmemname Format : "NoZero,CrDr,Decimal:2" ;Format : "Decimal:2" ;------------------------------- [Line: Account Report Total] Field : TDSrNo,TDmemacty,TDmemid,TDmemname,TDmcds,TDmshr,TDmln,TDmfdr,TDmrd Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Totals [Field: TDSrNo] Use : Amount Base Field Set as : " " Border : Thin Left Right Width : 7 Type : Amount Align : Center Format : "NoZero,CrDr" [Field: TDmemacty] Use : Name Field Set as : " " Border : Thin Left Right Width : 7 Type : String Align : Center [Field: TDmemid] Use : Name Field Set as : " " Border : Thin Left Right Width : 7 Type : String Align : Center [Field: TDmemname] Use : Name Field Type : String Width : 80 Border : Thin Right Align : Center Set as : "Total" [Field: TDmcds] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$Totalmcds Format : "NoZero,CrDr,Decimal:2" [Field: TDmshr] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$Totalmshr Format : "NoZero,CrDr,Decimal:2" [Field: TDmln] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$Totalmln Format : "NoZero,CrDr,Decimal:2" [Field: TDmfdr] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$Totalmfdr Format : "NoZero,CrDr,Decimal:2" [Field: TDmrd] Use : Amount Base Field Type : Amount Width : 20 Border : Thin Right Align : Right Set as : $$Totalmrd Format : "NoZero,CrDr,Decimal:2" [Collection: balbrij] Type : Ledger Fetch : Memcdx,Mactyx,ClossingBalance,Memnmx Filter : acbal [System:Formula] acbal : Not $$IsEmpty:$Memcdx ; issamefmrid: $$TgtObject:##Dmemid:$Memcdx
thank u sir i am change the spelling but my problem is my report show name in 3 time and balance showing in 3 time
thank u sir acty means account type i was create ledger for member in society like deposit account,share deposit account and loan account etc
sir i want create report base on memid (create by udf in ledger master), i was create verious ledger like deposit acoount ledger, share deposit account ledger and loand account ledger under same member id but all account parent was diffrendt i want create report like srno,memberid,name,show all account balance in one row
From your code not possible to check. Only Report is opening but no Data showing as you have added UDF in Ledger.