Good Day,

I am having trouble with the InStr function in Crystal.

I am using Crystal Report s XI.

Here are my fields in my report:

Field Headers
Company                   Ticket Number                Company_Multiple
xyz company              C123456                        abc company def company                                                                                ghi company jkl company

The Company Multiple field is a memo field.

The data in the field may have a number of spaces in between each company entry. In some cases, the field data could look like this:

abc company             def company ghi company            jkl company

I created a formula called CompanyAffected
============================================
numberVar i := 0;
numberVar j := 0;
stringVar out := " ";
stringVar array test := split({cm3rm1.company_multiple}, chr(10)+chr(13) );
i := ubound(test);
if i > 0 then
   for j := 1 to i step 1 do
        out := out + UpperCase(test[j]) + " ";
out
============================================

I then have a parameter called ?My Parameter. This parameter would allow a user to type in a Company name to get all the Ticket Numbers where the Company is in the company_multiple list.

In my record selection, I have put in:
==============================================

InStr ({@CompanyAffected},(" " + Uppercase({?My Parameter}))) <> 0
===================================================

My problem is:

In the case where I the company_multiple look like this:

abc company


def company
ghi company


jkl company

I can choose the parameter of abc company and the tickets will come back.

But, if I choose the company def company or jkl company, the records won't appear. It's like my formula will only see the company if it is the first entry in the company_multiple list. How can I get the tickets for a company if they are not the first entry in the company_multiple list?

Thanks,

Jennifer

Thanks DBlank. That worked perfectly. You're the best!!

I have no idea why the original developer of this report designed the formulas that way.

Ok, I have found a solution that should work for me.

If you go to:
1) Format Field
2) Paragraph Tab
3) Click the drop-down menu for Text Interpretation
4) Change the Text Interpretation to HTML text

The field now looks like
abc company bcd company def company efg company

It doesn't have the commas, but it looks so much better!

Hope this helps someone else out.