topic Re: Using a report layout in background mode in Application Development and Automation Discussions

Using a report layout in background mode

Former Member — Thu, 02 Apr 2009 19:48:32 GMT

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

Re: Using a report layout in background mode

former_member194669 — Thu, 02 Apr 2009 19:59:11 GMT

Can you please give more details ?

Re: Using a report layout in background mode

Former Member — Thu, 02 Apr 2009 20:41:37 GMT

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

Re: Using a report layout in background mode

Former Member — Thu, 02 Apr 2009 22:33:29 GMT

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

Re: Using a report layout in background mode

Former Member — Fri, 03 Apr 2009 13:04:44 GMT

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!

Re: Using a report layout in background mode

Former Member — Fri, 03 Apr 2009 13:07:36 GMT

Thanks! I will give this a try.

Re: Using a report layout in background mode

Former Member — Fri, 03 Apr 2009 13:12:59 GMT

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