for each partno in that corresponding month each day i need order received and order completed detail like above.order date not available for all days in months.So how to get all days from start to end and 0 for order details if orderdate not available.I am using oracle 8i and front end is vb6.
I am displaying in third party grid control for excel download.Thanks in advance!
This is the sample standard query...........I think it will help u to gimme solution....I need output for selected partno alone.
, NVL(SUM(A.SO_QTY),0) OrderRecieved
, NVL(SUM(A.SO_QTY_DESP),0) OrderCompleted
C.SO_YEAR = A.SO_YEAR
And C.SO_NO = A.SO_NO
And A.SO_YEAR = D.JOB_SO_YEAR
And A.SO_NO = D.JOB_SO_NO
And A.SO_SL_NO = D.JOB_SO_SL_NO
And A.SO_PART_NO = B.PART_NO
And C.SO_DATE >= '01-dec-2003'
And C.SO_DATE <= '31-dec-2003'
and B.PROD_GROUP||B.GB_COL2 in ('AS16','AS20','AS25','AS30','AS35','AS45','AS55',