wildcard with first letter? 1

[vhagerty]

CR 9 Enterprise with SQL database

I have a report that groups on the requestors name and has all the details of work by that requestor tied to a subreport. The main report is 68 pages long. I'm trying to find a way to use a wildcard so if the user doesnt remember the exact spelling of the requestors name they can use the first letter of the first name with a wildcard to limit the number of records.

Any suggestions?

Walks

 

[synapsevampire]

In the report->Edit Selection Formula->Record, try:

{table.firstname} like {?MyFirstNameParameter} & "*"

Asterisk is the wildcard for all, a question mark is used for just one wildcard character.

-k

 

[vhagerty]

That did the trick!!!
*doing happy dance*

Thanks alot Synaps!

Walks =)