Actualy Below SQL posted by myself .
Actually in this site_cd & tot_amt these r the columns prsented in base common data only ,in non vehicle billing data site_cs & Tot_amt columns r not there.
SELECT BA_CHG_TO_SITE_CD SC, SUM (BA_INV_TOT_AMT * -1) TOTAL
FROM MXGFLVB1.BASE_COMMON_DATA T1,
MXGFLVB1.BASE_NON_VEHICLE_BILLING_DATA T4
WHERE T1.BA_REC_SOURCE = T4.BA_REC_SOURCE
AND T1.BA_REC_TYPE = T4.BA_REC_TYPE
AND T1.BA_POINT_OF_SALE = T4.BA_POINT_OF_SALE
AND T1.BA_SEQ_NO = T4.BA_SEQ_NO
AND T1.BA_PRCS_TYP_CD = T4.BA_PRCS_TYP_CD
AND T1.BA_PRCS_TYP_CD = 'TR'
AND T1.BA_CURR_FING_TRMS_CD = 'X'
AND BA_BUSN_DATE >= '2009-11-01'
AND BA_BUSN_DATE <= '2009-11-13'
AND BA_CHG_TO_SITE_CD BETWEEN '01100' AND '09944'
GROUP BY BA_CHG_TO_SITE_CD
Pls Suggest me how 2 start the procedure
Krish,
This is a Cognos forum ..
Also please do post identical questions in multiple sections. Pick the one that fits best..
Apart from the above.. What is it that you want to do? And procedure are you refering to?
Sorry!
I done this report its working