Crystal Reports 7 parameters based on previous parameters

[knappagh1]

Is it posible to make the selection criteria for a parameterto be based on what was selected in a previous parameter

For example my first Parameter is Category and contains the following:
All
Design
Manufacturing
Operations

If I select Design then the second parameter options give me:
Walls
Floors
Roof

If I select Manufacturing then the second parameter options give me:
Machine
Saw
Hammer

etc

 

[lbass]

You could set up a record selection formula like this:
(
if {?Category} <> "All" then(
select {?Category}
case "Design" : {table.field1} = {?Design}
case "Manufacturing" : {table.field2} = {?Manufacturing}
) else
if {?Category = "All" then
true
)

-LB

 

[knappagh1]

Sorry a bit confused

case "Design" : {table.field1} = {?Design}

what does {table.field1} represent ?

 

[lbass]

You should plug in whatever field that you would selecting based on the {?Design} parameter. This assumes you have separate parameters per parameter1 option.

-LB