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 SkipVought 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
0
0
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
74
john432
john432
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
91
john432
john432
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
123
hilfy
hilfy
Kevin Mizzi
  • Locked
  • Question
Crystal reports Description contains bracket
Replies
11
Views
108
Kevin Mizzi
Kevin Mizzi
sjill
  • Locked
  • Question
Crystal Reports - Sub Report behaving as a hyperlink
Replies
4
Views
89
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top