Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Exclamation Unanswered: problem with date function generated in crystal reports

    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...

  2. #2
    Join Date
    May 2003
    I would ask Crystal Reports support about that. I have no idea why they do that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts