Symptom
- How to get the list of all the formulas used on a report, along with the formula code?
- How to get a list of Database Fields, Formula Fields, Parameter Fields, Running Totals, SQL Expressions, Special Fields used on a report in Crystal Reports?
Environment
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- SAP Crystal Reports 2025
Resolution
- To create a document listing all the Formula Fields, Parameter Fields, Running Totals, SQL Expressions, etc... used on a report in Crystal Reports, export the report to the format: "Report Definition"
- Report Definition format exports your report to a text file that contains a brief description of the report's design view. It does not export any data. It exports the objects used in each section of the report like: database fields, formula fields, etc...
- To export a report to the format: "Report Definition"
- In Crystal Reports, open your report.
- Under the menu "File", select "Export - Export Report"
- In the Export window, select the format: "Report Definition"
- Click "OK"
- Open the text file to see the report definition.
- Note: There is no feature to obtain the list of all formulas, parameters, fields,... used on multiple reports. It is only possible to get a report definition for one report at a time.
Keywords
List of formulas, Print formulas, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025