HELP : How to Save fields to a new database reports

Discussion in 'Free Source Codes' started by VISHNU RATHI, Oct 1, 2019.

    
Tags:
  1. VISHNU RATHI

    VISHNU RATHI Member


    Hello sir,
    i am a new learner of tally tdl

    i have written a code in which i want to add notes

    code is

    [#Menu :Gateway of Tally]
    Add :Button : Party Notes

    [Button : Party Notes]
    Title : "Party Notes"
    Key : Alt+X
    Action:Create:myreport

    [Report:myreport]
    Form:myform

    [Form:myform]
    Part:mypart

    [Part:mypart]
    Line:myline

    [Line:myline]
    Field:myfield, myfield2

    [Field:myfield]
    Set as: "Name:"
    Skip : Yes

    [Field:myfield2]
    Use : name field

    [System : Form keys]
    Key : Party Notes
    [System : Menu Keys]
    Key : Party Notes


    i want to make a separate report of notes whenever i fill details in the above code.
    is it possible sir?
     


  2. teja varma

    teja varma Active Member


    you want to store notes for every party or just store and retrieve?
     


  3. VISHNU RATHI

    VISHNU RATHI Member


    i just want to store and retrieve notes in a separate report displayed sir.
     


  4. teja varma

    teja varma Active Member


    use this to store notes:
    Code:
    [#Menu :Gateway of Tally]
    Add :Button : Party Notes
    
    [Button : Party Notes]
    Title : "Party Notes"
    Key : Alt+X
    Action:Alter:myreport
    
    
    [Report:myreport]
    Form:myform
        Title:$$LocaleString:"Add notes"
        Object:company
       
    [Form:myform]
    Part:mypart
    
    [Part:mypart]
    Line:mytitleline,myline
    
    [Line:mytitleline]
        Field:Name Field
        Local:Field:Name Field:Info:$$LocaleString:"ADD NOTES:"
        Local:Field:Name Field:Align:Center
    
    [Line:myline]
    Field:myfield2
    
    [Field:myfield2]
    Storage:mynotes123
    Width:40
    Lines:5
    Max:250
    
    [System:UDF]
        mynotes123:String:1245
    to access/get the notes value :
    Code:
    $mynotes123:Company:##SvCurrentCompany
     


  5. VISHNU RATHI

    VISHNU RATHI Member


    thankyou sir.
    but there is one more problem in this code
    after entering note in the field, it is remembered by the code
    how can we enter another note?
    and accessing notes value is only getting the value which is last typed in the notes.
    is it possible to store old notes in a separate report , and after submitting any notes, value box can be cleared?
     


  6. VISHNU RATHI

    VISHNU RATHI Member


    l
    like first i created a note "XYZ"
    it is displayed in the report
    but when i change "XYZ" to "ABC"
    it is also changing in the report
    is it possible to get xyz and abc both notes in the same report by serially.
     


  7. teja varma

    teja varma Active Member


    you need to create an aggregate udf and then walk that collection every time you want the value and pick the latest value
     
    Naresh Chawda likes this.


  8. VISHNU RATHI

    VISHNU RATHI Member


    thankyou sir.
    will try it
     


Share This Page