Hello,

I created a report with the query below.

Select * from employee_table where employee_name = {?Ename}.

People may choose to enter a name or may want to see all the employee names.

So I created a default called 'All' for the parameter Ename and created a formula called e_formula stating that

if   {?Ename}  in  {employee_table.Ename} then
{employee_table.Employee_name} else if
{?Ename} = 'All'
then True.

In the select expert set the condition to True.

This works fine , user gets a prompt to enter 'All' for all users else enter 'Employee name' they wish to find.

Now the users feel its too much to enter 'All', cant they just leave it blank which should default to 'All' and proceed to execute the report?

Is there any way to do this?

User will enter Employee name if he wants to find a specific user, else will just ignore that parameter and click on Run to execute the report.

Please advise.
Nammu