Outup Excel file with drill down functionalities

[former_member181967]

Hello,

I've an issue related with an ALV Report which produces an Excel as output. Therefore this excel file will be send by email but on is format it must achieve some functionalities for some rows in order to group them for example when the characteristic WERKS (Plant) is the same. It means that Í'd like to group and hide the corresponding rows for each WERKS and then open/explode them to see all the contents.Can anyone help me regarding this issue. Thanks and Regards,  JMMatos

[Former Member]

Hi Jose,

You can achieve this functionality by using OLEs.

Regards

Supriya

[former_member181967]

Hello Supriya,

Thanks for your attention.

Do you have any idea how to do it or can you refer me any documentation for achive that ??

Regards,

JMMatos

[nabheetscn]

Did you check this link..? What all have you searched related to OLE..? It will run in foregorund only

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/204d1bb8-489d-2910-d0b5-cdddb3227...

[Former Member]

Jose ,

            Use a customized button in your alv application toolbar and use delete adjacent duplicate and then use the download function after deletion to download it on a particular location.

Regards,

[former_member181967]

Hello Zahid,

Thanks but your reference is not the aim of my issue !!!

Regards,