crystal report substring

SUBSTRING(SLAC_CNTRL_ACNO, 3, 4)

how can i use this qu开发者_开发百科ery in crystal report

Instead of substring, Crystal Reports uses mid function:

mid(SLAC_CNTRL_ACNO, 3, 4)

Either the entire SQL query needs to be in a Command OR you can use a SQL Expression field if the sub-query returns a scalar value.

See my posting, Crystal Reports: Using SQL Expression Fields.