Skip to Content
author's profile photo
Former Member

Button on a web report for exporting to Excel

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Jan 04, 2005 at 04:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Jan 04, 2005 at 11:33 AM

    Hi Ian,

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

    Webreporting - more than one DataProvider - Switch with Command URL ?

    Hope it helps !

    Bye,

    Roberto

    Add comment
    10|10000 characters needed characters exceeded