How to change the default visualization type in the Ad Hoc Editor from Crosstab to Table in JasperReports Server

Requirement:
To change the default visualization type in the Ad Hoc Editor from Crosstab to Table in JasperReports Server

Solution:
1. Download the required version source ZIP from the eDelivery website (for example, TIB_js-jrs_8.0.0_src.zip).

2. Unzip the source file in a working directory, like C:Jaspersoft

3. Locate the DatachooserDialogView.js file (C:JaspersoftJasperReports-Server-8.0.2-srcjasperserver-uiprojrs-ui-prosrcadhocdatachooserview) and open it in an editor.

4. Enter 'table' for the reportType entry of the constructor: function (options) around line 77 of the file (DatachooserDialogView.js file attached for reference), like:

 

constructor: function (options) {
options || (options = {});
this._dfdRenderSerachFormTo = jQuery.Deferred();
var reportType = this._getParameterByName(ADHOC_REPORT_TYPE_PARAM_NAME);
reportType = reportType || 'table'; //Default Ad Hoc View data selector to table
this.reportType = reportType === 'chart' ? 'ichart' : reportType;
this.decorate = this._getParameterByName(DECORATE_PARAM_NAME) || 'yes';
this.isEmbeddedDesigner = this._getParameterByName(IS_EMBEDDED_DESIGNER_PARAM_NAME);

5. Save the file.

6. Finally, to reflect the JavaScript source code customization on the UI we need to build the scripts using the newer Webpack approach. For complete steps on how to build the scripts, please see the section 5.2.3, "Customizing JavaScript Source Code" from our Ultimate Guide:
https://docs.tibco.com/pub/js-jrs/8.0.2/doc/pdf/TIB_js-jrs_8.0.0_Ultimate-Guide.pdf?id=13

Alternatively, you can also watch the below Dr.Jaspersoft video on instructions for building scripts with Webpack:

datachooserdialogview.js