Aceept value from a form and display on a report

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

 

Can anyone help me on this??

 

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

 

Yes.

 

Yes as mPal2311 said...

 

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

 

use Execute attibute instead of display

 

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

 

can anybody help me on this ??

 

Can anyone Pls help me on this ??

 

dear Jainitya

use Alter attibute instead of Execute

 

Can we use this code as can we fetch deta from report to a single form from udf fields plzzz