Note Text field not available ?

[jonbarr]

GP ver 8.0
CR ver 8.0

I have created a Crystal Report to show the notes added to an order by using SOP30200 linked to SY03900 with a left outer join.
Table SY03900 shows 5 fields
NOTEINDX
DATE1
TIME1
DEX_ROW_ID
TXTFIELD
I have inserted TXTFIELD into the report 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, or use the select expert on a record, the TXTFIELD is not visible. The other 4 fields in the SY03900 table are there, but not the one I want.

I have been using CR with GP for over two years now, and have never encountered this problem of not being able to view fields in a table. Any suggestions ?

 

[jazgeek]

create a formula called "text" set it's value as TXTFIELD, use that as your restriction

seems crystal can't see a field that is classed as TXT in a sql database table. The above fools crystal and converts the field to something crystal can get it's hands around.

-----------
and they wonder why they call it Great Pains!

jaz

 

[jonbarr]

Hi jaz, good to hear from you again, and thanks for your suggestion. Sorry for the delay in reply due to month-end chaos here.

I'm not sure about your formula though.

If I enter just TXTFIELD as a value in Formula Editor, I get the error message "the remaining text does not appear to be part of the formula"

If I enter the correct field name as {SY03900.TXTFIELD} I get the error message "This field name is not known"

I can see (and use) the field in "Field Explorer" but not in "Formula Editor".
Any other suggestions ??

 

[jazgeek]

If I remember correctly, you're on an old version of crystal. Time to upgrade

inserting the field from explorer into a formula called text works for me in crystal 9



-----------
and they wonder why they call it Great Pains!

jaz

 

[jonbarr]

Yes, still on CR 8.0.
I'm sorry, but can you explain how you are
<<inserting the field from explorer into a formula called text works for me in crystal 9>>

The only way I know how to creat a formula is in "Formula Editor" and as explained, the field is not visible there.

As soon as I switch from Field Explorer to Formula Editor, the field disappears ! I've tried typing it in, but just get the error messages as detailed above.

 

[jazgeek]

in formula editor make a new formula called "test"

in the formula editor make a formula like this

testfieldname = {SY03900.TXTFIELD}

now you should be able to use the formula "test" as a parameter in your selection.



-----------
and they wonder why they call it Great Pains!

jaz