Create a report using the
Orders and Orders Detail tables from the Xtreme sample database.
Select the
Customer
ID field from the Orders table, and the
Product
ID,
Quantity, and
Unit
Price fields from the Orders Detail table, and place them from left
to right in the Body section.
On the
"Field
Explorer" view, right-click
Formulas and click
New.
Double click
My
Formula.
On the
"Properties" view, click
Name and enter a name for the formula.
On the Formulas page, enter
the following formula: