Chapter 12Expressions and Actions

The real power behind Reporting Services is its ability to creatively use data groups, and combinations of report items. Calculations and conditional formatting can be added by using simple expressions and more advanced programming code. Whether you are an application developer or a report designer, this chapter contains important information to help you design reports to meet your users' requirements and to raise the bar with compelling report features.

Coupled with expressions and parameters, report actions are used to take reporting solutions to the next level and build comprehensive dashboards and report navigation experiences.

BASIC EXPRESSIONS RECAP

In previous chapters, we used expressions for a variety of things but have just scratched the surface. You can do a lot with a little code and some creative design. Recall that we used expressions to create standardized report and page header content. You should remember that any textbox bound to a dataset field or built-in field actually contains an expression.

Also recall that you can build simple composite values in a textbox by dragging items from the Report Data pane into a textbox. For example, if you want to display the page number and total number ...

Get Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports 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.