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)
Instead of < or > signs , try using between.