How to show repeated values in Ad Hoc Crosstab

Requirement:
To show repeated values in Ad Hoc Crosstab.

If we have a Crosstab and export it to Excel, repeated values are not shown and we only see the value once.

e.g.,

Country User Amount

Germany A 2

B 3

C 4

In Excel export this is pretty bad because we cannot filter anymore. Is there a way to generate Excel like this:

Country User Amount

Germany A 2

Germany B 3

Germany C 4

Solution:
When we design the Ad Hoc View, we can select the option 'Unmerge Crosstab Cells' to display the repeated values.

After this, the Ad Hoc View will display values as per our requirement, and can be exported in a way we want. Please refer below screenshot:



From JasperReports Server 8.0.x, we can access the 'Merge cells' toggle from the right panel called 'Format Visualization'. Please refer below screenshot:



_____________________________________________________________________________________________________________________________________________________________
Ref. Case #02120024