ask - number records not same between sql and report

Hi there,


I've created new report using crystal report (version 10).

I cross check total sum of one of specific field not equal between report and Query Analyze, then I check number of records I found number records in the report lower than in QA.

how to fix it? I willing to send the report to be analyzed, I need help. thanks before.

  • hello,

    ups, still no response :(

  • In reply to neubie:

    It is not unusual that db-systems (as SQL) return an "approximate number of records", not the exact number.

    Did your try to update your SQL-statistics? It may help...

    Updating statistics uoght to be performed on a regular basis, especially if your have lots of data.

  • In reply to Anfinnur:

    to Anfinnur,


    do you mean update over database maintenance? need I to update database, not only update view? I'll try it. thanks

  • In reply to neubie:

    to Anfinnur,

    do you mean update over database maintenance? I already updated field and record, the first from the list update, and update security (the bottom from the list). anyway, thanks for your advice

  • In reply to neubie: