Page breaks appear in the spool output of report when run in the background

[Former Member]

Hi All,

Report is using fm 'REUSE_ALV_GRID_DISPLAY' to display the report. parameters passed to this fm for display are :it_fieldcat,is_layout,it_events,t_outtab.

Page breaks appear in the spool output when report is run in the background.These page breaks needs to be removed. When executed in the background, the excel extract should be the same as if pulling directly from the report itself.

How to remove the page breaks in background?

Thanks & Regards,

Abhishek Singh

[vinod_vemuru2]

Hi,

Not sure if you can avoid this. But have a look at below WIKI which has code sample for converting the spool in list format to Grid format. You can download from Grid.

[http://wiki.sdn.sap.com/wiki/display/Snippets/ConvertSpoolListtoALV+Grid]

Thanks,

Vinod.

[Former Member]

Hi Vinod,

Cannot go ahead with your solution.My requirement is to remove pg breaks in spool.

ABAP Gurus pl suggest.

Thanks & regards,

Abhishek Singh

[Former Member]

Hi

You can use the below code , which the reprt run in background. If you run the report in background thenyou need to use 'REUSE_ALV_LIST_DISPLAY'

if sy-batch = ' '.

call 'REUSE_ALV_GRID_DISPLAY'.

else.

call 'REUSE_ALV_LIST_DISPLAY'.

endif.

if you are using OO alv then write this code..

CALL METHOD cl_gui_alv_grid=>offline

RECEIVING e_offline = off.

IF off IS INITIAL.

CREATE OBJECT g_custom_container

EXPORTING container_name = g_container.

ENDIF.

Regards

[mahalingam_sivaprakash]

You have to use the line size and line count options in the report. You can set the maximum line count of 60000 and run the report in background. Now the page break will appear only after 60000 records which is the maximum SAP defined line count per page. For instance, assign the line count as below.

REPORT Z******* line-count 60000.

Regards,

M. Siva Prakash.

[Former Member]

Siva,

I tried the same. It worked.

Regards,

Satish Kanteti

[Former Member]

Hi Siva,

Line count solution works in Ecc6.0 but it does not work in 4.7.

My system is on version 4.7

Thanks & Regards,

Abhishek Singh

[Former Member]

Hi Abhishek,

I had tried in 4.6C. It worked. Please recheck once.

Regards,

Satish Kanteti

[Former Member]

Thanks a lot.. It worked

Regards,

Zulema