i want want only completed batches in my report based on given selection date.
suppose a batch start on 28.04.2007 and ends on or completed on 01-05.2007 this is partial batch for
both the month .but if user inputs the date 01.04.2007 to 30.04.2007 we can easily trace the completed
batches as flag is there for partial and compltd batches.
date batch pcharg(Partial) charg(completed)batch
27.08.2007 v1002 X
28.04.2007 v1003 X
29.04.2007 v1003 X
30.04.2007 v1003 X
01.05.2007 v1003 X X
as u c the above table the batch is completed on 01.05.2007
but if the user inputs 01.05.2007 it is partial it should be considerd
if he inputs 01.03.2007 to 31.05.2007 it should be considered as completed
Iam not getting the logic to pick up the completed batch on based on selection
if i give the condition
if pcharg <> 'X' and ccharg = 'X'.
retrive completed batch
it will be work fine if the input given is 01.03.2007 to 30.04.2007
but it will be wrong for if the input given is 01.04.2007 to 31.05.2007
pls help me out in this .
answers will be rewarded points.