Pro SQL Server 2012 Reporting Services

CHAPTER 3  INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLS

Figure 3-12. Sample filter on a table data region

Listing 3-3 shows the sample RDL elements of a filter.

Listing 3-3. Parameter and Filter RDL Elements

=IIF(Parameters!User.Value is nothing, "All", Parameters!User.Value)

Equal

=IIF(Parameters!User.Value is nothing, "All",
Fields!LastName.Value)