Dear All,
I cannot run a zsales_report in the foreground due to large number of records .It is showing a dump .
So I have to run this report in the background so that I can get the output for a period of 1 year .
Here I am facing an issue in running the report in the background .
To run a report in the background :-
(1) We can either create a background job with Tcode : SM36 ( Create Background Job )
with a variant .
(2) Execute in Background .
So I am adopting the (2) option that is Execute in Background .
For Output Device I am giving " print_123 " .When I schedule it further it is showing that " Formatting set to 'X_6 5_80 " .Then I saved this job .
So I run the report in the background so zsales_report is successfully executed in background . Background job successfully finished .
When I try to extract the output from the background job which was finished it is displaying the output but showing a message that only page 1 to page 10 of
82 are displayed .
I have attached the message which I am getting . Moreover when I save the output to a local file i.e excel file (spreadsheet) then also the output which is extracted in excel is not having all the records . I checked the records in excel file and the count comes to only 441 records .
So it was an incomplete output because it is showing records passed : 3952 .
I have attached the screenshots . Please check .
So please guide how to extract the whole output of the report because I am running for all plants , division , distribution channel and Invoice date is almost an year .
( 01.04.2014 to 31.03.2015 ) .I am not getting complete output of the report while running the report in the background .
Regards
Deep