Data in Adhoc View export gets replaced with the word 'Totals'

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There is a crosstab Adhoc View that is defined to show multiple columns. Data is correctly presented when this View is loaded in 'Advanced Reporting'. However, when this presented data is exported to an Excel file, only the first column retains its data. All the other columns, change their value to display just a single word - 'Totals'. 

Environment

• Jaspersoft Server 8.1.1
• Jaspersoft Server 9.0.0

Cause

Corrupted Adhoc View

[or]

Row summary is hidden

Resolution

Recreate the Adhoc View with the same columns, and filters.

[or]

Right click on a column whose export is showing 'Totals' instead of the actual values. Click on 'Add Row Summary'.