Skip to Content
Former Member
Jun 22, 2007 at 07:09 AM

Re Report issue



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

as completed.

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.