Wednesday, January 17, 2007

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.

No comments: