Posted - 09/26/2012 : 00:19:33
| SELECT tblplsrptextract1.strSpyIDocType AS SPYDOCTYPE
, SUM(CASE WHEN tblplsrptextract1.strusriproduct = 'APP-NEW' THEN 1 ELSE 0 END) AS APPNEW
, SUM(CASE WHEN tblplsrptextract1.strusriproduct = 'APP-RENEWAL' THEN 1 ELSE 0 END) as APPRENEWAL
Now we want only
tblplsrptextract1.strusriproduct = 'APP-RENEWAL' to be present as field so that we can take that field in crystal report and take sum there, not in procedure..
Can someone help me on this???
I want to explore
Edited by - Somnath_lnt on 09/26/2012 00:24:07