SEARCH for value in Selection Parameter

[smilbert]

That description may be confusing.

Crystal XI, SQL 2000

I've got a ReferringMD table that has about 2000 entries.
I've built a report that allows the user to select ONE Referring MD.

The problem is that they must know the EXACT spelling of the ReferringMD (first and last).

If I create a DYNAMIC parameter list, it doesn't give all Referring MDs.

Is there any way that they could enter a few characters and be prompted with a list of the matching Referring MDs to select from?

 

[Turkbear]

Hi,
Thete is a limit on the number of values a parameter list can contain by default..

See this thread thread767-1498084
and look at the last entry.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You could try the following. It worked when I tested it. Go to database->add command and enter something like the following, creating the string parameter within the command:

select table.referringMD
from table
where table.referringMD like '{?Name}'+'%'

Do not link the command to the table (ignore the message) and do not reference the command in the main report except to populate the parameter list by doing the following:

Open the parameter {?Name} in the main report and change it from static to dynamic and select {comand.referringMD} from the dropdown list as the value and check "create parameter" on the right.

Then go to report->selection formula and enter:

{table.referringMD} = {?Name}

-LB