Export to Excel and in Excel create a drop down list

building reports crystal reports
1

Got a typical requirement from the client.

A report data is exported to excel and after exporting,a field values should be created as drop down list in excel.Is this possible?

siva6809 (BOB member since 2009-03-05)

2

Hi,

Once the report is exported to the excel you can use the excel features to get the drop down functionality.

In Crytsal Reports you can use Web Controls to have drop down functionality.

For more information please refer the SAP note 1205875 - How to embed web controls into a Crystal report using the webElements Custom Function Library.

Please use this link: http://www.sdn.sap.com/irj/scn/advancedsearch?query=web+controls

Cheers!!!
Manish Tiwari

cr_manish :india: (BOB member since 2009-07-30)

3

Thank you so much Manish.

siva6809 (BOB member since 2009-03-05)