Q:
# How Is a Formula Created in Crystal Reports XI?

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-
Q:
## What Are Some Basic Formulas to Use in Excel?

A: SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parame... Full Answer >Filed Under: -
Q:
## What Are Some Excel Spreedsheet Formulas?

A: Some simple Excel spreadsheet formulas include =SUM(c1+c2) for addition, =SUM(c1-c2) for subtraction, =SUM(c1*c2) for multiplication and =SUM(c1/c2) for di... Full Answer >Filed Under: -
Q:
## What Is a Formula Bar in Excel?

A: The formula bar is a feature in Microsoft Excel that enables users to create and view formulas. It is typically labeled with a function symbol (fx), and it... Full Answer >Filed Under: -
Q:
## What Are the Basics of Using Microsoft Excel?

A: The basics of using Microsoft Excel 2013 include knowing how to create a new workbook, how to enter data in worksheet cells, how to create simple formulas ... Full Answer >Filed Under: