Chapter 7: Formulas and Logic

Overview

In previous chapters, we've looked at creating and integrating reports, creating and consuming XML Report web services, and working with .NET data. In this chapter, we'll be narrowing our focus to look at where the majority of Crystal Reports development time is spent: writing formulas and logic. This will include:

Deciding how to integrate logic into your report

Working with the Formula Editor

Creating formulas with Basic syntax

Creating formulas with Crystal syntax

Writing record selection formulas

Using conditional formatting

At the end of this chapter, you will be able to identify the best way to add calculations and logic to your report, and understand enough syntax and code to handle most situations. You should also be able to differentiate between the two different 'flavors' of the Crystal Formula Language, and to write your own record selection and conditional formatting formulas.