I work mostly in 2008, so I'm not sure if that has happened to me in XI, but I'm wondering if the following has happened to anyone else . . . and if you know how to avoid it:

I created a report on a database that does not change (it's a copy used for year-end reporting then archived). It took a number of attempts to get it to work the way I needed it to, but once I did, the totals tied with other reports.

Then this morning I ran the report and the totals were different. I finally tracked it down to the record selection formula. There was nothing wrong with the formula, but the report was not picking up 3 records. I rebuilt the report from scratch and now the totals are correct again.

I've had this happen with formulas, too, where a formula stops evaluating. The only way to fix it is to delete it then re-write it from scratch to get it to evaluate.

Has anyone run across this? And do you have any idea how I can prevent it?

Thanks,
Jessie