How to change the default Ad Hoc View data option from "Sample Data" to "No Data" or "Full Data"

Problem

When creating new Ad Hoc Views in the Ad Hoc Editor, the data option dropdown box always shows as "Sample Data".

How can this default be changed to either "No Data" or "Full Data" ?

Solution

1. On the TIBCO JasperReports® Server, navigate to the <jasperserver-pro>/WEB-INF/ directory and open the file applicationContext-adhoc.xml for editing.

2. Add the following property to the adhocUnifiedStateTemplate bean definition:

No Data: <property name="dataSize" value="nodata"/> 

or

Full Data: <property name="dataSize" value="full"/> 

Example :

    <bean id="adhocUnifiedStateTemplate" class="com.jaspersoft.ji.adhoc.AdhocUnifiedState" scope="prototype">
      ...
        <property name="intelligentChartState" ref="iChartStateDelegateTemplate"/>
        <property name="adHocViewMigrationConverter" ref="adHocViewMigrationConverter"/>
        <property name="dataSourceLinker" ref="dataSourceLinker"/>
        <property name="dataSize" value="nodata"/>
    </bean>

3. Restart the TIBCO JasperReports® Server.

Related resources

https://community.jaspersoft.com/questions/958416/adhoc-view-change-default-nodata-option