Button on a web report for exporting to Excel

[Former Member]

I've been told that it is possible to have a button on a web report to export it to excel.

Could someone please tell me how to do this including any code if necessary.

Using BW3.0B

Thanks

[Former Member · Accepted solution]

Hi Ian,

you can use this CMD syntax for the Excel export:

<SAP_BW_URL DATA_PROVIDER='View1' CMD='EXPORT' FORMAT='XLS'>

Copy and paste following coding in your html body:

1) Export Button:

<A class=SAPBEXBtnEmph href="<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' CMD='EXPORT' FORMAT='XLS'>"> Export to Excel</A>

or

2) Export Icon:

<A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DATAPROVIDER_1'>" ><IMG alt="Download to Excel 2000" src="Mime/BEx/Icons/S_X_XLS.gif" border=0></A>

regards Jens

[Former Member · Accepted solution]

Thanks Jens

[Former Member]

Hi Ian,

I'm not an expert, but have you check here for your problem:

?

Hope it helps !

Bye,

Roberto