Since there has been some confusion on the steps needed to configure Jaspersoft Reports to recognize date fields and filter on date fields, I am posting the complete file edits needed here.
Update the applicationContext-semanticLayer.xml file:
Locate the applicationContext-semanticLayer.xml, in the following directory:
C:\Program Files\apache-tomcat-8.0.33-windows-x64\apache-tomcat-8.0.33\webapps\jasperserver-pro\WEB-INF
Open the file using Notepad++, and locate the following section:
<property name="codeToJdbcTypeMapping">
<map>
<!-- entry key="<code>" value="<field name>" -->
<!-- -101 is TIMESTAMP WITH TIME ZONE in Oracle, mapped to TIMESTAMP -->
<entry key="-101" value="TIMESTAMP"/>
Update the section to add the following lines:
<!-- 11 is date fields in SDM, mapped to TIMESTAMP -->
<entry key="11" value="TIMESTAMP"/>
Locate the following section in the same file:
<bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
<property name="productName" value="Microsoft SQL Server"/>
<property name="sqlGenerator" ref="sqlserverGenerator"/>
</bean>
Paste the below text below the above section:
<bean class="com.jaspersoft.commons.semantic.dsimpl.DBServerConfig">
<property name="productName" value="OpenAccess"/>
<property name="sqlGenerator" ref="sqlserverGenerator"/>
</bean>
Save and close the applicationContext-semanticLayer.xml file
The following step is needed to avoid errors when date fields are used on reports along with combo name. It is a Known Issues that without the following file updates, date fields and combo names cannot be used on the same report without jaspersoft reports throwing an error.
Update the DatachooserDialogView.js file
Locate DatachooserDialogView.js, in the following directory:
C:\Program Files\apache-tomcat-8.0.33-windows-x64\apache-tomcat-8.0.33\webapps\jasperserver-pro\scripts\adhoc\datachooser\view
Open the file using Notepad++, and locate the following section:
var reportType = this._getParameterByName(ADHOC_REPORT_TYPE_PARAM_NAME);
reportType = reportType || "crosstab";
this.reportType = reportType === "chart" ? "ichart" : reportType;
Update the following line as follows:
reportType = reportType || "table";
Save the file
Update the js.config.properties file
Locate js.config.properties in the following directory:
C:\Program Files\apache-tomcat-8.0.33-windows-x64\apache-tomcat-8.0.33\webapps\jasperserver-pro\WEB-INF
Open the file using Notepad++, and locate the following line:
javascript.optimize=true
Update that value to false, as follows:
javascript.optimize=false
Save the file
Recycle the Jaspersoft ReportServer service
Clear your browser cache