• We can't really help you without table and index DDL, sample data and the query for the report.

    John