problem in background run output

[Former Member]

Hi all,

I have a report in which output is displayed in REUSE_ALV_LIST_DISPLAY

format having around 25 columns , all displayed well if the report is run in foreground with limited data, but as the report has to be run in background for the large data , the output is coming in two rows, half the columns displayed in second rows, As i don't want it to be printed directly , I Just want that report o/p

run in background should give all columns in single row , so that i can download it to excel sheet. Please provide your valuable suggestions.

thanks in advance,

Vivek

[Former Member]

Hi Vivek,

As of my knowledge better to decrease the text of the each field in the and try

For EG:

v_pos = v_pos + 1.

w_field-col_pos = v_pos.

wa_fldcat_head-tabname = 'it_FINAL'.

wa_fldcat_head-fieldname = 'NDABJ'.

wa_fldcat_head-seltext_l = 'Expired years start fiscal year'.----

---

>(in this just decrease how much u can )

append wa_fldcat_head to it_fldcat_head.

Reward if helpful

Thanks

Naveen khan

Message was edited by:

Pattan Naveen

[Former Member]

HI,

I think there is technical limitation on the length of the spool that can be displayed check this.

Thansk

Mahesh

[Former Member]

Hey check this link for setting the spool length.

Thanks

mahesh

[Former Member]

Your spool can show only up to 250 characters. Also, you cannot simply download that into an excel spreadsheet as you would have normally done in an ALV grid. Increase the length of your report LINE-SIZE in your REPORT statement. See below comments from help documentation.

<i>If the you want the report list (i.e. the output) to be printable, do not define a LINE-SIZE with a value greater than 132 because most printers cannot handle wider lists. You cannot print lists wider than 255 characters at all using the standard print functions. To print the contents of the lists, you need to write a special print routine that arranges the data in shorter lines (for example, using the PRINT ON addition in the NEW-PAGE statement. </i>