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 8.1.1.

Cause

Corrupted Adhoc View.

Resolution

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