Hi I want create a form,accept user value and display it in a new report. I have created a sample code for this Code: [Variable: lConfirmation] Type:Number [#Menu: Gateway of Tally] Item: My DialogBox: Alter: Rpt Confirmation [Report: Rpt Confirmation] Form: frm Confirmation Variable: lConfirmation Set: lConfirmation: 5 Title: "Confirm" [Form: frm Confirmation] Part: Prt Title, Prt YesNo Full Width : No No Confirm : Yes Space Left : 5 Space Right : 5 Space Top : 3 Space Bottom: 3 On:Form Accept:Yes:Display :rptMyReport [Part: Prt Title] Horizontal Align: Centre Lines : Form SubTitle Local : Field : Form SubTitle : Info : "Are you sure [Yes/No]" [Part: Prt YesNo] Horizontal Align: Centre Lines : ln Confirmation [Line: ln Confirmation] Add: Field: fldConfirmation [Field: fldConfirmation] Use: Number Field Set as: ##lConfirmation Modifies: lConfirmation [Report: rptMyReport] Add: Form: frmMyForm [Form: frmMyForm] Add: Part: prtMyPart Width: 40% screen Height: 50% screen [Part: prtMyPart] Add: Line: lnMyLine [Line: lnMyLine] Add: Field: fldMyField [Field: fldMyField] Set as : ##lConfirmation But when I am running it ,it display me the default value, while I am asspecting it to show the value entered by the user. Can any body please help me for this Thanks
Hi Jainitya, Use method/udf instead of variables to store values. In your code values are not getting stored anyware hence you facing the issue.
Hi Aaradhya I do not want to store this value,I just want to show a report based on this input For example , as user input as 10 ,it will show the trail balance for last 10 days only Do I still used the UDF for this?? Thanks
Hi Now I am trying to do it with UDF, but still not able to get value submitted by user,and also there is no input box is displayed Code: [#Menu: Gateway of Tally] Add : Item : Before : @@locQuit : Rpt Confirmation : Display : Rpt Confirmation [Report: Rpt Confirmation] Form: frm Confirmation [Form: frm Confirmation] Part: Prt Title, Prt YesNo Full Width : No No Confirm : Yes Space Left : 5 Space Right : 5 Space Top : 3 Space Bottom: 3 On:Form Accept:Yes:Display :rptMyReport [Part: Prt Title] Horizontal Align: Centre Lines : Form SubTitle Local : Field : Form SubTitle : Info : "Enter Number:" [Part: Prt YesNo] Horizontal Align: Centre Lines : ln Confirmation [Line: ln Confirmation] Add: Field: fldConfirmation [Field: fldConfirmation] Use: Number Field Storage:lConfirmation [Report: rptMyReport] Add: Form: frmMyForm [Form: frmMyForm] Add: Part: prtMyPart Width: 40% screen Height: 50% screen [Part: prtMyPart] Add: Line: lnMyLine [Line: lnMyLine] Add: Field: fldMyField [Field: fldMyField] Set as : $lConfirmation [System: UDF] lConfirmation : Number : 20003 Please suggest where I am doing it incoreectly. Thanks
updated Display with execute ,but still do not get the luck Input box is present but do not get the value on report Code: [#Menu: Gateway of Tally] Add : Item : Before : @@locQuit : Rpt Confirmation : Execute : Rpt Confirmation [Report: Rpt Confirmation] Form: frm Confirmation [Form: frm Confirmation] Part: Prt Title, Prt YesNo Full Width : No No Confirm : Yes Space Left : 5 Space Right : 5 Space Top : 3 Space Bottom: 3 On:Form Accept:Yes:Execute :rptMyReport [Part: Prt Title] Horizontal Align: Centre Lines : Form SubTitle Local : Field : Form SubTitle : Info : "Enter Number:" [Part: Prt YesNo] Horizontal Align: Centre Lines : ln Confirmation [Line: ln Confirmation] Add: Field: fldConfirmation [Field: fldConfirmation] Use: Number Field Storage:lConfirmation [Report: rptMyReport] Add: Form: frmMyForm [Form: frmMyForm] Add: Part: prtMyPart Width: 40% screen Height: 50% screen [Part: prtMyPart] Add: Line: lnMyLine [Line: lnMyLine] Add: Field: fldMyField [Field: fldMyField] Set as : $lConfirmation [System: UDF] lConfirmation : Number : 20003