SUBSTRING(SLAC_CNTRL_ACNO, 3, 4)
how can i use this query in crystal report
A:
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.
Craig
2010-01-22 04:06:21
but how can i import to crystal report formula editorit contains many function except substring
Domnic
2010-01-22 04:48:23