I noticed that some reports filter a date range in the database while others return a brazillion records and then filter on the PC.
For example. If I use:
and ( Transaction Date between ?Start Date? and ?End Date? )
No date filter is in the SQL!
If I use:
and ( Transaction Date >= ?Start Date? and Transaction Date <= ?End Date? )
Then the SQL will have:
and T2."TRANSACTION_DATE"<=to_date('2007-04-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
Which really blows because we have 6 years of data in this database and returning all records before April 1 takes forever.
Is there any way to force Impromptu to filter the date in the database?
Thanks.
For example. If I use:
and ( Transaction Date between ?Start Date? and ?End Date? )
No date filter is in the SQL!
If I use:
and ( Transaction Date >= ?Start Date? and Transaction Date <= ?End Date? )
Then the SQL will have:
and T2."TRANSACTION_DATE"<=to_date('2007-04-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
Which really blows because we have 6 years of data in this database and returning all records before April 1 takes forever.
Is there any way to force Impromptu to filter the date in the database?
Thanks.