My Oracle Support Banner

How to allow the excel output to have Number and Date filters (Doc ID 330027.1)

Last updated on OCTOBER 12, 2023

Applies to:

Oracle Reports Developer - Version and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.


You have created a JSP report to display in Excel output. The excel output has columns with Number and Date fields. In the excel output when applying the custom filters like "greater than" and "less than", The filters are not working for Number and Date fields.

In the websource of the JSP report, the fields attributes are like the following.

<td align=left><rw:field id="f_ename" src="ENAME"> &Field </rw:field></td>
<td align=right><rw:field id="f_empno" src="EMPNO"> &Field </rw:field></td>
<td align=right><rw:field id="f_hiredate" src="HIREDATE"> &Field </rw:field></td>




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.