2
Reply

how to write formula in crystal report

Danish Habib

Danish Habib

Sep 3 2015 8:46 AM
463
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)