CONTENTSviiUsing a Parameterized Stored Procedure........................................................................32
Using ISNULL to Evaluate the Parameters..............................................................................................34
Query Performance and Indexes............................................................................................................34
Column and Table Aliasing.....................................................................................................................35
Testing the Procedure............................................................................................................................35
Summary.........................................................................................................................36
Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools..39
Exploring the Elements of BIDS.......................................................................................40
Setting Up a Basic IDE.....................................................................................................43
Understanding Report Definition Language (RDL)...........................................................45
Adding a Report...............................................................................................................46
Setting Up Data Sources and Datasets............................................................................47
Creating a Data Source...........................................................................................................................47
Creating a Dataset..................................................................................................................................49
Creating Other Data Sources..................................................................................................................54
Configuring Parameters...................................................................................................54
Setting up Filters.............................................................................................................56
Expressions.....................................................................................................................58
Summary.........................................................................................................................59
Chapter 4: Laying Out a Report.............................................................................61
Setting Up Pagination......................................................................................................61
Using Report Objects.......................................................................................................62
Implementing a List.........................................................................................................63
Implementing a Textbox..................................................................................................69
Implementing a Table......................................................................................................75
Implementing a Rectangle...............................................................................................80