1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Hello sir please help how to fetch UDF Ledger Master in our report

Discussion in 'Free Source Codes' started by gramachandran, Mar 15, 2022.

    
  1. gramachandran

    gramachandran New Member


    [#Part : LEd Other Details]
    Add: Lines: FatherName,RollNo,DOB,Batch,Course,AcaYear,Gender

    [Line :FatherName]
    Field : Medium Prompt ,FatherName
    Local : Field : Medium Prompt : Info:"Father Name"
    ;;Local : Field : Medium Prompt : Color : Block

    [Line : RollNo]
    Field : Medium Prompt ,RollNo
    Local : Field : Medium Prompt : Set as :"RollNo"
    ;;Local : Field : Medium Prompt : Color : Block

    [Line : DOB]
    Field : Medium Prompt ,DOB
    Local : Field : Medium Prompt : Set as :"DOB"

    [Line : Batch]
    Field : Medium Prompt ,Batch
    Local : Field : Medium Prompt : Set as :"Batch"

    [Line : Course]
    Field : Medium Prompt ,Course
    Local : Field : Medium Prompt : Set as :"Course"

    [Line : AcaYear]
    Field : Medium Prompt ,AcaYear
    Local : Field : Medium Prompt : Set as :"Academic Year"

    [Line : Gender]
    Field : Medium Prompt ,Gender
    Local : Field : Medium Prompt : Set as :"Gender"

    [Field : FatherName]

    Use : Name Field
    Storage : FathNam
    Color : Blue

    [Field : RollNo]

    Use : Name Field
    Storage : RoNo
    Color : Blue

    [Field : DOB]

    Use : uni Date Field
    Storage : Birth Date
    Color : Blue

    [Field : Batch]

    Use : Name Field
    Storage : Bat
    Color : Blue

    [Field : Course]

    Use : Name Field
    Storage : Cour
    Color : Blue

    [Field : AcaYear]

    Use : Name Field
    Storage : AcYr
    Color : Blue

    [Field : Gender]

    Use : Name Field
    Storage : Gen
    Color : Blue


    /***********************************************************************
    Report

    ************************************************************************/
    [#Menu : Gateway of Tally]
    Add : Key Item : Student Profile Report : E : Display: StudentProfile

    [Report : StudentProfile]
    Use : DSP Template
    Form : StudentForm
    Title : Student Profiel Report

    [Form : StudentForm]
    Use : DSP Template
    Part : StudentPart
    Height : 100% Page
    Width : 100% Page
    Button : StuExport
    Button : StuPrint

    [Button : StuExport]
    Key : Alt + E
    Action : Export Report: StudentProfile

    [Button : StuPrint]
    Key : Alt + P
    Action : Print Report : StudentProfile


    [Part : StudentPart]
    Line : StudentTitle, StudentDetails
    Repeat : StudentDetails : StudentCollection
    Scroll : Vertical
    Common Border : Yes
    Border : Flush Totals

    [Line : StudentTitle]
    Use : StudentDetails
    Local : Field : Default : Type : String
    Local : Field : Default : Delete : Storage
    Local : Field : Default : Align : Center
    Local : Field : S.NO : Set as: "S.No."
    Local : Field : StudentName1 : Set as: "StudentName"
    Local : Field : FatherName1 : Set as: "Father Name"
    Local : Field : RollNO1 : Set as: "Roll No"
    Local : Field : DOB1 : Set as: "DOB"
    Local : Field : Batch1 : Set as: "Batch"
    Local : Field : Course1 : Set as: "Course"
    Local : Field : AcademicYear1 : Set as: "Academic Year"
    Local : Field : Gender1 : Set as: "Gender"
    Border : Flush Totals


    [Line : StudentDetails]
    Fields : S.NO,StudentName1,FatherName1,RollNO1,DOB1,Batch1,Course1,AcademicYear1,Gender1

    [Field : S.NO]
    Use : Name Field
    Width : 6% Screen
    Set as : $$Line
    Border : Thin Left

    [Field : StudentName1]
    Use : Name Field
    Set as : $Name
    Border : Thin Left

    [Field : FatherName1]
    Use : Name Field
    Set as : $Parant
    Border : Thin Left

    [Field : RollNO1]
    Use : Name Field
    Set as : $RollNo
    Border : Thin Left

    [Field : DOB1]
    Use : Name Field
    Set as : $DOB
    Border : Thin Left

    [Field : Batch1]
    Use : Name Field
    Set as : $Batch
    Border : Thin Left

    [Field : Course1]
    Use : Name Field
    Set as : $Course
    Border : Thin Left

    [Field : AcademicYear1]
    Use : Name Field
    Set as : $AcademicYear
    Border : Thin Left

    [Field : Gender1]
    Use : Name Field
    Set as : $Gender
    Border : Thin Left

    [Collection : StudentCollection]
    Type : Ledger
    Fetch : Name,Parant,FatherName1,RollNo,DOB,Batch,Course,AcademicYear,Gender
    Child Of : $$GroupSundryDebtors
    Belongs To : Yes

    [System : UDF]

    StudentCollection : Aggregate : 10011

    FathNam : String : 10001

    RoNo : String : 10002


    Birth Date : Date : 10003


    Bat : String : 10004


    Cour : String : 10005


    AcYr : String : 10006

    Gen : String : 10007
     
    gramachandran, Mar 15, 2022
    #1
    Hems likes this.


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    use the UDF names in the field. Why are you using the FIELD Names to call the data???
     
    Amit Kamdar, Mar 15, 2022
    #2


  3. Murali.R

    Murali.R Member


    [Line : StudentDetails]
    Fields : S.NO,StudentName1,FatherName1,RollNO1,DOB1,Batch1,Course1,AcademicYear1,Gender1

    [Field : S.NO]
    Use : Name Field
    Width : 6% Screen
    Set as : $$Line
    Border : Thin Left

    [Field : StudentName1]
    Use : Name Field
    Set as : $Name
    Border : Thin Left

    [Field : FatherName1]
    Use : Name Field
    Set as : $FathNam
    Border : Thin Left

    [Field : RollNO1]
    Use : Name Field
    Set as : $RoNo
    Border : Thin Left

    [Field : DOB1]
    Use : Name Field
    Set as : $Birth Date
    Border : Thin Left

    [Field : Batch1]
    Use : Name Field
    Set as : $Bat
    Border : Thin Left

    [Field : Course1]
    Use : Name Field
    Set as : $Cour
    Border : Thin Left

    [Field : AcademicYear1]
    Use : Name Field
    Set as : $AcYr
    Border : Thin Left

    [Field : Gender1]
    Use : Name Field
    Set as : $Gen
    Border : Thin Left

    [Collection : StudentCollection]
    Type : Ledger
    Fetch : Name,parent,FathNam,RoNo,Birth Date,Bat ,Cour,AcYr,Gen
    Child Of : $$GroupSundryDebtors
    Belongs To : Yes
     
    Murali.R, Mar 16, 2022
    #3


  4. Rohit Khedar

    Rohit Khedar Member


    not work
     
    Rohit Khedar, Mar 16, 2022
    #4


  5. gramachandran

    gramachandran New Member


    Respected sir,

    i edit my code under your guidelines so unable to get udf field please guide me

    upload_2022-3-16_10-40-15.png

    [#Part : LEd Other Details]
    Add: Lines: FatherName,RollNo,DOB,Batch,Course,AcaYear,Gender

    [Line :FatherName]
    Field : Medium Prompt ,FatherName
    Local : Field : Medium Prompt : Info:"Father Name"
    ;;Local : Field : Medium Prompt : Color : Block

    [Line : RollNo]
    Field : Medium Prompt ,RollNo
    Local : Field : Medium Prompt : Set as :"RollNo"
    ;;Local : Field : Medium Prompt : Color : Block

    [Line : DOB]
    Field : Medium Prompt ,DOB
    Local : Field : Medium Prompt : Set as :"DOB"

    [Line : Batch]
    Field : Medium Prompt ,Batch
    Local : Field : Medium Prompt : Set as :"Batch"

    [Line : Course]
    Field : Medium Prompt ,Course
    Local : Field : Medium Prompt : Set as :"Course"

    [Line : AcaYear]
    Field : Medium Prompt ,AcaYear
    Local : Field : Medium Prompt : Set as :"Academic Year"

    [Line : Gender]
    Field : Medium Prompt ,Gender
    Local : Field : Medium Prompt : Set as :"Gender"

    [Field : FatherName]

    Use : Name Field
    Storage : FathNam
    Color : Blue

    [Field : RollNo]

    Use : Name Field
    Storage : RoNo
    Color : Blue

    [Field : DOB]

    Use : uni Date Field
    Storage : Birth Date
    Color : Blue

    [Field : Batch]

    Use : Name Field
    Storage : Bat
    Color : Blue

    [Field : Course]

    Use : Name Field
    Storage : Cour
    Color : Blue

    [Field : AcaYear]

    Use : Name Field
    Storage : AcYr
    Color : Blue

    [Field : Gender]

    Use : Name Field
    Storage : Gen
    Color : Blue


    /***********************************************************************
    Report

    ************************************************************************/
    [#Menu : Gateway of Tally]
    Add : Key Item : Student Profile Report : E : Display: StudentProfile

    [Report : StudentProfile]
    Use : DSP Template
    Form : StudentForm
    Title : Student Profiel Report

    [Form : StudentForm]
    Use : DSP Template
    Part : StudentPart
    Height : 100% Page
    Width : 100% Page
    Button : StuExport
    Button : StuPrint

    [Button : StuExport]
    Key : Alt + E
    Action : Export Report: StudentProfile

    [Button : StuPrint]
    Key : Alt + P
    Action : Print Report : StudentProfile


    [Part : StudentPart]
    Line : StudentTitle, StudentDetails
    Repeat : StudentDetails : StudentCollection
    Scroll : Vertical
    Common Border : Yes
    Border : Flush Totals

    [Line : StudentTitle]
    Use : StudentDetails
    Local : Field : Default : Type : String
    Local : Field : Default : Delete : Storage
    Local : Field : Default : Align : Center
    Local : Field : S.NO : Set as: "S.No."
    Local : Field : StudentName1 : Set as: "StudentName"
    Local : Field : FatherName1 : Set as: "Father Name"
    Local : Field : RollNO1 : Set as: "Roll No"
    Local : Field : DOB1 : Set as: "DOB"
    Local : Field : Batch1 : Set as: "Batch"
    Local : Field : Course1 : Set as: "Course"
    Local : Field : AcademicYear1 : Set as: "Academic Year"
    Local : Field : Gender1 : Set as: "Gender"
    Border : Flush Totals


    [Line : StudentDetails]
    Fields : S.NO,StudentName1,FatherName1,RollNO1,DOB1,Batch1,Course1,AcademicYear1,Gender1

    [Field : S.NO]
    Use : Name Field
    Width : 6% Screen
    Set as : $$Line
    Border : Thin Left

    [Field : StudentName1]
    Use : Name Field
    Set as : $Name
    Border : Thin Left

    [Field : FatherName1]
    Use : Name Field
    Set as : $FathNam
    Border : Thin Left

    [Field : RollNO1]
    Use : Name Field
    Set as : $RoNo
    Border : Thin Left

    [Field : DOB1]
    Use : Name Field
    Set as : $BirthDate
    Border : Thin Left

    [Field : Batch1]
    Use : Name Field
    Set as : $Bat
    Border : Thin Left

    [Field : Course1]
    Use : Name Field
    Set as : $Cour
    Border : Thin Left

    [Field : AcademicYear1]
    Use : Name Field
    Set as : $AcYr
    Border : Thin Left

    [Field : Gender1]
    Use : Name Field
    Set as : $Gen
    Border : Thin Left

    [Collection : StudentCollection]
    Type : Ledger
    Fetch : Name,Parant,FathNam,RoNo,Birth Date,Bat,Cour,AcYr,Gen
    Child Of : $$GroupSundryDebtors
    Belongs To : Yes

    /*[System : UDF]

    StudentCollection : Aggregate : 10011

    FathNam : String : 10001

    RoNo : String : 10002


    Birth Date : Date : 10003


    Bat : String : 10004


    Cour : String : 10005


    AcYr : String : 10006

    Gen : String : 10007
     
    gramachandran, Mar 16, 2022
    #5


  6. gramachandran

    gramachandran New Member


    Respected sir

    here i prepare student profile report sir please help me upload_2022-3-16_10-48-44.png
     
    gramachandran, Mar 16, 2022
    #6


  7. Rohit Khedar

    Rohit Khedar Member


    try this udf

    [System : UDF]
    FathNam : String : 10001
    RoNo : String : 10002
    Birth Date : Date : 10003
    Bat : String : 10004
    Cour : String : 10005
    AcYr : String : 10006
    Gen : String : 10007
     
    Rohit Khedar, Mar 16, 2022
    #7
    gramachandran likes this.


  8. gramachandran

    gramachandran New Member


    upload_2022-3-16_13-19-19.png
     
    gramachandran, Mar 16, 2022
    #8


  9. isha sabharwal

    isha sabharwal New Member


    can we add these udf on receipt voucher and printing also
     
    isha sabharwal, Mar 24, 2022
    #9


Share This Page