How to load records from a table based on parameter value

[rahulhv1]

Hi,

I have a table of contains DEPT,MCNO, ATTDATE, LNAME. I wish to load data on the basis of parameter value of DEPT.

i.e. if i set value of parameter DEPT = 'HR' then rows having dept HR should be retrieved.  In above example i do not want to create any LIST BOX for any selction. I just want end user to write name of the dept. and data shuould be filterd out.

[Gysbert_Wassenaar]

Add a searchbox object. Add only the DEPT field and set the Default Search Mode to Use Normal Search

Or add an inputbox object to your sheet and create a new variable for it, e.g. vDept. Then open the document properties window and go to the Triggers tab. Select the vDept variable and click on the Add Action(s) below OnInput. Add a Select in Field action. Use DEPT as field and =vDept as Search string.

[sujeetsingh]

Gysbert is right you can set a variable with the given DEPT value and then use conditional load with exsist function .