Create formulas in Crystal Reports XI with the Formula Workshop tool. Click the Formula Workshop button on the toolbar to open the window. Select New at the top of the window, and type in a name for the new formula.
Continue ReadingThe Formula Editor window has three panes. The left pane lists all available formulas and connections, the middle pane lists available functions, and the right pane contains a list of operators. Select functions and operators from the panes to create the desired formula. If you require a custom formula, type the syntax in the formula box. Once the formula is complete, click Save, and close the window.
The Field Explorer tab lists the created formula. Click the formula, and drag it to the desired location on the report. Crystal Reports uses two different syntax types, Crystal and BASIC, and most formulas work in either syntax. A report sometimes contain formulas written in both BASIC and Crystal syntax, but a single formula is either one or the other.
As of 2015 a detailed list of syntax and formulas for both Crystal and BASIC is available in the Microsoft Developer Network Library. The MSDN Library also provides tutorials and examples of formulas for developers using Crystal Reports for Microsoft Visual Studio.
Learn more about Software