topic Re: Report Display in Application Development and Automation Discussions

Report Display

Former Member — Fri, 20 Oct 2006 06:18:03 GMT

Hi,

In a report from the intrnal table i sort descending by date.but i want to display the top first data should be displayed in a field1 and the top second data should be displayed in the field2.means the field 1 is the latest updated and the field 2 is last updated(befor the latest updated).They want to see the latest updated data and the previously updated(before the latest)data. so help me to display this prog.

Thanks,

Raj.

Re: Report Display

Former Member — Fri, 20 Oct 2006 06:20:51 GMT

Hi,

You can use control statement at first and at last in the loop.

After sorting the internal table.

Loop at itab.

at first.

***display first record

at last.

display last record

endloop.

or if you want first and second record then just read the internal table with index.

sort the internal table.

read table itab index 1.

read table itab index 2.

Hope this helps.

Re: Report Display

Former Member — Fri, 20 Oct 2006 06:30:41 GMT

Hi Rajendra

Sort by date itself might not solve your case.

Please try to find another field which can differentiate the latest, maybe some thing like time or document number.

After finding another field for the same, sort internal table with both fields descending and then read by index 1 & 2 to retreive the latest and the last before latest.

Kind Regards

Eswar

Re: Report Display

andreas_mann3 — Fri, 20 Oct 2006 06:31:37 GMT

Hi,

use method of Ahmed (read your desc. sorted tab with index 1 and 2) , but put values in a new itab with the fields field1 and field2.

Re: Report Display

Former Member — Fri, 20 Oct 2006 07:00:13 GMT

Hi,

Here i getting for the one material only,but i want to show for multiple material no.the index is taking for the first material no of the latest updated data and last updated dated date based on sort by descending the date.but my requirement is to display for all the material no i want to show the latest and last updated data.help me to solve it.

Thanks,

Raj.

Re: Report Display

Former Member — Fri, 20 Oct 2006 07:17:48 GMT

Hi,

Thanks,

Raj.

Re: Report Display

Former Member — Thu, 17 Sep 2009 01:56:58 GMT

solved