Picklist????

[jdemmi]

Is there a formula that can be created to create\manage a picklist for parameter values? I have seen other posts in these forums where many of you have handled this programatically, but that is not an option in the environment I am working in. Basically what I want\need to do (in Crystal 7) is to either have the possible parameters "in synch" with values from the database, or "warn\inform" the user that the parameter entered is NOT a valid parameter. (This could be done post execution)

CRUDE Example:

Table = USER_NAMES
Columns = FIRST_NAME, LAST_NAME, MIDDLE_NAME
Report is selecting all records.
Parameter is LAST_NAME.
If a user enters JONES in the LAST_NAME parameter field I would like the user to be notified if NO "JONES" exists in the LAST_NAME column.

(I know that many of you are saying, DUH! If no records are returned then there must be no JONES in the table. But remember this is a CRUDE example. And in the case of the report I am working with NO RECORDS could be returned EVEN if the PARAMETER is correct. So how would the user know????)

 

[dgillz]

See faq149-1485 on picklists.

In terms of a messgae to display if no names are found, I would create a formule like this:

"There are no "+{?Parameter}+" records in the database"

And lay this right on top of the details that would normally print, then conditionally supress it if any records are found.
Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com