runtime counter

[#1]

Hello everyone,

We are facing a problem with the flag that generate in runtime.Please see the attachment for details.

Thanks & Regards,

3 idots.

[#2]

DATE	QTY	FLAG	COUNTER
1/3/2011	50	0	0
1/4/2011	60	0	0
1/5/2011	100	1	0
1/6/2011	120	1	0
1/7/2011	100	1	0
1/8/2011	125	1	0
1/9/2011	30	0	0
1/10/2011	50	0	0
1/11/2011	140	1	0
1/12/2011	0	0	0
1/13/2011	145	1	1
1/14/2011	126	1	1
1/15/2011	124	1	1
1/16/2011	158	1	1
1/17/2011	135	1	1
1/18/2011	140	1	1
1/19/2011	163	1	1
1/20/2011	135	1	1
1/21/2011	120	1	1
1/22/2011	100	1	1
1/23/2011	110	1	1
1/24/2011	70	0	0
1/25/2011	58	0	0
1/26/2011	69	0	0
1/27/2011	45	0	0
1/28/2011	65	0	0
1/29/2011	87	0	0
1/30/2011	136	1	0
1/31/2011	147	1	0
2/1/2011	198	1	0
2/2/2011	148	1	0
2/3/2011	152	1	0
2/4/2011	35	0	0
2/5/2011	63	0	0
2/6/2011	147	1	0
2/7/2011	20	0	0
2/8/2011	100	1	1
2/9/2011	120	1	1
2/10/2011	132	1	1
2/11/2011	156	1	1
2/12/2011	168	1	1
2/13/2011	179	1	1
2/14/2011	153	1	1
2/15/2011	111	1	1
2/16/2011	124	1	1
2/17/2011	168	1	1
2/18/2011	12	0	0
2/19/2011	35	0	0
2/20/2011	36	0	0
2/21/2011	174	1	0
2/22/2011	45	0	0
2/23/2011	65	0	0
2/24/2011	141	1	0
2/25/2011	124	1	0
2/26/2011	153	1	0
2/27/2011	181	1	0
2/28/2011	144	1	0

Here our problem is stated as below :

We want to show the Counter as the calculated expression of a straight table.The calculation will be based on the Flag field ,if seven or more continuous 1 appear in the flag field then on the basis of the value of seventh position the one to sixth position will be filled with value corresponding to the value of seventh position of Flag field.For example-if in seventh position of the Flag field has value 1 then one to sixth position will be filled by 1 or otherwise if seventh position is equal to 0 then one to sixth position will be filled with 0 as we have shown above in the Counter field.

Thanks & Regards.

3 Idiots