Skip to Content
-2

How to avoid Page Brake when download in background

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • 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.

    Add comment
    10|10000 characters needed characters exceeded