Crystal Reports prompting for password

That sounds like a classic Crystal Reports time zone/DST headache. It is a known issue that pops up often, particularly when reports deal with date/time fields that aren't handling the Daylight Saving Time transitions gracefully.

Here's the gist of what's likely happening and why re-saving helps:

🤯 The Core Problem: Time Zone Confusion

Many date/time calculations or settings within a Crystal Report rely on the operating system's current time zone and DST rules. When the system clock "springs forward" or "falls back," the report's saved logic might be temporarily out of sync with the new system time.

Internal Data Stale: The report might have saved a time zone offset or a date/time stamp using the old system time settings.
The "Fix": Opening and re-saving the report forces it to re-read the current operating system time zone settings and recalculate/update its internal date/time references to align with the new DST status.