topic Re: Spoll Problem in Application Development and Automation Discussions

Spoll Problem

Former Member — Thu, 13 Sep 2007 10:35:52 GMT

Hi,

I have report for FI Related (G/L Accounts ) which takes lot of time to give output.

So, we will run it in the Background. When we run in the Background after creating spool , when we open spoll it is not showing all columns. Because the width of the report is very large. when we select the option show in maximum width in the spool then it is showing all the columns. But when we download it to Excel all <b>Rows</b> are not comming. when we download it in the text file it is giving all the rows. How do we solve it ?

Where exactly the spool will store ? can we get spool by programming and can we upload it in the Excel ?

Thanks and regards,

Satya.

Re: Spoll Problem

varma_narayana — Thu, 13 Sep 2007 10:45:42 GMT

Hi..

When the Report is Run in Background:

SPOOL : will store the Output of the report which can be send to an output device like printer and downloaded to a File.

Excel files will have Limit for number of rows(Like 65536) . May be bcoz of that all the rows are not transferred.

So you have to Transfer to Text file..

Reward if Helpful

Re: Spoll Problem

Former Member — Thu, 13 Sep 2007 10:55:49 GMT

But in the Report Consists of 500 to 700 lines only.

Still I am getting this problem.

bye,

satya.

Re: Spoll Problem

Former Member — Thu, 13 Sep 2007 11:07:59 GMT

well u can try downloading the data directly into ur excel file by fm gui_download .

Thanks

Rohit

Reward if helpful