List Report

[maheshmogula]

Hi All,

I have a requirement, where a user can type Emp Id. Based on that,a list will appear.(Emp id,Name,Sal).

My way of approach was, took a text box prompt and filtered on Emp id . but I am getting drop down with all emp ids but I require only text box where user can enter a particular emp id.

Regards,

Mahesh

[wyconian]

Hi Mahesh

Sounds like you've almost got it but sounds like you've associated a query with your prompt.  You just need to have a value prompt and then add a filter to your main query where emp_id = ?parameter_name?

[MFGF]

Did you add both a text box prompt and a filter manually?  If so, you may have ended up with two parameter filters on EMP ID.  Normally the prompt wizard will create the prompt, the parameter and the filter for you.  Check the query to see if you have an extra filter and remove it if you do.

Regards,

MF.

[maheshmogula]

Hi MFGF,

Thx for the reply..

Actually we are looking for a textbox,where user can enter the emp id(12345)manually.Not from dropdown prompt(12345,23456,34567......)

Regards,
Mahesh

[kattaviz]

Hi,

See if any parameters are in the filters section of the query. Also you have to use "=" in the filter section.

Steps:
1. Create a Textbox prompt. give a parameter name.
2. Create a filter in the query ([EmpID]=?param_EmpID?)