How do I find all instances of a fieldname in a search pattern

[ann1]

I am searching for any mention of a fieldname in a list of helpdesk calls. What do I use to find all instances but limit the output to the unique call number. For instance in call number 50666 there may be three references to the fieldname but I only want the report to give me the call number once. Can anyone help?

 

[Naith]

Group by the call number.

In the details section, place a formula like:

If InStr({Field},"ThisIsTheStringImLookingFor&quot > 0
Then "Here's the field"

If you return a number instead of a string, you can total the instances up, and place the total in your group footer.

Naith

 

[kenhamady]

I would use:

If "String" in {Field}}
then 1
else 0


And sum this.

If the field is a memo you will need v9 to make this work. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com