Pro Sql Server Reporting Services

by ;
Format: Paperback
Pub. Date: 2004-09-30
Publisher(s): Apress
List Price: $44.99

Buy New

Usually Ships in 2-3 Business Days.
$44.54

Rent Book

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:30 Days access
Downloadable:30 Days
$14.40
Online:60 Days access
Downloadable:60 Days
$19.20
Online:90 Days access
Downloadable:90 Days
$24.00
Online:120 Days access
Downloadable:120 Days
$28.80
Online:180 Days access
Downloadable:180 Days
$31.20
Online:1825 Days access
Downloadable:Lifetime Access
$47.99
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$31.20*

Used Book

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

...with Apress, good books do not necessary mean 1,000 page books. Highly recommended. - Guy Barrette, Universal Thread MagazinePro SQL Server Reporting Servicesfrom Apress is going to be one of the greatest learning resources for anyone who wants to start leveraging the benefits of SQL Server Reporting Services. - Palak Patel, SQL Square(Now featured proudly in the January 2005 issue of SQL Server Magazine! )You don't have to be a database expert to create high-quality, high-impact reports with SQL Server 2005 Reporting Services (SSRS). Whatever your reporting needs or your technical expertise, you can quickly become comfortable and productive with SSRS. From the simplest reports, to graphical and Web-deployed presentations, to report security and administration, everything you need to know, and how to do it efficiently and proficiently, is clearly explained inPro SQL Server 2005 Reporting Services.Since its release in 2004, SSRS has become one of the premier reporting environments because it comes free with SQL Server, is easy to use, and offers a comprehensive set of features that are matched by few competitors. With SQL Server 2005, SSRS is even more powerful and user friendly. If you have SQL Server 2005 and aren't using Reporting Services, it's time to start.Pro SQL Server 2005 Reporting Serviceswill get you off to the fastest start and will quickly make you an SSRS expert.Pro SQL Server 2005 Reporting Servicescarefully examines all SSRS features for designing, developing, deploying, and administering professional business reports in a variety of presentation styles and delivery formats. Intended for all levels of SSRS users, it provides in-depth explanation and detailed examples of the most important SSRS features, with practical guides, tips, best practices, and code based on complex real-world reporting requirements. It covers all of the new functionality of SSRS 2005, including the new management and Business Intelligence (BI) development studios as well as new report viewer controls and end-user reporting tools. The emphasis throughout is on understanding what SSRS can do and learning the most effective techniques for exploiting its power.Pro SQL Server 2005 Reporting Servicesintroduces the SSRS architecture and tools, but it also explores many advanced features, including: high-performance queries; the Report Definition Language standard; rendering reports in HTML, XML, PDF, and Excel; report administration and security; building custom .NET applications with SSRS; and integrating SSRS with Analysis Services and other BI tools and products.The authors are experienced professionals in medical business reporting, which is subject to rigorous HIPAA regulations and strict security. They take a hard, critical look at how SSRS can provide exactly what is needed to deliver enterprise-level reports that satisfy stringent business and legal requirements. Their code examples are based on real-world demands for versatile, dynamic, incisive information delivery that truly enhances business decision-making.Anyone who needs to create, manage, or distribute any kind of business information can quickly become an SSRS expert withPro SQL Server 2005 Reporting Services!

Table of Contents

Foreword xiii
About the Authors xv
About the Technical Reviewer xvii
Acknowledgments xix
Introduction xxi
Architecture and Overview
1(14)
Benefits of SRS
1(1)
Green Bar, Anyone?
2(2)
SRS Architecture
4(6)
Client Applications
5(3)
SRS Report Server
8(1)
SRS Databases
9(1)
Installation and Configuration
10(1)
Deploying SRS Securely
11(1)
Sample Application
11(2)
Summary
13(2)
Report Authoring: Designing Efficient Queries
15(16)
Query Design Basics
16(4)
Creating a Simple Query Graphically
16(3)
Creating an Advanced Query
19(1)
Testing Performance with Query Analyzer
20(8)
Dividing the Load
22(2)
Using a Parameterized Stored Procedure
24(2)
Evaluating the Parameters
26(1)
Testing the Procedure
27(1)
Knowing Your Data: A Quick Trick with a Small Procedure
28(2)
Summary
30(1)
The Report Designer
31(42)
Elements of VS.NET
32(2)
Projects and Solutions
32(1)
Setting up a Basic IDE
33(1)
Report Basics
34(13)
Report Definition Language
36(1)
Data Sources and Data Sets
36(7)
Parameters
43(1)
Filters
44(1)
Expressions
45(2)
Report Layout
47(25)
Pagination Settings
48(1)
List
49(6)
Table
55(4)
Rectangle
59(3)
Matrix
62(2)
Chart
64(4)
Image
68(2)
Two Simple Tips
70(2)
Summary
72(1)
Building Reports
73(32)
Creating a Report with the Report Wizard
74(3)
Building Reports from Scratch
77(16)
Formatting the Output
79(1)
Adding Subtotals
80(1)
Adding Interactivity
81(2)
Visibility
83(10)
Report Parameters with Stored Procedures
93(7)
Applying a Filter
100(1)
Adding a Chart
100(3)
Adding the Final Touches
103(1)
Summary
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)
Using Custom Assemblies
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)
Summary
121(2)
Rendering Reports from .NET Applications
123(22)
URL Access
124(4)
URL Report Access Path Format
125(1)
URL Parameters and Prefixes
126(1)
Report Parameters
126(1)
HTML Viewer Parameters
126(1)
Report Server Command Parameters
127(1)
Credential Parameters
128(1)
Example URLs
128(1)
Integrating SRS with .NET Applications
128(15)
Building the Windows Forms Report Viewer
129(14)
Summary
143(2)
Deploying Reports
145(18)
Using Report Manager
146(2)
Using VS.NET
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)
Laying out the Form
153(1)
Coding the Form
153(9)
Summary
162(1)
Report Management
163(46)
Content Management
164(21)
Shared Schedules
164(7)
Creating Snapshots for the Report History
171(2)
Report Execution and Caching
173(2)
Managing Subscriptions
175(1)
Creating a Standard Subscription
176(4)
Data-Driven Subscriptions
180(5)
Execution Auditing and Performance Analysis
185(9)
Configuring SRS Logging
185(4)
Performance Testing
189(5)
Controlling Reporting Services Programmatically
194(12)
Controlling Reporting Services with SOAP
195(11)
Controlling Reporting Services with WMI
206(1)
Summary
207(2)
Securing Reports
209(28)
Universal Security Challenges
210(1)
Data Encryption
210(10)
Securing Network Traffic Using SSL
211(7)
SRS and Secure Data Storage
218(2)
Authentication and User Access to Data
220(9)
SRS Roles
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)
Report Auditing
229(2)
SRS Auditing
229(2)
Windows Auditing
231(1)
Deployment Models
231(4)
Implementing SRS with Terminal Services
231(2)
Implementing for Internal Access
233(2)
Summary
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)
Building the Report
243(2)
Rendering in OWC
245(1)
Incorporating SRS with SharePoint Portal Server
246(4)
Preparing the SRS URL
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)
OLAP Cube Design
258(4)
Building SRS Reports with MDX
262(3)
Summary
265(2)
Future SRS
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)
Report Viewer Controls
271(1)
Rendering Reports Without a Server
272(1)
Use DataSets as Data Sources
273(1)
New End User Reporting Tool
273(2)
Beyond SQL 2005
275(1)
Summary
276(1)
Index 277

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.