Excel Download in WAD

[Former Member]

Dear Guys,

I have one issue in WAD.

I have one report having Revinue and Expenditure. These are the two reports.

In WAD, i am showing these two tables in one template.

Everything is coming fine. When i am trying to download to excel, only first report is downloading. The second is not downloading.

I want to download both reports in a single shot.

I am using text element in WAD for downloading to Excel. My WAD code is,

<td class="SAPBEXNavLine">

<A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DP'>">

<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="T77">

<SAP_BW_TEXT program="SAPLRRSV" key="T72">" src="Mime/BEx/Icons/S_X_XLS.gif" border=0 >

</A>

</td>

Please provide some inputs.

Regards,

Vivek.V

[former_member184494 · Accepted solution]

Vivek,

The Excel download is dataprovider specific and not template specific .. you would not be able to download both of them usung WAD..

Options :

1. Web Enabled workbooks

2. Use BSP to render the query ad use the excel download functionality - extremely complex and cumbersome

Hope it helps..

Arun

Assign points if helpful

[former_member189638]

Hope this code helps.

<td class="SAPBEXNavLine"><A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DP'>"><IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="T77"> <SAP_BW_TEXT program="SAPLRRSV" key="T72">" src="Mime/BEx/Icons/S_X_XLS.gif" border=0 ></A></td>

[Former Member]

Hi Vivek,

I got the same issue. Can you please let me know the solution u have found. Thanks in advance!!

Ramesh

[Former Member]

Hi Vivek,

Even I have the sme issue .Did you find any soultion for this

If so Pls let me know

Thanks

SVR