topic Re: problem in report in Application Development and Automation Discussions

problem in report

Former Member — Tue, 12 Dec 2006 10:04:44 GMT

hi to all help me in this issue.

i had a problem in the outputof a simple report

LOOP AT ITAB_BSIS.

SORT ITAB_BSIS BY BELNR.

WRITE : /10 itab_bsis-bldat,30 l_duedate,45 ITAB_BSIS-blart,

60 ITAB_BSIS-BELNR , 70 itab_bsis-sgtxt,90 itab_bsis-dmbtr.

ENDLOOP.

in selection screen iam giving range of belnrs so i need to display document(belnr) no wise in differnt pages

how can i do it.

thanks in advance

kiran kumar

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:08:08 GMT

Hi Kiran,

Remove the sort statement inside the loop and put it outside the loop.

REgards,

Ravi

Re: problem in report

amit_khare — Tue, 12 Dec 2006 10:09:08 GMT

Hi,

first of all sort before the loop i.e.

<b>SORT ITAB_BSIS BY BELNR.</b>

LOOP AT ITAB_BSIS.

WRITE : /10 itab_bsis-bldat,30 l_duedate,45 ITAB_BSIS-blart,

60 ITAB_BSIS-BELNR , 70 itab_bsis-sgtxt,90 itab_bsis-dmbtr.

ENDLOOP.

Regards,

Amit

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:11:44 GMT

Hi Kiran,

Remove the sort statement inside the loop.

First sort the itab by belnr and then move the data for final display.

Regards

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:13:34 GMT

Hi ,

Try this way

SORT ITAB_BSIS BY BELNR.

LOOP AT ITAB_BSIS.

AT NEW BELNR.

NEW-PAGE.

ENDAT.

WRITE : /10 itab_bsis-bldat,30 l_duedate,45 ITAB_BSIS-blart,

60 ITAB_BSIS-BELNR , 70 itab_bsis-sgtxt,90 itab_bsis-dmbtr.

AT LAST .

Page Footer

ENDAT.

ENDLOOP.

Please Mark Useful Answers

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:14:40 GMT

hi i need to change the the top of page for each belnr like customer address

same logic can i keep there.

thanks in advance

kiran kumar

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:26:52 GMT

hi,

SORT ITAB_BSIS BY BELNR.

LOOP AT ITAB_BSIS.

AT NEW BELNR.

NEW-PAGE.

ENDAT.

WRITE : /10 itab_bsis-bldat,30 l_duedate,45 ITAB_BSIS-blart,

60 ITAB_BSIS-BELNR , 70 itab_bsis-sgtxt,90 itab_bsis-dmbtr.

ENDLOOP.

hope this helps,

do reward if it helps,

priya.

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:29:25 GMT

Hi,

Please use the below code:

LOOP AT ITAB.

AT NEW BELNR.

NEW-PAGE.

WRITE / ITAB-BELNR.

ENDAT.

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:34:56 GMT

Try at new belnr ... it will work

Re: problem in report

Former Member — Tue, 12 Dec 2006 10:58:17 GMT

yes you can use the variable belnr to get the customer address in the top of page event. Don't use loop there.