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, ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.