troubleshooting Question

Dealing with large customer lists as a parameter in Crystal

Avatar of Brandon
BrandonFlag for United States of America asked on
Crystal Reports
26 Comments2 Solutions304 ViewsLast Modified:
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..

Join our community to see this answer!
Unlock 2 Answers and 26 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 26 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros