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: 

OOP's ALV : Download to excel issue

Former Member
0 Kudos

Hi All,

I am using oops ALV in a report .

I need to implement it in such a way that when user export the list to excel

1. Downloaded excel should also contain the data printed in top- of-page followed by the grid data.

i.e some desired records followed by the main records.

I am able to display the output data as desired, But when I download data to excel, it gives only records

from grid and not the top-of-page data.

Please let me know how to solve this ?

Do I need to change approach?

Thanks in Advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

I think you have used the split container concept to display the TOP-OF-PAGE on the alv output.

So in this case you cannot download the TOP-OF-PAGE data when you use the download functionality of the ALV.

So what you can do is beside showing the data for TOP-OF-PAGE in another container still populate the data in TOP-OF-PAGE event with data. This will not be shown on the ALV Output but with print or download this will dislayed.

5 REPLIES 5

Former Member
0 Kudos

Hi harsh,

if the requirement is simple go for ALV grid using function modules.

We can do most the operations using the same.We can download the top of page data also.

If you need to display the ALV using dialog program then you should go for ALV using OO / factory method etc.

Regards,

Sanil

0 Kudos

Hi Sanil,

I want to download GRID data and TOP OF PAGE in same excel file.

Please resolve if possible.

Former Member
0 Kudos

Hi,

I think you have used the split container concept to display the TOP-OF-PAGE on the alv output.

So in this case you cannot download the TOP-OF-PAGE data when you use the download functionality of the ALV.

So what you can do is beside showing the data for TOP-OF-PAGE in another container still populate the data in TOP-OF-PAGE event with data. This will not be shown on the ALV Output but with print or download this will dislayed.

0 Kudos

I have used split container concept.

Please explain last two line

Is there any other way to achive this??

Edited by: harsh bhalla on Mar 27, 2009 2:18 PM

0 Kudos

Hi,

To display the top of page in ALV FM we use the TOP_OF_PAGE event to display the data. But in Oop's Concept if you populate the data in TOP_OF_PAGE event the data will not be displayed in ALV layout but when print preview or print then you can see the TOP_OF_PAGE data.

So to show the data on the ALV layout we use the split conatainer concept. Split the container in two and display ALV in below container and TOP_OF_PAGE in top container.

Apart from having above you still populate the TOP_OF_PAGE event of ALV. This will be come into picture in case of download,Print priview & Print.