Skip to Content

How to avoid Page Brake when download in background

Dec 13, 2017 at 10:30 AM


avatar image

Hi Good day,

I have Report where i use the FM : CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

When try to download to Excel, i downloads with page breaks - when download it in

background - Foreground works 100%.

Can anyone shed light on it please?

Ex : Background - Incorrect

Ex : Foreground - 100% Correct

background.jpg (453.2 kB)
foreground.jpg (282.6 kB)
10 |10000 characters needed characters left characters exceeded

And how are you downloading the data background?


Using Tcode : SM37.


Right. So you're downloading the spool.


Want to take out the below Header.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jelena Perfiljeva
Dec 13, 2017 at 07:42 PM

Based on the additional information in the comments, see if changing the print properties to disable cover sheets would help.

But either way I wouldn't expect the same exact results with the spool output as with opening ALV in Excel directly. It just works differently, in general.

image5.jpg (38.6 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Jelena Perfiljeva,

Thank you screen shot, i have tried to look for Spool Request Attributes in SM37, i dont find it.

Can i please know where you found the above screen?


It's in the print options for the job step. When you're creating a job, it's a small printer icon at the bottom of the popup where the program name/variant is entered. For an existing job definition, double-click on the step.

Raymond Giuseppi
Dec 14, 2017 at 10:59 AM

What you called download in background was downloading of a generated spool (REUSE_ALV_LIST_DISPLAY) so it also consider header, page break and the like. Interactively, you download from Grid so more options even with outdated FM. For background, look at SM37 spool attributes and/or fill parameters of the FM related to spool (TOP-OF-PAGE, IS_PRINT, etc.)

If you have the time, look for other solutions like in my answer to Read ALV Spool List more than 255 Chars and send it in Excel.

10 |10000 characters needed characters left characters exceeded