Can't Change Ad Hoc Crosstab to Chart Due to '..Restore all summaries before switching to a chart' message

Issue Description

Customer created an Ad Hoc Crosstab with 1 measure and 1 field in Columns and 1 fields in Rows.

If he tries to change the Ad Hoc type from Crosstab to Chart, he gets message

"The server can't render the chart because a row or column group summary was deleted. Restore all summaries before switching to a chart"

Please refer to printscreen.

How to fix the issue?

Resolution

Issue investigation revealed that the user manually removed Row Totals (for shipcountry row in provided printscreen) which leads to the message.

As of v.7.1.0, TIBCO JasperReports^® Server requires all Rows and Columns Totals to be displayed in order to swtich to Chart mode.

Once the Row Totals is added back to the crosstab, it is possible to change to Chart mode.

Please find attached printscreen:

Ref. Case 01647121