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.
ups, still no response :(
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.
do you mean update over database maintenance? need I to update database, not only update view? I'll try it. thanks
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