CR ver 8.0
ODBC database
Great Plains ver 8.0
I'm not sure if this is a Crystal problem, or a Great Plains problem.
I have created a Crystal Report to show the notes added to an order by using SOP30200 (Orders History) linked to SY03900 (Notes Table) with a left outer join on NOTEINDX.
Table SY03900 shows 5 fields
NOTEINDX
DATE1
TIME1
DEX_ROW_ID
TXTFIELD
I have inserted TXTFIELD into the report using Field Explorer and it is displaying the results as expected.
Now I wish to do a search of the TXTFIELD for a particular string of 6 numbers, a batch code. The problem is when I try to create a formula using Formula Editor, the TXTFIELD is not visible. The other 4 fields in the SY03900 table are there, but not the one I want.
Assuming someone can help me find the text, what would be the format of a formula to search for a particular sequence of characters in a string i.e. is there a function available in CR v 8.0 equivalent to "Contains" ?
ODBC database
Great Plains ver 8.0
I'm not sure if this is a Crystal problem, or a Great Plains problem.
I have created a Crystal Report to show the notes added to an order by using SOP30200 (Orders History) linked to SY03900 (Notes Table) with a left outer join on NOTEINDX.
Table SY03900 shows 5 fields
NOTEINDX
DATE1
TIME1
DEX_ROW_ID
TXTFIELD
I have inserted TXTFIELD into the report using Field Explorer and it is displaying the results as expected.
Now I wish to do a search of the TXTFIELD for a particular string of 6 numbers, a batch code. The problem is when I try to create a formula using Formula Editor, the TXTFIELD is not visible. The other 4 fields in the SY03900 table are there, but not the one I want.
Assuming someone can help me find the text, what would be the format of a formula to search for a particular sequence of characters in a string i.e. is there a function available in CR v 8.0 equivalent to "Contains" ?