A long time ago I wrote about a bug in Crystal Reports that affects two special fields:
- Modification Date
- Modification Time.
These fields show you when that report was last modified. If you open and refresh a report without changing anything the modification date and time should not change. This works most of the time, but it doesn’t work if you have a subreport.
This came up again this past week and after some discussion I thought of another article that I wrote in January about the options setting ‘Verify on first refresh”. I ran a quick test and found that turning this setting off solved the problem. Apparently, doing that “Verify Database” counts as a report modification – but ONLY if there is a subreport in the report. The behavior is different if there is no subreport. This inconsistency is why I categorize this as a bug.
So if you are using the modification date (or modification time) in a report that has one or more subreports, you might want to turn this setting off. It is found in File > Report Options.
And, if anyone finds an issue with turning off this setting, please let me know. I can’t think of one.