topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Mon, 11 Dec 2006 18:35:31 GMT

hi to all

help me this issue

i have devoloped a simple report and need the customer address at the top in

output.

below that

the invoices records text needs to be displayed

thanks in advance

kiran kumar

Re: Report

Former Member — Mon, 11 Dec 2006 18:39:57 GMT

Use the event TOP-OF-PAGE and write the code under that to display the customer address.

- Guru

Reward helpful answers

Re: Report

Former Member — Mon, 11 Dec 2006 18:44:17 GMT

Hi Kiran,

If you want to display report at the top in output, use the event <b>TOP-OF-PAGE</b> for a simple report and <b>TOP-OF-PAGE DURING LINE-SELECTION</b> for an interactive report.

TOP_OF_PAGE.

WRITE:/ 'Customer Address'.

Thanks,

Vinay

Re: Report

Former Member — Mon, 11 Dec 2006 18:51:15 GMT

hi can u provide sameple example code.

thanks & regards

kiran kumar

Re: Report

Former Member — Mon, 11 Dec 2006 18:58:44 GMT

HI,

Check the below code....

1. If you want to display details for one customer the follow the below procedure.

start-of-selection

End-of-selection

Top-of-page

2. If you want to display details for many customers, then follow the below procedure

start-of-selection

End-of-selection

sort <itab> by customer.

loop at <itab> into <work area>.

at new customer.

endat

endloop.

TOP-of-page

I hope you got the answer.

Regards,

Vara

Re: Report

Former Member — Mon, 11 Dec 2006 19:03:11 GMT

TOP-OF-PAGE is a event and can be written anywhere in the main program.

So in your code write:

TOP-OF-PAGE.

Write : ' Customer Name ' , Kan1-Kunnr.

Etc.

Similarly you can code other fields also.

- Guru

Reward answers if helpful

Re: Report

RichHeilman — Mon, 11 Dec 2006 19:13:56 GMT

Basic Coding, nothing fancy.



report zrich_0001.

data: ivbrk type table of vbrk with header line.
data: xkna1 type kna1.


start-of-selection.

  select * into table ivbrk from vbrk
                 up to 500 rows.

  sort ivbrk ascending by kunrg.


  loop at ivbrk.
    on change of ivbrk-kunrg.
      new-page.
    endon.
    write:/ ivbrk-vbeln.
  endloop.


top-of-page.

  select single * into xkna1 from kna1
             where kunnr = ivbrk-kunrg.
  write:/ xkna1-kunnr.
  write:/ xkna1-name1.
  write:/ xkna1-stras.
  write:/ xkna1-ort01, xkna1-regio, xkna1-pstlz.

Regards,

Rich Heilman

Re: Report

Former Member — Mon, 11 Dec 2006 19:22:11 GMT

Hi Kiran,

You should get the Customer addresses before the first WRITE statement in your report because TOP-OF-PAGE will be trigger for first WRITE statement in your report.

You can have a query on KNA1 to get the addresses.

You can place this code in your START-OF-SELECTION or AT SELECTION-SCREEN.

SELECT KUNNR LAND1 NAME1 ORT01 PSTLZ STRAS

FROM KNA1

INTO TABLE IT_KNA1

WHRE KNA1 IN S_KNA1.

TOP-OF-PAGE.

WRITE:/005 IT_KNA1-KUNNR,

015 IT_KNA1-NAME1,

035 IT_KNA1-STRAS,

055 IT_KNA1-PSTLZ,

075 IT_KNA1-ORT01.

Thanks,

Vinay