ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Jaspersoft - Changing default adhoc view from Crosstabs to Table

book

Article ID: 196939

calendar_today

Updated On:

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

Powered by Wolken Software