hi everyone,

We are using crystal reports 8.x as a reporting tool for all online and end of day reports and db2 udb v8.1 is our database. If we use any date columns crystal will use date function and automatically generate the query..

for e.g. select count(*) from table1 where date('2003-10-09').

But in db2 we have define index on date field. The query is not using index instead it is going for table scan to fetch the rows. Is there any way to suppress the date function in crystal reports else in db2 is there any way to suppress the date fucntion in sql queries which are all executing...

I would ask Crystal Reports support about that. I have no idea why they do that.