Foreword |
|
xiii | |
About the Authors |
|
xv | |
About the Technical Reviewer |
|
xvii | |
Acknowledgments |
|
xix | |
Introduction |
|
xxi | |
|
Architecture and Overview |
|
|
1 | (14) |
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (6) |
|
|
5 | (3) |
|
|
8 | (1) |
|
|
9 | (1) |
|
Installation and Configuration |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
11 | (2) |
|
|
13 | (2) |
|
Report Authoring: Designing Efficient Queries |
|
|
15 | (16) |
|
|
16 | (4) |
|
Creating a Simple Query Graphically |
|
|
16 | (3) |
|
Creating an Advanced Query |
|
|
19 | (1) |
|
Testing Performance with Query Analyzer |
|
|
20 | (8) |
|
|
22 | (2) |
|
Using a Parameterized Stored Procedure |
|
|
24 | (2) |
|
Evaluating the Parameters |
|
|
26 | (1) |
|
|
27 | (1) |
|
Knowing Your Data: A Quick Trick with a Small Procedure |
|
|
28 | (2) |
|
|
30 | (1) |
|
|
31 | (42) |
|
|
32 | (2) |
|
|
32 | (1) |
|
|
33 | (1) |
|
|
34 | (13) |
|
Report Definition Language |
|
|
36 | (1) |
|
Data Sources and Data Sets |
|
|
36 | (7) |
|
|
43 | (1) |
|
|
44 | (1) |
|
|
45 | (2) |
|
|
47 | (25) |
|
|
48 | (1) |
|
|
49 | (6) |
|
|
55 | (4) |
|
|
59 | (3) |
|
|
62 | (2) |
|
|
64 | (4) |
|
|
68 | (2) |
|
|
70 | (2) |
|
|
72 | (1) |
|
|
73 | (32) |
|
Creating a Report with the Report Wizard |
|
|
74 | (3) |
|
Building Reports from Scratch |
|
|
77 | (16) |
|
|
79 | (1) |
|
|
80 | (1) |
|
|
81 | (2) |
|
|
83 | (10) |
|
Report Parameters with Stored Procedures |
|
|
93 | (7) |
|
|
100 | (1) |
|
|
100 | (3) |
|
|
103 | (1) |
|
|
104 | (1) |
|
Using Custom NET Code with Reports |
|
|
105 | (18) |
|
Embedded Code in Your Report |
|
|
106 | (5) |
|
The ExceedMaxVisits Function |
|
|
106 | (2) |
|
Using the ExceedMaxVisits Function in a Report |
|
|
108 | (2) |
|
Accessing .NET Assemblies from Embedded Code |
|
|
110 | (1) |
|
|
111 | (10) |
|
Adding a Class Library Project to Your Reporting Solution |
|
|
112 | (3) |
|
Adding an Assembly Reference to a Report |
|
|
115 | (1) |
|
Debugging Custom Assemblies |
|
|
116 | (2) |
|
Deploying a Custom Assembly |
|
|
118 | (3) |
|
|
121 | (2) |
|
Rendering Reports from .NET Applications |
|
|
123 | (22) |
|
|
124 | (4) |
|
URL Report Access Path Format |
|
|
125 | (1) |
|
URL Parameters and Prefixes |
|
|
126 | (1) |
|
|
126 | (1) |
|
|
126 | (1) |
|
Report Server Command Parameters |
|
|
127 | (1) |
|
|
128 | (1) |
|
|
128 | (1) |
|
Integrating SRS with .NET Applications |
|
|
128 | (15) |
|
Building the Windows Forms Report Viewer |
|
|
129 | (14) |
|
|
143 | (2) |
|
|
145 | (18) |
|
|
146 | (2) |
|
|
148 | (3) |
|
Configuring Report Deployment Options |
|
|
148 | (2) |
|
Deploying Reports Through Solution Explorer |
|
|
150 | (1) |
|
Using the Web Services API |
|
|
151 | (11) |
|
Accessing the Web Service |
|
|
152 | (1) |
|
|
153 | (1) |
|
|
153 | (9) |
|
|
162 | (1) |
|
|
163 | (46) |
|
|
164 | (21) |
|
|
164 | (7) |
|
Creating Snapshots for the Report History |
|
|
171 | (2) |
|
Report Execution and Caching |
|
|
173 | (2) |
|
|
175 | (1) |
|
Creating a Standard Subscription |
|
|
176 | (4) |
|
Data-Driven Subscriptions |
|
|
180 | (5) |
|
Execution Auditing and Performance Analysis |
|
|
185 | (9) |
|
|
185 | (4) |
|
|
189 | (5) |
|
Controlling Reporting Services Programmatically |
|
|
194 | (12) |
|
Controlling Reporting Services with SOAP |
|
|
195 | (11) |
|
Controlling Reporting Services with WMI |
|
|
206 | (1) |
|
|
207 | (2) |
|
|
209 | (28) |
|
Universal Security Challenges |
|
|
210 | (1) |
|
|
210 | (10) |
|
Securing Network Traffic Using SSL |
|
|
211 | (7) |
|
SRS and Secure Data Storage |
|
|
218 | (2) |
|
Authentication and User Access to Data |
|
|
220 | (9) |
|
|
221 | (3) |
|
Testing SRS Role Assignments |
|
|
224 | (4) |
|
Filtering Report Content with User!UserID |
|
|
228 | (1) |
|
Setting Data Source Security |
|
|
229 | (1) |
|
Setting SQL Server Permissions |
|
|
229 | (1) |
|
|
229 | (2) |
|
|
229 | (2) |
|
|
231 | (1) |
|
|
231 | (4) |
|
Implementing SRS with Terminal Services |
|
|
231 | (2) |
|
Implementing for Internal Access |
|
|
233 | (2) |
|
|
235 | (2) |
|
Business Intelligence and SRS |
|
|
237 | (30) |
|
Extending Microsoft CRM with SRS |
|
|
238 | (4) |
|
Using SRS with Custom Help Desk Applications |
|
|
242 | (4) |
|
Report Requirements and Design |
|
|
242 | (1) |
|
|
243 | (2) |
|
|
245 | (1) |
|
Incorporating SRS with SharePoint Portal Server |
|
|
246 | (4) |
|
|
246 | (4) |
|
Project Management and SRS |
|
|
250 | (2) |
|
Building SRS Reports for SQL Analysis Services |
|
|
252 | (13) |
|
Defining Measures and Dimensions |
|
|
253 | (1) |
|
Transforming OLTP Data with DTS |
|
|
253 | (5) |
|
|
258 | (4) |
|
Building SRS Reports with MDX |
|
|
262 | (3) |
|
|
265 | (2) |
|
|
267 | (10) |
|
Tighter Integration with SQL Server |
|
|
267 | (3) |
|
The New Management Studio |
|
|
267 | (2) |
|
The New Business Intelligence Development Studio |
|
|
269 | (1) |
|
Tight Integration with SQL Analysis Services |
|
|
270 | (1) |
|
More Options for Developers |
|
|
271 | (2) |
|
|
271 | (1) |
|
Rendering Reports Without a Server |
|
|
272 | (1) |
|
Use DataSets as Data Sources |
|
|
273 | (1) |
|
New End User Reporting Tool |
|
|
273 | (2) |
|
|
275 | (1) |
|
|
276 | (1) |
Index |
|
277 | |