Export to Excel from WAD
We are trying to Export the WAD report data into excel 2000. But it behaves weird. Our WAD report has Text Elements and Table web items. So when I run the report, its showing up text elements data and data in a table.
When we export it to Excel, table data looks OK but we see Free characteristics of the Query in the excel sheet instead of Text Elements! We are completely missing the Text Elements and in the excel sheet, we see the description of the Query we are using the WAD report, not the WAD report heading!
Do we need some settings to be checked!
We are using 3.5 version.
Gillian Leo replied
Afraid not - it's SAP standard the Export option so you have no control on it
The Query is what's being exported and as the Web Template name isn't part of the query you get the Query name not the template name. No way around this either I'm afraid.