Using a report layout in background mode

[Former Member]

Is is possible to apply a saved report layout like you apply to the alv grid to a csv file run in background mode?

[Former Member]

Is is possible to apply a saved report layout like you apply to the alv grid to a csv file run in background mode?

[former_member194669]

Can you please give more details ?

[Former Member]

The requirements were to create an alv grid when run in the foreground with a screen parameter for report layout so multiple report layouts could be saved in different variants. Also, if the report is run in the background it should create an excel (csv) file and write it to the application server. The business owner wants to schedule the job to run in batch with about 10 different report layouts. I have everything working in the foreground. I didn't know if it was possible to apply a report layout to the excel file. Thanks for your help!

[Former Member]

Hi Cynthia,

As an alternative, you can propose this design to your business owner.

if sy-batch = space.

call function REUSE_ALV_GRID_DISPLAY

else.

call function REUSE_ALV_LIST_DISPLAY

endif.

This way, you will have the desired layout saved to the spool, from where you can download the file as excel sheet also.

Regards,

Ravi

[Former Member]

Hi Cynthia ,

I can figure out one way :

SUBMIT ZREPORT TO SAP-SPOOL LAYOUT 'ZLAYOUT'
VIA SELECTION-SCREEN
DESTINATION 'locl'
KEEP IN SPOOL 'X'
IMMEDIATELY 'X'
WITHOUT SPOOL DYNPRO
AND RETURN.

This will return the report in your layout to the spool and can be downloaded as well.

Thanks

Naresh

[Former Member]

Thanks! I will give this a try.

[Former Member]

I hope ALV Grid does not work in Background, even normal program also wont work in background if you want to operate on presentation server.

Regards,

~Satya