how to write formula in crystal report

Sep 3 2015 8:46 AM

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

Answers (2)