Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step online tutorials.

13.15 Verifying the Data Source

Verifying Changes to the Data Source

If you make changes to a table and its fields using the management console of the database, this will impact the reports that use that table. Modifying a field’s data type can affect how the report formats the data. Changing a field’s name causes the report to lose its reference to the field.

Crystal Reports has a Verify Database function that checks whether the fields in a report match the fields in the current data source. This should be done whenever you suspect that the tables have been modified. Access this function by right-clicking on your report and selecting Database | Verify Database. It will display a confirmation box if the database is up to date. If Crystal Reports determines that the fields in your report do not match, it lets you re-map them to their equivalent fields in the new table structure.