Application Development 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
Showing results for 
Search instead for 
Did you mean: 

How to display results of spool in ALV or download results to excel without columns being truncated?

former_member216029
Participant
0 Kudos

Hello Everyone,

I have a report which when executed 'online' outputs the reults in a simple ALV grid.

There are ~15 columns displayed in the ALV result list.

However, in some situations i need to execute the report in background.

When i display the contents(results) of the spool list, then i notice that only the first 4-5 columns show up in 'Graphical display' mode.

The remaining columns are not displayed! Downloading the results also do not show all the columns.

Is there a way to display all the columns in the spool's 'Graphical display' mode?

I already tried to use the 'Hex format'. However this results in lot of post processing work when downloaded to an excel!

So what i am looking for is some tips on how to display all the columns of spool result display, or even better a way to view the results in an ALV grid.

Maybe there are some setting to display all columns which i am not able to figure out.

Any help is highly appreciated.

Thanks in advance.

Regards

Dev

1 ACCEPTED SOLUTION

raymond_giuseppi
Active Contributor
0 Kudos

You could

-  change the layout of the grid (Note 1486374 - ALV Grid: Layout for spool list when running as a job) and increase report width

- instead of displaying ALV, export all FM or method parameters with an EXPORT TO DATABASE, then give option in interactive execution to IMPORT this data back

- use CL_GUI_ALV_GRID method EXPORT_TO_XML

etc.

Regards,

Raymond

1 REPLY 1

raymond_giuseppi
Active Contributor
0 Kudos

You could

-  change the layout of the grid (Note 1486374 - ALV Grid: Layout for spool list when running as a job) and increase report width

- instead of displaying ALV, export all FM or method parameters with an EXPORT TO DATABASE, then give option in interactive execution to IMPORT this data back

- use CL_GUI_ALV_GRID method EXPORT_TO_XML

etc.

Regards,

Raymond