topic Sorting in Classical report in Application Development and Automation Discussions

Sorting in Classical report

Former Member — Wed, 27 Jan 2010 12:25:34 GMT

Hi,

In my classical report, Am having four columns. I have shown below.

orderno. order date, matl code, qty

1234567 02012010 ball bearing 10

1234567 02012010 ball bearing 20

1234567 02012010 ball bearing 30

But my requirement is to delete the repeated orderno date and matl code.

As shown below.

1234567 02012010 ball bearing 10

30.

Thanks

Arvind

BH2408 — Wed, 27 Jan 2010 12:29:14 GMT

Hi ,

Is this done for the report display or only internal table sorting?

Report display Try for the At new or on change of in the Loop to display in the output.

Regards,

Bharani.

Former Member — Wed, 27 Jan 2010 12:30:51 GMT

loop at itab into wtab.

at new field1

write : wtab-f1 , wtab-f2,wtab-f3.

endat.

write : wtab-f4

endloop.

specify ur vline and uline position according to ur requirement

Former Member — Wed, 27 Jan 2010 12:37:53 GMT

Hi,

Try as below ---


sort <internal table> by orderno,date,matl code.
delete adjacent duplicated from <internal table> comparing orderno,date,matl code.

Regards

Arbind