Formula Workshop

E-invoicing in Germany: How to implement the obligation with SAP Business One

Of the Formula Workshop is the central formula editor in SAP Crystal Reports. It is used to write formula fields, conditional formatting, selection formulas, running totals, and group-specific calculations — everything that goes beyond the mere placement of database fields. The workshop accompanies the entire lifecycle of report logic within a Crystal Reports layout.

Context

The Formula Workshop can be opened, for example, via View → Formula Workshop or from format dialogs (click on the x+2– Button next to a property). It offers two syntax variants: Crystal Syntax (Standard, Pascal-like) and Basic Syntax (Visual Basic-like). Typical use cases: conditionally adjusting font size, e.g.

if {@LanguageCode%} = "D" then 10 else 12

for a German document a more compact font than for other localisations. In addition, Formula Fields (visible result fields), Selection Formulas (Database-level record filter) and Running Totals (running totals over groups) are maintained. The workshop provides function categories: strings, date/time, mathematical functions (ABS, CEILING, FLOOR, MAX, MIN, ROUND), logical functions, summation functions, and special fields such as Page number or Record Number. Arithmetic operators, parentheses, and function calls can be typed or inserted via a menu. A test console checks the syntax before the formula is applied to the layout.

Demarcation

The Formula Workshop is not an SQL editor: it works on the data that the report has already imported, not directly on the Database. For SQL-like logic, Views, Stored Procedures or Command Objects within Crystal are better suited. It is also not identical to Formatted Searches in the SAP Business One client (determining UDF values via database queries), and not with the formula language of Pervasive analytics- KPIs that offer similar arithmetic and numerical functions (ABS, CEILING, FLOOR, MAX, MIN, ROUND), but operate on HANA views instead of Crystal datasets.