how to filter the pincodewise in ledger report

[#Part :LED Multiple Mailing Address]

Add: Line : Myline

[Line : Myline]

Fields : short prompt, City

Local :field : short prompt :Set as : "City : "
Local :field : short prompt :Width : 20

[Field: City]

Storage: City
Use: Short Name Field

[System : UDF]

City : String : 1005

[System : Variable ]
VARGTEGrpName : ""

[Variable : VARGTEGrpName]
Type : String

[Collection : Sundry Debtors Details Col1]

Type : Ledger
Filter : GteParent
SORT : @@SORT_Default_Incr : $GroupSundryDebtors
Fetch : GTEGrpName, GTEGrpCNo, GTEGrpMble,GTEGrpEmail, GTEGrpAdrs,GTEGrpCty1,GTEGrpSte,GTEGrpPinCode


[System : Formula]

GteParent : $Parent = ##VARGTEGrpName Or $GrandParent = ##VARGTEGrpName

GroupListReport : $$LocaleString:"Sundry Debtors List"

[#Menu: Accounts Info.]

Add: Key Item: Before: @@LocQuit : Customer Details : C : Alter : Customer Details

[Report: Customer Details]

Form: Customer Details

[Form: Customer Details]

Use : DSP Template
Height : 25% Screen
Width : 60% Screen
Part : Customer Details
Vertical Align : Top


[Part: Customer Details]

Line: Customer DetailsL
Space Top : 5% Screen
Space Left : 10% Screen

[Line: Customer DetailsL]

Field : Medium Prompt, Customer DetailsF
Local : Field : Medium Prompt : Info: "Select Your Group"
Explode : Customer Details : $$IsLedger AND (##ExplodeFlag OR $$KeyExplode)

[Field : Customer DetailsF]

Use : Name Field
Table : End Of List, List of ExtractGroups
Variable : VARGTEGrpName
Modifies : VARGTEGrpName
Sub Form : Customer Details Report


[Report: Customer Details Report]

Variable : SVFromDate, SvToDate
Variable : VARGTEGrpName
Form : Customer Details Report

[Form: Customer Details Report]

Height : 100% Screen
Width : 100% Screen
Parts : Customer Details Report
Background : White, Light Orange
Button : Change Period, Print Button, Export Button, Explode Flag
Keys : Form Remove Line, Form Show Last Removed Line


[Part: Customer Details Report]

Lines : Sundry Debtor Report Title, Sundry Debtors Report Details
Repeat : Sundry Debtors Report Details : Sundry Debtors Details Col1
Scroll : Vertical
Common Border: Yes

[Line: Sundry Debtor Report Title ]

Fields : Party Name, Contact No, Phone,Email, Address, City1, State, Pincode
Border : Column Titles

[Fieldarty Name]

Use : Name Field
Info : "Name"
Width : 20
Type : String
Border : Thin Left Right
Align : Center
Style : Normal Bold

[Field: Contact No]

Use : Short Name Field
Info : "Contact No."
Width : 15
Border : Thin Right
Align : Center
Style : Normal Bold

[Field: Phone]

Use : Short Name Field
Info : "Mobile No."
Width : 15
Align : Center
Style : Normal Bold

[Field: Email]

Use : Short Name Field
Info : "Email"
Width : 25
Border : Thin Left Right
Align : Center
Style : Normal Bold

[Field: Address]

Use : Short Name Field
Info : "Address "
Width : 40
Align : Center
Style : Normal Bold

[Field: City1]

Use : Short Name Field
Info : "City"
Width : 10
Border : Thin Left Right
Type : String
Align : Center
Style : Normal Bold


[Field: State]

Use : Short Name Field
Info : "State"
Width : 10
Align : Center
Style : Normal Bold

[Field: Pincode]

Use : Short Name Field
Info : "PinCode"
Width : 5
Border : Thin Left
Align : Center
Style : Normal Bold

[Line: Sundry Debtors Report Details]

Fields : GTEGrpName, GTEGrpCNo, GTEGrpMble,GTEGrpEmail, GTEGrpAdrs,GTEGrpCty1,GTEGrpSte,GTEGrpPinCode
Height : 4% Screen
Option : AlterOnEnter

[Field: GTEGrpName]

Style: Normal
Set as: $Name
Type: String
Width : 20

[Field: GTEGrpCNo]

Style: Normal
Set as: $Ledgerphone
Width : 15

[Field: GTEGrpMble]

Style: Normal
Set as: $Ledgermobile
Width : 15

[Field: GTEGrpEmail]

Style: Normal
Set as: $Email
Width: 25

[Field: GTEGrpAdrs]

Style: Normal
Set as: $$FullList:Address:$Address
Type: String
Width: 40

[Field: GTEGrpCty1]

Set as : $City
Border : Thin Left
Width : 10
Style : Normal

[Field: GTEGrpSte]

Style: Normal
Set as: $StateName
Type: String
Width: 10

[Field: GTEGrpPinCode]

Style: Normal
Set as: $PinCode
Width: 5

[Key: DRAltLedger]

Key : Ctrl+Enter
Action : Alter : SVLedgerRep
Inactive: $$IsEmpty:$$Value OR $$IsSysName:$$Value

[Key: DRCrtLedger]

Key : Alt+C
Action : Create : Ledger

[# Form: Customer Details Report]

Add: Button: PK DB FilButton

[#Report:Customer Details Report]

Add: Set: PinVar: $$SysName:NotApplicable

[Button: PK DB FilButton]

Title: "Pincode."
Key:F5
Action: Alter : PK DB Form

[Report: PK DB Form]

Form: PK DB Form

[Form: PK DB Form]

Part: PK DB Form
NoConfirm: Yes

[Part: PK DB Form]

Line: PK DB Form

[Line: PK DB Form]

Field: Medium Prompt, PK DB Field

Local: Field: Medium Prompt: Setas: "Select Pincode:"

[Field: PK DB Field]

Use: Number Field
Modifies: PinVar
Table: PincodeTable, NotApplicable
ShowTable: Always


[Variable: PinVar]

Type: Number

[System: Variable]

PinVar: " "

[Collection: PincodeTable]

Type: Ledger
Fetch: Pincode
Format: $PinCode, 20
Title: "List of Pincode"
Report: Customer Details

[System: Formula]

PincodeFilter :$PinCode


[#Collection: Ledger MultiAddresses]

Add: Fetch: Pincode
Add: Filter: PincodeFilter

 

Anybody can help me. i have attached the button but not filter it,pls help crct coding .

 

pls help me

 

pls developers help me

 

Check this TDL uploaded by our member knsivam89 on 11/08/2014, it well explains how to sort and filter, go through carefully and learn. Thanks.

 

Thank u Sir.

 

Great Sir ji