passing the parameters to the SQL Query

[sunsree]

Hi!

iam using the following forumla to give some conditions to the field like

if
{?paramname} = 'All' then true --- (All is added manually in the default option to get in the dropdown list.)
else
{fieldname} = {?paramname}

and when i run the query everythig works fine but it is not passed on to the SQl query i wanted to improve the performance. It would be great if somebody can help me i tried the option perform grouping on server but it did not work......

Thanks in advance.

 

[Naith]

Database pass:

(
If {?Parameter} <> &quot;All&quot;
Then {Field) = {?Parameter}
Else
If {?Parameter} = &quot;All&quot;
Then True
)

Naith

 

[sunsree]

iT GIVES AND INVALID CHARACTER (DATABASE ERROR) IAM WRITING THIS IN THE WHERE CLAUSE EXACTLY HOW YOU HAVE GIVEN .......