Skip to Content
0
Jan 17, 2011 at 03:08 PM

Export to Excel from WAD

92 Views

Hi Experts

I have two questions:

1)We are trying to put a button on our web template to export the web report in to Excel format. I searched SDN blogs and found that I need to place a button group and add below code to achieve this:

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

My question is, I do not see any button group in web template web items, I only see radio button group. I'm sure that it is not the same. Please advice where I can find this button group web item in BEX WAD 3.5

Also, When I place this button where should I write the above HTML code?

2)In Bex Query we have 4 key figure values with decimals rounded to 0, We have a formula which is sum of above 4 Key figures rounded to 0. Now when we run the report all 4 Key figures are showing correct as per the def,

But as the fomula is adding these 4 KFs, it is not giving the correct totals. Example KF1: 3.3 KF2: 4.3 KF3: 5.1 KF4: 6.1

so our report shows

3 4 5 6 as Kf 1...4 and 19 as Formula value. Here the total for fomula is totaled as 18.8, and it is showing 19 to nearest number.But I want to show the formula value as 18 only. Can some one please advice how to achieve this.

thanks