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

Alv report in background , Format problem

Go to solution
Sreenith
Participant

‎2016 Jul 29 10:41 AM

0 Likes
1,956

Hi All

I am running alv report in background and abap list output data with header comes in two rows.

The columns that are not accomadated in first row is coming under first one and this created problem for layout.

Please check attached image for layout.I am using column width optimize.

I tried  no_change_print_params = 'X' in is_print parameter in alv grid display but  at that time it columns are displayed correctly but data inside column got truncated.


Paper type is X_PAPER


I have to extract this report into  excel.


Please suggest if any other ways to complete this.

Please help.

Preview file
28 KB
1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2016 Jul 29 10:57 AM

0 Likes
1,186

Hi

The page is grid of columns and rows , if ALV layout needs a number of columns ( i.e. characters for row ) bigger than the page columns , the last characters  will be printed in the another row

so the problem should be in the page type you're using to create the spool:   you need to check if there's a type having a number of characters can satisfy your ALV else:

-you should create a new one;

- you should reduce the lenght of the ALV columns printed or delete some columns in order all characters can be printed in one row only (so you shoud create a default variant to be used for the job, if it's not possible to indicate an ALV variant in the selection-screen of the report)

Max

Hi All

I am running alv report in background and abap list output data with header comes in two rows.

The columns that are not accomadated in first row is coming under first one and this created problem for layout.

Please check attached image for layout.I am using column width optimize.

I tried  no_change_print_params = 'X' in is_print parameter in alv grid display but  at that time it columns are displayed correctly but data inside column got truncated.


Paper type is X_PAPER


I have to extract this report into  excel.


Please suggest if any other ways to complete this.

Please help.

Reply
2 REPLIES 2
Read only

Go to solution
Former Member

‎2016 Jul 29 10:57 AM

0 Likes
1,187

Hi

The page is grid of columns and rows , if ALV layout needs a number of columns ( i.e. characters for row ) bigger than the page columns , the last characters  will be printed in the another row

so the problem should be in the page type you're using to create the spool:   you need to check if there's a type having a number of characters can satisfy your ALV else:

-you should create a new one;

- you should reduce the lenght of the ALV columns printed or delete some columns in order all characters can be printed in one row only (so you shoud create a default variant to be used for the job, if it's not possible to indicate an ALV variant in the selection-screen of the report)

Max

Read only

Go to solution
Jelena_Perfiljeva
Active Contributor

‎2016 Jul 29 10:38 PM

0 Likes
1,186

The 255 character per line limit in ALV in background has been around forever. Tons of information on this online. Not sure if SAP did anything about it in the last few years (doubt that).

If you need this in Excel then why not just create an Excel file directly? Otherwise reducing the size is the only option, as noted above.