topic Re: Outup Excel file with drill down functionalities in Application Development and Automation Discussions

Outup Excel file with drill down functionalities

former_member181967 — Mon, 28 Oct 2013 10:29:03 GMT

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

Re: Outup Excel file with drill down functionalities

Former Member — Mon, 28 Oct 2013 11:27:43 GMT

Hi Jose,

You can achieve this functionality by using OLEs.

Regards

Supriya

Re: Outup Excel file with drill down functionalities

former_member181967 — Mon, 28 Oct 2013 11:54:14 GMT

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

Re: Outup Excel file with drill down functionalities

nabheetscn — Mon, 28 Oct 2013 12:04:11 GMT

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-cdddb3227820?QuickLink=index&overridelayout=true&11385958302298

Re: Outup Excel file with drill down functionalities

Former Member — Mon, 28 Oct 2013 12:06:41 GMT

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,

Re: Outup Excel file with drill down functionalities

former_member181967 — Mon, 28 Oct 2013 15:27:33 GMT

Hello Zahid,

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

Regards,