Skip to Content
0
Former Member
Jan 27, 2008 at 04:23 AM

row removal

15 Views

I have a report which shows the result of a audit .It have several items and material doc num , date, line item..ect.

Now if certain items dosent have a material document number , I want to remove those particular rows from the output, or else its taking in the value from the previos mat doc num and printing it beneath other items which dosent have a material document number.How do I eliminate those items which dosent have a material docu numer.

plant sloc mat doc num.

phy inv doc.

material

diff amt

diff qt.

123

ct

490000938

100000293

1000

23.56

10

123

ct

100000293

1000

23.56

10

123

ct

100000293

1000

23.56

10

123

ct

490000938

100000293

1000

23.56

10

123

ct

490000938

100000293

1000

23.56

10

Above is an example . I wnat to remove the rows 2nd and 3rd and any other which dosent have a mat doc num , as it still takes the diff amt of the above mat doc num and prins it .Kindly suggest how to eliminate those rows which dosent have mat doc num .

Thanks