Report Builder - Professional SQL Server 2005 Reporting Services - page 394

Figure 9-27
Adding Calculations with Expressions
A major advanced feature of Report Builder is the ability to add expressions to your reports. Expressions
allow you to add custom fields, modify filters, and modify report results. In this section, you look at
adding a new custom field to your report. In the process, you will learn about the main areas of the
expression editor and how they are used.
For this section, you will continue to use the Table Layout Product Sales report. Make sure that the
report is open in design view with the Explorer window and Fields list on the left-hand side. Above the
field list is an icon to add new fields. You want to add a field to your report that calculates the Average
Price based on Sales Amount divided by Order Quantity. Click on the new field button, shown in Fig-
ure 9-28, to bring up the formula editor, shown in Figure 9-29. Be sure that Reseller Sales is selected in
the Explorer window.
Figure 9-28