Tip:
Formula fields are fields that appear on the report after the @ symbol.
For a printable version of the Reporting topics, click here: http://ws4.insightdirect.com/Download/Website/docs/Crystal_Reports.pdf
Previous Topic: Grouping Fields
A formula is a symbolic statement of the actions you want to perform on data before it is displayed on your Crystal Reports report. These are used to provide an extra degree of control over the report's output. Formula fields are constructed using a simple scripting language, very similar to Visual Basic. You can use formulas to calculate numeric values, compare one value to another and select alternative actions based on the comparison, join multiple values into a single string, and to perform a multitude of other operations.
|
|
Tip: |
A two pass formula is a formula that requires two passes through the data for completion. The first pass performs some calculation or selection and the second pass performs a calculation or selection that uses the result generated by the first pass.
An example of a two pass formula is one that calculates the sales for each sales representative as a percent of total company sales. The first pass sums the sales for each representative to arrive at total company sales. The second pass divides the sales per representative by total company sales to calculate the percent of total sales.
Next Topic: Editing Crystal Reports Formulas
Back to Reports Table of Contents