Chapter 5. Developing Expressions

After completing this chapter, you will be able to:

  • Use expressions to calculate values for display in a text box.

  • Create aggregation functions in expressions to summarize data.

  • Develop expressions to change the appearance or behavior of report items.

  • Use variables to extend the flexibility of expressions.

  • Build dynamic connection strings and query strings.

  • Use expressions for data in a recursive hierarchy group.

You can build many reports that rely exclusively on data that comes straight from the data source using the techniques you learned in Chapter 4, but often the real value of information in reports comes from enhancing the data. You can include derived information in your report by creating calculations based ...

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.