Skip to Content
author's profile photo
Former Member

Button on a web report for exporting to Excel

Posted on Jan 04, 2005 at 11:06 AM 10 Views

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

BW Business Explorer (SAP BEx)
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