topic Re: Spool request in Application Development and Automation Discussions

Spool request

Former Member — Mon, 25 Jun 2012 21:44:01 GMT

Hello All,

I have run report in the background & I got 70 pages in spool but my requirement is that it should show header only once. What i observed is that it is showing header details after specific row count. Please refer the attachment for the example.

Can anybody help me in this?

Amit

Re: Spool request

Former Member — Tue, 26 Jun 2012 01:14:18 GMT

Spools are generated for a print out. The headers are repeated for every page. Thats a feature. Why do you want to that feature?

Re: Spool request

laurent_fournier2 — Tue, 26 Jun 2012 06:13:00 GMT

Hi there,

Is it a standard or a customer report ?

Re: Spool request

Former Member — Wed, 27 Jun 2012 06:45:57 GMT

Hi Chinmay,

I think it will be easier to download to excel.

Is there any way to remove it ?

Re: Spool request

Former Member — Wed, 27 Jun 2012 06:58:26 GMT

If you have all the data in an internal table, it should be easy to download the table to excel file using GUI_DOWNLOAD - dont forget to send the fieldnames along with the table.

A very crude way could be to generate the output and hence spool using the Write statement, without top of the page event.

I am sorry to have missed this earlier, but could not find your attached file. Can you upload the file?

It would make things more clear.

Re: Spool request

Former Member — Wed, 27 Jun 2012 06:59:54 GMT

Hi Amit,

For your report, have you used TOP-OF-PAGE to display header? In that case, do not use that and use the parameter i_grid_title in the FM REUSE_ALV_GRID_DISPLAY. Using this, header is displayed only once.

Hope this helps you.

Regards,

Sindhu Pulluru.