Seagate Crystal Reports has far-reaching formula capabilities. This chapter will explain to you what formulas are, how to write basic formulas using Crystal syntax, and the different places that these formulas can be used. I will walk you through opening the Formula Editor and writing a formula, and discuss functions and sample formulas. This chapter will get those of you new to SCR started with formulas, and then move right along into the basics of slightly more complex functions and the use of variables. 1 cover several formula types with the goal that you become comfortable with the formula language and the types of functionality that formulas can bring to your reports. This chapter also includes an introduction to using variable^ (with examples, of course!) to simplify longer formulas.
The chapter covers advanced concepts and examples, such as multi-pass reporting, conditional variables, shared variables, solutions for data type consistency, arrays, using control structures, and other hints and tricks. The Advanced Formulas chapter also introduce^ you to a new variation of the Crystal formula language, Basic syntax, which derives from Visual Basic Script language.
What Can Formulas Do for Me?
Formulas can do many things on your reports. They can be used to manipulate data in your report, such as changing the data type or the way a certain field looks or prints. Using formula functions, you can provide additional information on your reports by performing calculations and analysis of existing data. Formulas provide a means to combine data with text strings and create dynamic conditional functionality for both fields and formatting options.