ALV report printing

[Former Member]

Hi,

I have an ABAP report with 22 columns.

When I tried printing the report, it didn't fit in the letter size paper and many columns were not included in the printed report.

Will there be a way to be able to fit all the 22 columns in the letter size paper?

And, will it be possible that those columns that were not printed be placed instead on the next line of the ALV report?

Many thanks.

Katrina

[former_member207661]

Hello Katrina,

1 ) Will there be a way to be able to fit all the 22 columns in the letter size paper?

Yes, it is possible. It all depends how you want to display data in each column. You can shrink each column so that all 22 columns can come in 1-single row.

Though, it might not look good.

You can even try printing in Landscape format if it helps.

2) will it be possible that those columns that were not printed be placed instead on the next line of the ALV report?

This should be possible. Otherwise, you can use Hierarchical ALV.

Warm Regards,

Shyam

[Former Member]

Hi Shyam,

Thanks for the reply. Will it be applicable for hierarchical ALV? The columns that will be printed on the next line has different data type.

For example, columns 1, 2, and 3 are on the first line with fields process order, plant, and quantity. Columns 4, Long text (40 chars) onward doesn't fit on the paper anymore. So it will be printed on the next line the same column with Process order.

ALV report:

Column 1            Column 2          Column 3          Column 4

Process Order     Plant                Quantity            Long text

What should be printed:

Column 1            Column 2             Column 3

Process Order     Plant                    Quantity

Long text

Thank you very much.

[Former Member]

Hi,

Download the file in excel format and then print the document by selecting fit to page.

Thanks.

Akshay

[Former Member]

Hi Katrina,

Downloading the data in the excel sheet is the best way in my opinion.

Have a look at this thread also.

[thangam_perumal]

Hi Katrina,

               Please down load it as a excel format, after print it else reduce the field length of alv report while designing..

Regards,

Thangam.P

[former_member187748]

Hi Katrina,

either you can reduce the the pixel size, or can shrinks the coulm to be printed

such that it can fit into your paper.

Search in this forum, you might get some clue, for achieving your goal.

[former_member227140]

Hi,

1) Ask users to restrict number of columns in print , they can see all 22 columns in o/p but for print you can ask them to keep absolute required columns only.

2) create a layout (there is option in menu of user defined layout) save a variant of created layout. in layout you can keep required columns only.

3) or export to excel and print.

[Former Member]

Hi everyone,

Thanks for the answers. Unfortunately, users don't want to download the report into excel file and modify the text and column sizes and paper width. They wanted to print the report directly from SAP.

Are there still other way to make it work in SAP?

Thanks a lot.

[former_member223133]

Hi,

You can try with the below option.

Create different report layouts by keeping the required columns.

For example:

Layout1 - 1 to 11 columns

Layout2 - 12 to 22 columns

Thanks

Gangadhar