Im trying edit a report that uses dynamic prompts for the selection criteria..
I want to be able to select one customer at a time and be able to show all there orders over time. Seems relatively simple but the issue is that the client list is huge, say a couple thousand..
So what happens is crystal builds the prompt and shows 5 sections , all of the A;s and a few B's
I think I could do a wildcard type situation but im stumped on the syntax..
So if a user searched for a customer smith maybe they could enter a smi* or sm*? only issue is Im not sure how to do this..
Name field is a string and the DB is mssql..