Crystal Reports - Apply changes of DB source to the Report

To apply immediately the DB changes (new fields added, field datatype changed, etc.) to the report source:

• Go to Field Explorer

• Right click Database Fields

• Verify Database

When XSD data files will be used as a DB source for report – first logoff all “online” datasets with following steps:

• Go to Field Explorer

• Right click Database Fields

• Log On/Off Servers

• Project Data

• Current Connections

• Choose all available items

• Log Off
  

Then Verify Database - first 3 steps.

Crystal Reports - How to remove old DB source from Report or Subreport

To remove an old DB source from report or subreport - there should be no fields in use from these source. If there are still red-checked fields in the source - follow:

• Remove all fields of these source from all report sections

• Remove all fields of these source from all Formula Fields

• Remove all fields of these source from all Fields formula properties

• Remove all fields of these source from all Groups and Group custom names

• Remove all fields of these source from all Records and Group Selection Formula (Right click - Report - Edit Selection Formula - Record.../Group...)

• Remove all links to subreport and close all open subreports (Right click - Close Subreport)

Note: If you try to remove a source which has a fields in use (red-checkmarked and showing confirmation when removing) - then your Visual Studio will crash without save your last changes. In that case try to search a temp copy of your report in the same folder. Always SAVE before removing a data source.