New to Crystal 11 - need help with criteria and parameters

[alwayslrN]

I've been thrown into the fire and asked to make some reports using Crystal 11. To date I have not used this version. I don't have a book for reference and I do not think Crystal help can help.

I have set up 2 dynamic parameters usings fields from a database. Lets say field1 is Department, field2 Position, and field3 is Employee. Based on the department selected, the the list of positions and employees change on down the line. What if I wanted to return all records, i.e. all departments, all postions, and all employees? How would I handle that?

 

[alwayslrN]

I just realized I asked a very stupid question. I just need to instruct the users to choose ALL for each field. DUH!!

 

[synapsevampire]

Excellent question, and fairly common.

They can use the Select All option within the parameter, or you might use a COmmand Object as the source for the parameter and embed the "...All" choice within using a UNION ALL:

select '...All' as Department, '...All' as Position, '...All' as Employee
UNION ALL
select Department, Position, Employee from table

Then in the record selection code for all, as in:

(
if {?MyParm} <> "...All" then
{table.department} = {?MyParm}
else
true
)

-k