Run report in Backround and Save it automatic as Excel File

[Former Member]

I've created a report program that uses the alv grid. I run it in background, then i want to save it automatic as an excel file.

can y help me

Thanks

[Former Member]

Hi,

When you run a report in background, irespective of the type of report, let it be Normal or ALV report, we have to use JOB FM's, such as JOB_OPEN, JOB_CLOSE. When you run a report in background, the data to be displayed is stored in the spool. So firt, you need to hold the spool data into an internal table, and then pass that internal table to GUI_DOWNLOAD, by hardcoding a path in the local system to download.

Use this FM to hold the spool output in a internal table , RSPO_RETURN_SPOOLJOB.

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T

[Former Member]

Hi,

Call the function module GUI_DOWNLOAD after the ALV grid display function module.

Give the path to the file name parameter and pass the internal table (Same table as used in ALV grid function module) to tables parameter.

Regards,