This topic has not yet been rated - Rate this topic

Working with Formulas (Report Builder 1.0)

SQL Server 2008

SQL Server 2005

Formulas are calculations performed on values in your report. Sometimes, they are referred to as expressions. A formula can contain functions, operators, constants, and references to fields or entities. You do not need to add an equals sign (=) to a formula in Report Builder because it is implicitly stated.

Formulas can look similar to any of the following:

Sum Line Total
6+12
SUM(IF(Finished Goods Flag, "Finished", "Unfinished"))

In This Section

Topic	Description
Creating a New Field (Report Builder 1.0)	Discusses how to create a new field and assign a formula.
Understanding Formulas (Report Builder 1.0)	Discusses how to create a formula.
Modifying Formulas (Report Builder 1.0)	Discusses how to manipulate formulas by aggregating, filtering, and removing duplicates.
Using Functions (Report Builder 1.0)	Discusses the functions available in Report Builder.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Working with Formulas (Report Builder 1.0)

Tasks

Reference

Concepts

Community Additions