We are having a problem with getting data to export from Jaspersoft adhoc views into either a report or exporting to excel.
Release : 16.0.0
Component : CLARITY DATA WAREHOUSE
a) On a Jaspersoft Adhoc view
b) From the Tool Bar
c) Click on the tab "Select Visualization Type"
d) Change it from "Crosstab" to "Table"
e) Click on Apply and Close
d) Export the Report.