Record selection with multiple parameters

[suecobb]

I know there must be a very simple solution to my problem, but it is eluding me. I want the users to be able to run a report on either a specific stockid or ALL stockids as well as on a specific owner or ALL owners. In the default values for the parameter, I have listed the individual stock classes and an item called "All Classes". The default value for the owner is "Active Certificates" and the user is able to type in specific ids if desired. The last entry here is to get only active certificates. When I run the report as is, the last statement is working, but not the parameters. I have tried AND between the if expressions and before the final expression, but it doesn't work either. If anyone can help me with the syntax, I appreciate it greatly.

If {?StockClass} = "All Classes" then
{Certif.stockid} = {Certif.stockid}
else
{Certif.stockid} = {?StockClass};
If {?Beneficial Owner} = "Active Certificates" then
{Codes.desc} = {Codes.desc};
else
{Codes.desc} = {?Beneficial Owner};
{Certif.dispdt} = Date (1899, 12, 30);

Thanks!

 

[kruby]

see thread767-99969

 

[suecobb]

Thanks! I did a search before submitting the question, but obviously I wasn't very thorough.