ALV Report Issue

[Former Member]

I have an ALV report which has a TOP_OF_PAGE form that is triggered at event top_of_page, where i am printing the header information.

The problem is , if i run the report in background and download that in an XL sheet(SM37), the header information repeats at regular interval (recurring occurance of TOP_OF_PAGE)

However when this is run in foreground, this doesn't happens.

Let me know how to stop the top of page header information for more than one time while Execution in background.

[Former Member]

I have an ALV report which has a TOP_OF_PAGE form that is triggered at event top_of_page, where i am printing the header information.

The problem is , if i run the report in background and download that in an XL sheet(SM37), the header information repeats at regular interval (recurring occurance of TOP_OF_PAGE)

However when this is run in foreground, this doesn't happens.

Let me know how to stop the top of page header information for more than one time while Execution in background.

[anversha_s]

hi,

chk this.

if sy-binpt. "back ground job

restrict top_of_page only once

else.

in for ground ur need

endif.

rgds

anver

if hlped rwrd points

if helped

[Former Member]

then you can use TOP_OF_LIST event.

populate the same form name to this EVENT instead of TOP_OF_PAGE event. this will trigger only once in the execution.

Regards

srikanth

Message was edited by: Srikanth Kidambi

[Former Member]

When executed at the background, as i obtain the list in XL sheet, the header data is getting repeated for every top_of_page.

Now , I am catching the event 'top_of_list' instead of Top_of_page, and it solved the purpose to an extent now the problem is : the column header is getting repeated at regular interval (repeated occurance of top_of_page form),

This is happening only in the case when i execute the report in background and download the result in XL.

Pl suggest how to supress the multiple occurance of column heading.

regards

Alok Pathak.