O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5 Quick Reference

To

Do This

Add a calculated field to a dataset

In the Report Data pane, right-click the dataset, click Add Calculated Field, type a name in the Field Name text box in the bottom row, click the Expression button, and construct an expression for the calculated field by typing the expression or using the expression lists.

Create a text box expression

Right-click a text box, click Expression, and construct an expression.

Refer to the value in another text box

Assign a name to the text box (if you want), and then create an expression using the ReportItems collection. For example, to return the value of the BusinessTypeTotal text box, use this expression: =ReportItems!BusinessTypeTotal.Value

Add global report information to the report, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required