ALV GRID Report Output

Former Member · ‎08-03-2005

I have a report which display list in Header and Item format. If i click on 'Excel' icon on tool bar, the Item list is converted in to 'Excel' format. Every thing is fine.

The issue is the excel formatted list has got lot of Work sheets called 'Format',Header','Pivot',sub1,sub2....sub10 'Raw data' and 'Raw header'.

Most of these worksheets are blank. User do not want remove all these worksheets except one or two. How do i do this. Can a variant do the trick? if yes how to do that?

Any help in this regard is appreciated.

RichHeilman · ‎08-03-2005

Instead of having the user do "Excel in place", have the do an export, by clicking the export button, spreadsheet, table, MS excel. Doing it this way, does not generate all of the other worksheets.

Regards,

Rich Heilman

Former Member · ‎08-04-2005

Thanks!! Rich,

The only problem with the option you suggested is, I can not get filter,sort and sum values,

Any idea how to get sum values.

RichHeilman · ‎08-04-2005

Let's go the long way around. Click the print preview button, select print preview. Now click the button for "local file", select spreadsheet, give the file path, click transfer.

Please award points for helpful answers. Thanks.

Regards,

Rich Heilman