how to filter the pincodewise in ledger report

Discussion in 'Tally Developer' started by priyaEaswar, Dec 29, 2015.

         
  1. priyaEaswar

    priyaEaswar Member


    [#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

    [Field:party 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
     



  2. priyaEaswar

    priyaEaswar Member


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

    Attached Files:




  3. priyaEaswar

    priyaEaswar Member


    pls help me
     



  4. priyaEaswar

    priyaEaswar Member


    pls developers help me
     




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

    Attached Files:




  6. vyadav

    vyadav Member


     



  7. priyaEaswar

    priyaEaswar Member



    Thank u Sir.
     



  8. Ankur Tiwari

    Ankur Tiwari New Member


    Great Sir ji
     



Share This Page