Hi gurus,
I have a Report with headers have some HTML code for Tooltips.When I extract report into Excel I am getting Header as the report(i.e Hi) but when I extract the same report in CSV I am unable to get header as the report..it is coming in HTML code(<SPAN Title= "Hi">) which we have written in the report.
for Example:
<SPAN Title= "Hi">
we have run into similar issues with csv exports, including columns showing up on CSV that would normally be hidden in html/xls of columns depending upon prompt selection.
Basically, you have to think of csv as a raw data dump of pretty much every query item in your main report query. Any additional fancy layers such as JS, condtional variables etc. etc. won't work or at least hasn't in our case