Missing Formula Fields 3

[gav12345]

Trying to create a fairly basic formula using the formula editor in CR 8.5. The problem is, some of the database fields do not appear in the formula editor (they do appear in the Field Explorer). I understand from other threads in the forum that this is related to the field type (all the missing fields are type varchar2000).

I've read that the solution to this is to truncate the field using a SQL Expression then use that in the formula. - The problem is, the varchar2000 type does not appear in the SQL Expression editor either. How do I get round this?

Thanks in advance, Gavin

 

[synapsevampire]

The field won't appear, just manually type it.

Try something like:

CAST(MYFIELD as varchar(250))

This is dependent upon the database uused, something you need to include when asking for database assistance.

Should work though.

-k

 

[synapsevampire]

Ahhh, you gave yourself a star!

 

[gav12345]

It wasn't me, honest! - I've just been just trying to figure out what the stars were for, thought someone must have thanked me for a valuable question!

- Thanks for your answer anyway, that did the trick. Database is Oracle 805, I used {fn LEFT(MYFIELD,250)} which looks ok.

Gavin

 

[Madawc]

Unless you have a different set-up from the one I see, there is no option to give yourself a star. Though you can red-flag yourself, oddly enough.

Madawc Williams (East Anglia)

 

[synapsevampire]

I'm tempted to red flag myself often, Madawc...

-k