Hi all,

I'm new to the world of Crystal (but no means Access) and wonder if I might ask what's hopefully a simple question please:

I have a number of reports for which I'd like to produce dynamic parameters - the list of values can't be pulled straight from the relevant table as some of them are soft deleted, which is indicated by an boolean attribute either set to 0 or 1.

So for example, I may want to produce a dynamic list consisting of Names pulled from a table:

Bob Jones
John Smith


but in the table the list will appear like:

Analyst_Name Deleted
Bob Jones 0
John Smith 0
Joe Bloggs 1

As Joe has been soft deleted, I don't want him in the parameter list - any ideas how I could achieve this please?

Thank you :)