Wednesday, November 09, 2011

Fix: Crystal 2008 Doesn't Refresh After Adding Columns [Field Notes]

Issue

Crystal Reports 2008 Designer does not reflect changes made to views or stored procedures, even after refreshing the database and those views/procedures within Crystal.

Resolution

While a horrible user experience, there is a proper method to accomplish this.

Based on trips from this helpful article:
  • From the "Database" menu, click "Verify Database".
  • If dealing with a stored procedure, you will be asked to enter parameters; enter correct ones.
  • Crystal Reports will undergo a verification process, during which time it will find the extra fields and adjust the report accordingly.

No idea why this is separate from (and ambiguously named compared to) a right-click and "refresh", but it does the job.

No comments:

Post a Comment

Keep it classy, folks.