Loading

how to write formula in crystal report

Danish Habib

how to convert this into crystal report formula

"

select

SUM(ISNULL(QT.QuestionTarget,0)+ISNULL(QT.QT_FormMen,0)+ISNULL(QT.QT_ForWomen,0)+ISNULL(QT.QT_ForGirl,0)+ISNULL(QT.QT_ForBoy,0)) AS TARGETTOTAL

from QuestionTarget AS QT Where Year=5 AND QT.District=8

"

where 8 is parameters you can write ?districtID

any one help thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Danish Habib11y ago
I am asking about where cluase i am wrote formula using sum function but how to achieve where clause where districtId=7 how to achieve this
Debasis Saha11y ago
You can use the sum function in the crystal report formula editor. Since it crystal report these fields are treated as a field where you can use sum() function for formula editor.