O'Reilly logo

Special Edition Using® Crystal Reports® 10 by Roger Sanborn, Steve Lucas, Kathryn Hunt, Joe Estes, Michael Voloshko, James Edkins, Bob Coates, Naisan Geula, Ryan Marples, Neil FitzGerald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Brackets in Formulas

Regardless of which syntax is chosen, some fundamental concepts to formula creation are important.

Several variations of brackets are used within the formula language, and it can be confusing to know which one to use at a particular time. To clear up some of the confusion, here is a way to remember them phonetically:

  • {} French = Fields

    For example, {Table.Field} is used to refer to fields, formula fields or parameter fields in the report definition.

  • [] Square = Selected

    For example, {Table.Field}[1] returns only the first character of a string field. Square brackets are used for indexes on array types (for example, strings or array data types).

  • () Parenthesis = Parameters

    For example, Function ({Table.Field}) passes the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required