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, SQL Query,... on multiple reports at once in Crystal Reports, without having to manually update each report one by one?
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, create a report of any data source.
- Add a picture, or a formula on the report.
- Save the report.
- Create a second report with the same picture, or formula, and save the report.
- Create a third report with the same picture, or formula, and save the report.
- 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, formulas, field formatting, SQL Query, ... on multiple reports at once. It is only possible to modify one report at a time. Therefore to update each report you need to:
- In Crystal Reports, open one report.
- Manually update the formula, image, field formatting, SQL Query,...
- Save the report.
- 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, bulk update, automating report updates, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020