Database field not listed in formula editor

[rsknut]

Hello,
I have two text fields of length 254 in a query created in PeopleSoft Query. In Crystal, I am unable to view the two text fields in the formula editor. Why? The text fields do show up as database fields in the field explorer window, though.

PeopleSoft version: 8.4
Crystal Reports version: 8.5

Thanks in advance!

 

[dgillz]

If the data type is memo or blob fields, they are not available to be used in formulas and therefore will not appear in the formula editor window.

If this is not the case, verify your database under database, verify database.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[rsknut]

The data type of the text field is of mixedcase character type. I'm not familiar with memo and blob data types? Could you explain?

Thanks again!

 

[dgillz]

Open the field explorer by clickin on insert, field object, database field. Make sure the far right hand icon is depressed. This will display the data type and length of the field to the right of each field. When you do this, what does it say?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[rsknut]

It says 'String[254]'

 

[dgillz]

Well, then it should be available in the formula editor. If it is not, write a simple formula like this:

length({YourField})

You will have to manually key in the field name and the brackets. See if it returns an error when you try to save the formula.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com