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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need a formula to pull the record contain with the value in the field

Status
Not open for further replies.
huichun

huichun

Programmer
Joined
Jul 24, 2002
Messages
8
Location
US
I am trying to use following record selection formula to pull record contain with value (G) in the field but with no success, please help.

'G' in {recap.batchnmber}[3] ** any batches contains G in position 3

Huichun

 
Sort by date Sort by votes
I don't see why that wouldn't work. Is it throwing an exception or just not returning any records?
 
Upvote 0 Downvote
ok, that worked. Now I need record without "G" in 3rd position. Any thoughts?

 
Upvote 0 Downvote
You can always use a NOT, as in:

not('G' in {recap.batchnmber}[3])

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
424
DjangMan
DjangMan
smmt2207
  • Locked
  • Question Question
Text field formula help
Replies
1
Views
712
hilfy
hilfy
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
717
SoftwareRT
SoftwareRT
Kennymc
  • Locked
  • Question Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
344
Kennymc
Kennymc
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top