WAD export to Excel - how to change settings?
I am confronted with some issues in WAD when it comes to do an export to Excel. In a WAD query I have embedded several BEX queries (Grid Item). The display on the screen is fine when I am running the WAD query. But when I choose to export it, the data (Grid elements) gets scrambled and the Excel report is not readable.
1/ How can I choose in which Excel cells the data in the WAD Grid Items will go to? For example, to force the WAD display on the screen to be respected in Excel.
2/ How can the solution for 1/ can be implemented in the global template, to all queries?
Looking forward to hearing your ideas.