How to: Add, Modify or Delete an Expression [Model Designer]

You can add expressions to folders and entities within Model Designer.

To add an expression

  1. In the Tree view, select the model item.

  2. On the Reporting Model menu, click New Expression.

  3. In the Define Formula dialog box, build your expression, and then click OK.

  4. In the Detail view, right-click the new expression and then click Rename.

  5. Type a name for your expression.

  6. In the Properties area, assign the properties that you want to apply to this field.

To modify an expression

  1. In the Detail view, click the expression that you want to modify.

  2. In the Properties area, click in the Expression box, and then click the Expression button.

  3. Modify the expression and then click OK.

To delete an expression

  • In the Detail view, right-click the expression and then click Delete.

See Also

Concepts

Model Designer Object Properties
Working with Model Designer
Model Designer How-to Topics
Using Functions (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance