Excel and Variable button to be displayed in wad Page

[Former Member]

Hi

we are building a wad report. I would like to added a button in the page like in adhoc query, by which user can download the report into excel or go to the variable screen.

currently it is coming only in the menu option on right click of mouse.

Thanks in advance - amar

[edwin_harpino · Accepted solution]

hi Amar,

welcome to SDN ...

try

<A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='your dataprovider'>">Export to excel</A>

hope this helps.

[Former Member · Accepted solution]

I tried it, it is giving following error

System error in program CL_RSR_WWW_PAGE and form 01EXPORT_DATA:01

[Former Member · Accepted solution]

but when i click on export to excel from adhoc query from wad page , it is working fine.

[edwin_harpino · Accepted solution]

hi Amar,

give right value to DATA_PROVIDER='abc'

abc is the same data provider you use for web item table in your web template.

(query/query view)

hope this helps.

[Former Member · Accepted solution]

Thanks it worked

[Former Member · Accepted solution]

It worked