I have various reports analysing data from a single .dbf. These are all Summary Reports with the group set to field 'date', some by month some by week. All except one work as expected. All data is searched for on a screen based on the same dbf file then the reports can be launched via buttons running macros which simply change the view. The problem report is a weekly one which in all other respects is a duplicate of a monthly one which works fine. It has just four other fields, a scount & a ssum of the 'Amount1' field plus two fields with derived data. These are Calc fields like so: If(Status='R',Amount2,0) & IF(Status='D',Amount3,0). These are applied, via the dialog box, as Ssum(....) in the normal way.
When the search is done the number of records is noted, after each of the reports is run the record count remains the same, as expected - except when the faulty report is run when the record count is a constant figure different to the found set, and the report is showing the wrong data.
When the search is done the number of records is noted, after each of the reports is run the record count remains the same, as expected - except when the faulty report is run when the record count is a constant figure different to the found set, and the report is showing the wrong data.