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