Selection Expert bug

[sammybee77]

I'm trying to select a formula, but for some reason the formula doesn't appear in the selection expert - does anyone know how I can force it to appear. Cheers

 

[synapsevampire]

It's probably a long varchar or memo field, Crystal won't let you use those in formulas, they need to be converted.

You can do so using the SQL Expression, or offload it back to the server to parse the field first.

example in Oracle:

substr(MyTable,MyLongColumn,1,254)

Don't place the log field into the report and then try this, Crystal will choke.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

If your formula uses one of the followng, it won't appear in record select formula editor:

Summary functions (like sum/average/etc)
Next/Previous functions
Shared Variable
Variable that is WhilePrintingRecords Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[glauco]

Hi,

These guys are quite right, i had this same problem, i got the answer creating a view with the column and using a function as described early in this page, i tell you this so you don't get confused in using a sql expression in crystal, it'd not work, you must use a function in the server.

 

[synapsevampire]

Ooops, a "formula"...

<sheepish grin>

What Ken said, I was referring to datatypes.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com