help me to hide 0(zero) balance ledgers

[#Menu: Gateway of Tally]

Add : Item : Before : @@locQuit : Company Ledger/Sub Group List : Display : CAB Ledger List

[Report: CAB Ledger List]

Form : CAB Ledger Form
Title : “Company Ledger List”

[Form: CAB Ledger Form]

Use : DSP Template ;;;Its a pre defined report containing all the necessary keys, buttons, etc required for reporting purposes
Parts : CAB Ledger Part
Height : 100% screen ;;;defining height of form as 100% sccreen
Width : 100% screen ;;;defining width of form as 100% sccreen


[Part: CAB Ledger Part]

Lines : CAB Ledger Title, CAB Ledger Line
Repeat : CAB Ledger Line : CAB My Ledgers ;;;line will repeat on the collection of the ledger
CommonBorder: Yes
Scroll : Vertical

[Line: CAB Ledger Title]

Use : CAB Ledger Line

Local : Field : Default : Type : String
Local : Field : Default : Align : Centre
Local : Field : Default : Style : Normal Bold

Local : Field : CAB Led No : Set as : “Sl. No”
Local : Field : CAB Led Name : Set as : “Ledger Name”
Local : Field : CAB Led address : Set as : “Address”
Local : Field : CAB Led States : Set as : “PHONE NUMBER”

Local : Field : CAB Led CB : Set as : “Closing Balance”

Border : Thin Top Bottom

[Line: CAB Ledger Line]

Fields : CAB Led No, CAB Led Name,CAB Led Address,CAB Led States, CAB Led CB
Repeat : CAB Led CB
/*Option : AlterOnEnter ;;;Alter on enter will open the ledger master of the same ledger on which enter was pressed*/


[Field: CAB Led No]

Set as : $$Line ;;;setting the line number to the field
Width : 3
Align : Centre
Border : Thin Right
Alter : Ledger

[Field: CAB Led Name]

Use : Name Field
Set as : $Name ;;;set ledger name to field
Border : Thin Right

[Field: CAB LedAddress]

Set as : $STPartyFullAdd ;;;set party address to the field
Width : 30
Border : Thin Right

[Field: CAB Led States]

Set as : $LedgerMobile ;;;set state name
Width : 20
Border : Thin Right







[Field: CAB Led CB]

Use : Amount Forex Field
Set as : $ClosingBalance
Border:Thin Right
Space Right:40



[Collection: CAB My Ledgers]

Type : Ledger
Child of : $$GroupSundryDebtors
Belongs to : Yes


Fetch : Name, STPartyFullAdd, StateName, Pincode, LedgerContact, LedgerPhone, LedgerFax, Email, ClosingBalance

 

i want to hide the ledgers if its closing balance is 0(zero)


and in assending order

 

[#Menu: Gateway of Tally]

Add : Item : Before : @@locQuit : Company Ledger/Sub Group List : Display : CAB Ledger List

[Report: CAB Ledger List]

Form : CAB Ledger Form
Title : “Company Ledger List”

[Form: CAB Ledger Form]

Use : DSP Template ;;;Its a pre defined report containing all the necessary keys, buttons, etc required for reporting purposes
Parts : CAB Ledger Part
Height : 100% screen ;;;defining height of form as 100% sccreen
Width : 100% screen ;;;defining width of form as 100% sccreen


[Part: CAB Ledger Part]

Lines : CAB Ledger Title, CAB Ledger Line
Repeat : CAB Ledger Line : CAB My Ledgers ;;;line will repeat on the collection of the ledger
CommonBorder: Yes
Scroll : Vertical

[Line: CAB Ledger Title]

Use : CAB Ledger Line

Local : Field : Default : Type : String
Local : Field : Default : Align : Centre
Local : Field : Default : Style : Normal Bold

Local : Field : CAB Led No : Set as : “Sl. No”
Local : Field : CAB Led Name : Set as : “Ledger Name”
Local : Field : CAB Led address : Set as : “Address”
Local : Field : CAB Led States : Set as : “PHONE NUMBER”

Local : Field : CAB Led CB : Set as : “Closing Balance”

Border : Thin Top Bottom

[Line: CAB Ledger Line]

Fields : CAB Led No, CAB Led Name,CAB Led Address,CAB Led States, CAB Led CB
Repeat : CAB Led CB
/*Option : AlterOnEnter ;;;Alter on enter will open the ledger master of the same ledger on which enter was pressed*/


[Field: CAB Led No]

Set as : $$Line ;;;setting the line number to the field
Width : 3
Align : Centre
Border : Thin Right
Alter : Ledger

[Field: CAB Led Name]

Use : Name Field
Set as : $Name ;;;set ledger name to field
Border : Thin Right

[Field: CAB LedAddress]

Set as : $STPartyFullAdd ;;;set party address to the field
Width : 30
Border : Thin Right

[Field: CAB Led States]

Set as : $LedgerMobile ;;;set state name
Width : 20
Border : Thin Right







[Field: CAB Led CB]

Use : Amount Forex Field
Set as : $ClosingBalance
Border:Thin Right
Space Right:40



[Collection: CAB My Ledgers]

Type : Ledger
Child of : $$GroupSundryDebtors
Belongs to : Yes


Fetch : Name, STPartyFullAdd, StateName, Pincode, LedgerContact, LedgerPhone, LedgerFax, Email, ClosingBalance

Filter:ZeroClosing

[System:formula]
Zeroclosing:$ClosingBalance>0

 

THANK YOU ITS WORKING FINE
CAN YOU HELP ME WITH THE CLOSING BLANCE TO DISPLAY IN ASSENDING ORDER

 

Try this in ur collection
Sort:default :$closingbalance

 

Thanks to all For Sharing Knowledge..

 

http://tdlexpert.com/index.php?threads/how-to-fetch-ledger-mobile-number.10968/
HELP ME WITH THIS