Skip to Content
avatar image
Former Member

Not retrieving all records

I have a report in Crystal 2008, the database is SQL. The report works but in some cases will not retrieve all records currently in the database. I'm thinking that is has something to do with the indexing.

The predetermined filters and record selects are accurate but there are records that should be on the report but are not.

Can anyone point me in the right direction.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 16, 2008 at 08:21 PM

    If the records are there and the where condition from the select is accurate, the index should not prevent you from being able to read back all required data.

    I suggest that you turn on sql profiler and do a trace while you reproduce the issue. From the trace, look at the select and the where conditions. Check if the where conditions are correct, adjust as necessary.

    Add comment
    10|10000 characters needed characters exceeded