Is there any way to change the default adhoc view from Crosstabs to Table?
JasperSoft 6.4, 7.1 and 7.2
All Supported Windows Operating Systems
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