Searching in Interactive Grids may not give the results you expect.
The search only returns results for Text columns, so numbers, dates, etc. are ignored.
The obvious solution is to convert numbers etc. to an (extra) text column, and then use that in the report. In the example below I've done that with Empno.
There is another option however, using LOVs. It's a bit weird to (mis)use a "select null from dual" for that, but it does work. See the Deptno, Mgr and Hiredate columns below.
And not having to convert columns and/or define extra columns is a nice bonus as well.
In the examples below, the first (standard) IG will only show search results for text (Ename) and number (Deptno and Mgr) columns.
The second (text + LOV) IG will show search results for all columns.