Skip to Content
0
Former Member
Jun 09, 2011 at 07:24 AM

Reg: prob when downloading alv with multiple line column headings to excel

142 Views

Hi all,

I have a requirement where I have to show the report with column heading in multiple rows.

for example; 1st line | FOR THE QUARTER |

2nd line | plan | rev.est | actuals |

I've done this by using reuse_alv_list_display FM by removing header option (gd_layout-no_colhead = 'X'.) and including top-of-page event and including write statement in top-of-page.

But when I download this data from alv to excel, the column heading is not properly aligned to the data.

Please help to acheive multiple line column heading with excel download option.

Thanks,

Rajan U