topic Re: ALV report printing in Application Development and Automation Discussions

ALV report printing

Former Member — Mon, 20 Jan 2014 11:00:35 GMT

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

Re: ALV report printing

former_member207661 — Mon, 20 Jan 2014 11:14:06 GMT

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

Re: ALV report printing

Former Member — Mon, 20 Jan 2014 11:16:18 GMT

Hi,

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

Thanks.

Akshay

Re: ALV report printing

Former Member — Mon, 20 Jan 2014 13:16:41 GMT

Hi Katrina,

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

Have a look at this thread also.

Re: ALV report printing

thangam_perumal — Tue, 21 Jan 2014 04:33:36 GMT

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

Re: ALV report printing

former_member187748 — Tue, 21 Jan 2014 04:40:55 GMT

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.

Re: ALV report printing

former_member227140 — Tue, 21 Jan 2014 05:04:34 GMT

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.

Re: ALV report printing

Former Member — Mon, 27 Jan 2014 08:15:13 GMT

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.

Re: ALV report printing

Former Member — Mon, 27 Jan 2014 08:26:40 GMT

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.

Re: ALV report printing

former_member223133 — Mon, 27 Jan 2014 08:46:11 GMT

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