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 12.2.1.4.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

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>

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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