Crystal report sql expression field
Posted
by Domnic
on Stack Overflow
See other posts from Stack Overflow
or by Domnic
Published on 2010-01-12T10:35:29Z
Indexed on
2010/05/17
2:10 UTC
Read the original article
Hit count: 337
im using asp.net crystal report and this is sql query CONVERT(NUMERIC(8, 2), CASE WHEN CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END = 0 THEN NULL ELSE CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END END) Q3_DR, CONVERT(NUMERIC(8, 2), CASE WHEN (- 1 * CASE WHEN GLDD_DOC_AMOUNT < 0 THEN GLDD_DOC_AMOUNT ELSE 0 END) = 0 THEN NULL ELSE - 1 * CASE WHEN GLDD_DOC_AMOUNT < 0 THEN GLDD_DOC_AMOUNT ELSE 0 END END) Q3_CR,
i want to write this query into crystal report sql expression field how can i convert this?
© Stack Overflow or respective owner
