SAP Knowledge Base Article - Public

2727187 - How to update formulas, images, or fields formatting, on multiple reports at once in Crystal Reports?

Symptom

  • How to update formulas on multiple reports?
  • How to replace the pictures on many reports at once?
  • How to change the field formatting on multiple reports?
  • How to perform a mass update of objects on many reports?
  • How to update formulas, images,... on multiple reports at once in Crystal Reports, without having to manually update each report one by one?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Add a picture, or a formula on the report.
  3. Save the report.
  4. Create a second report with the same picture, or formula, and save the report.
  5. Create a third report with the same picture, or formula, and save the report.
  6. After creating multiple reports, found out we need to change the picture, or formulas, how to update all the pictures, or all the formulas in one go, without haveing to open each report one by one, and manually update each picture, or formulas in Crystal Reports?

Resolution

  • Crystal Reports does not have the functionality of updating objects, like pictures, or formulas,... on multiple reports at once. It is only possible to modify one report at a time. Therefore to update each report you need to:
       
    1. In Crystal Reports, open one report.
    2. Manually update the formula, or image, or field formatting,...
    3. Save the report.
    4. Repeat step 1 to 3 for each report on which you need to update the formula, or image, or field formatting,...

Keywords

Mass report update, automating report updates, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016