Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem with page break in Spool Output when running program in background

Former Member

‎2007 Feb 21 2:38 PM

0 Likes
636

Hello all,

A user is having a problem with downloading data from an FI report (RAPOST2000) when it is run in the background.

Basically, the user wants to be able to download the spool output to an excel spread sheet and manipulate the data. However the problem is that the output is large (1000s of lines) and every 100 lines or so the header and column name data is output to the screen.

So if the user does download to XL then they have to manually scroll through the XL SS and delete every occurrence of the header and column data, which is not feasible.

Are there are parameters I can change so that the spool lists all the output data continuously, with the header and column title data only output once (at the top).

thanks in advance,

Kevin

Hello all,

A user is having a problem with downloading data from an FI report (RAPOST2000) when it is run in the background.

Basically, the user wants to be able to download the spool output to an excel spread sheet and manipulate the data. However the problem is that the output is large (1000s of lines) and every 100 lines or so the header and column name data is output to the screen.

So if the user does download to XL then they have to manually scroll through the XL SS and delete every occurrence of the header and column data, which is not feasible.

Are there are parameters I can change so that the spool lists all the output data continuously, with the header and column title data only output once (at the top).

thanks in advance,

Kevin

Reply
1 REPLY 1
Read only

christian_wohlfahrt
Active Contributor

‎2007 Feb 22 10:07 PM

0 Likes
429

Hi Kevin!

You can define to use very long pages, but a report will have page-breaks. That is done in job planning, min. requirements can be set in the report (if own, of course).

But the deletion isn't so difficult: just sort the stuff, then all the headers and --- lines will be at one place and can be deleted as block. Would be better to have a line number to get the original sorting afterwards

Regards,

Christian