Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report Help 1

Status
Not open for further replies.
john432

john432

Technical User
Jan 8, 2024
8
US
Hello,

My current report shows all the Job IDs for a specific date but I need to have these searches exclude any Job ID that starts with the letter "L". What would that formula look like?

Best Regards,
John
 
Sort by date Sort by votes
Add something like the following to your Record Selection formula:

Code: 
NOT({YourTable.YourField} STARTSWITH['L'])

Hope this helps

Cheers, Pete.
 
Upvote 0 Downvote
Good Morning Pete,

This is a huge help thank you.

Best regards,
John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Crystal Report
Replies
2
Views
201
john432
john432
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
241
john432
john432
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
211
jchewsmith
jchewsmith
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
375
hilfy
hilfy
Kevin Mizzi
  • Locked
  • Question
Crystal reports Description contains bracket
Replies
11
Views
215
Kevin Mizzi
Kevin Mizzi

Part and Inventory Search

Sponsor

Back
Top