report performance issue

[dfite]

I have a pretty straightforward list report that when run never finishes. (I'm using reportnet 1.1).  When I query the data view in Oracle the contents come back within 30 seconds.  Any thoughts?

So, when in Oracle I run this statement, it returns quickly:
SELECT * FROM RPT$RPT_1128_MAIN
WHERE TO_DATE('20071201', 'YYYYMMDD') BETWEEN START_DT AND END_DT
AND       FDATE BETWEEN  ADD_MONTHS(TO_DATE('20071201', 'YYYYMMDD'), -11) AND TO_DATE('20071201', 'YYYYMMDD')

Yet when I run my report with these filters, the report runs forever:

to_date([CPAS_Reports].[RPT$RPT_1128_MAIN].[START_DT]) < ?pUserDate?

to_date([CPAS_Reports].[RPT$RPT_1128_MAIN].[END_DT]) > ?pUserDate?

to_date([CPAS_Reports].[RPT$RPT_1128_MAIN].[FDATE]) < ?pUserDate?

to_date([CPAS_Reports].[RPT$RPT_1128_MAIN].[FDATE]) > _add_years(?pUserDate?, -1)

[the_xxx]

Instead of < or > signs , try using between.