Jaspersoft - Changing default adhoc view from Crosstabs to Table

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

Is there any way to change the default adhoc view from Crosstabs to Table?

Environment

JasperSoft 6.4, 7.1 and 7.2

All Supported Windows Operating Systems

Resolution

1.  Stop the JasperSoft Tomcat service

2.  On the JasperSoft server, open the following file in a text editor

CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\scripts\adhoc\datachooser\view\DatachooserDialogView.js

Find the original line below (near line 95 or 97 depending on the version), and change it to reflect "table" instead of "crosstab"

reportType = reportType || "crosstab";

3. On the JasperSoft server, open the following file in a text editor

CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\optimized-scripts\adhoc\adhocStartMain.js

Search for "crosstab" and replace the first occurrence with "table" - it might look something like o=o||"crosstab"

4.  Delete the contents from the following folders on the JasperSoft server

CA Business Intelligence\apache-tomcat\temp

CA Business Intelligence\apache-tomcat\work

5.  Clear web browser cache

6.  Restart the JasperSoft Tomcat service