CODEWITHSUNDEEP
crystal-reports
Domnic
Domnic

Reputation: 3867

crystal report substring

SUBSTRING(SLAC_CNTRL_ACNO, 3, 4)

how can i use this query in crystal report

Upvotes: 0

Views: 8935

Answers (2)

Thuy Vu
Thuy Vu

Reputation: 11

Instead of substring, Crystal Reports uses mid function:

mid(SLAC_CNTRL_ACNO, 3, 4)

Upvotes: 1

craig
craig

Reputation: 26272

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.

Upvotes: 0

Related Questions