Skip to Content
0
Former Member
Feb 17, 2009 at 04:48 AM

Download Background job output to Excel automatically

15242 Views

Dear Experts,

Hi there... Please note the following scenarion and give me your expert solutions on the same...

I have created a SALES QUANTITY REPORT for exports... In this there are many conditions applied to achieve data in many of the columns of this report. If we run it for 2-3 months it is not a problem... The output comes at a marginal wait time... But the moment it is run for a whole year then it just goes on and on.... I cannot fine tune also.... because of the conditions... For better performance and fast retrieval i have used views in this report to achieve quick output...

The thing is when i put it to execute in Background it comes within an hour or so... But the output is not readable.... so here is what i want:

1. First of all why report executes so quickly when put in background, whereas in foreground it takes more than 4 hours and also no guarantee of output.. This is to satisfy my curiosity...

2. I want the output to get automatically converted into excel and get stored in a specific folder the moment the job is finished in background without any format getting disturbed. The report is prepared in ALV...

Please gurus help me out.

Thanks...

Jitesh