Discrete or 'All' parameter 1

[IceRuby]

Hi there
Using Crystal V9.0 to SQL server.
I have two parameters - 1st to select table (string) and 2nd to select product (number).
Users would like to be able to select either a single product value or wildcard for all. Is this possible?

e.g. Select required table (parameter 1) (mandatory)
Select discrete product number or * (* should provide listing of all product numbers within parameter 1)

Tried code within record selection:
If ?parameter = [0] then //0 equivalent to *
true
else
{table.field} = ?parameter

but entire report hangs.

Appreciate your help, thanks in advance

 

[dgillz]

Create default values for your parameter of "All". Then write a record selection formula:

If {?ProductParamter}="ALL" then true else
{ProductField}={?ProductParameter}

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com