Pro SQL Server 2005 Reporting Services,9781590594988

Pro SQL Server 2005 Reporting Services

by
ISBN13: 9781590594988
ISBN10: 1590594983
Format: Paperback
Pub. Date: 2005-10-27
Publisher(s): Apress
List Price: $44.99

Buy New

Usually Ships in 2-3 Business Days
$44.54
Add to Cart

Rent Book

Select for Price
Add to Cart
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 non-refundable digital delivery fee of $3.99 will be charged on each digital item.
$31.20*
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $8.73

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

SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft,. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server and .NET developers. This book was written in parallel with a migration project, moving some 200 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, and so is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. You will find step-by-step guides, best practices, and real code examples that cover all of the common Reporting Services tasks.

Table of Contents

About the Authors xiii
About the Technical Reviewers xv
Acknowledgments xvii
Introduction xix
Introducing the Reporting Services Architecture
1(16)
Understanding the Benefits of SSRS
2(5)
SQL Server 2005 Reporting Services Enhancements
4(2)
SSRS and Business Intelligence
6(1)
Exploring the SSRS Architecture
7(6)
SSRS Databases
8(1)
The SSRS Report Server
8(2)
Client Applications
10(3)
Installing and Configuring
13(1)
Deploying SSRS Securely
14(1)
Summary
15(2)
Report Authoring: Designing Efficient Queries
17(18)
Introducing the Sample Relational Database
18(3)
Introducing the Schema Design
18(1)
Knowing Your Data: A Quick Trick with a Small Procedure
19(2)
Introducing Query Design Basics
21(9)
Creating a Simple Query Graphically
21(3)
Creating an Advanced Query
24(6)
Using a Parameterized Stored Procedure
30(4)
Using Case and ISNULL to Evaluate the Parameters
32(1)
Testing the Procedure
33(1)
Summary
34(1)
Using Report Designer
35(46)
Exploring the Elements of BIDS
36(15)
Setting Up a Basic IDE
38(1)
Understanding Report Definition Language (RDL)
39(1)
Adding a Report
40(1)
Setting Up Data Sources and Datasets
41(5)
Setting Parameters
46(2)
Setting Up Filters
48(2)
Expressions
50(1)
Laying Out a Report
51(28)
Setting Up Pagination
52(1)
Using Report Objects
53(24)
Implementing Two Simple Report Design Tips
77(2)
Summary
79(2)
Building Reports
81(42)
Creating a Report with the Report Wizard
82(3)
Building Reports from Scratch
85(20)
Formatting the Output
87(1)
Adding Subtotals
88(1)
Adding Interactivity
89(16)
Setting Report Parameters with Stored Procedures
105(9)
Applying a Filter
111(1)
Adding a Chart
112(2)
Adding the Final Touches
114(2)
Working with Multivalued Parameters
116(5)
Summary
121(2)
Using Custom .NET Code with Reports
123(24)
Using Embedded Code in Your Report
124(8)
Using the ExceedMaxVisits Function
125(3)
Using the ExceedMaxVisits Function in a Report
128(3)
Accessing .NET Assemblies from Embedded Code
131(1)
Using Custom Assemblies with Your Report
132(14)
Adding a Class Library Project to Your Reporting Solution
133(3)
Deploying a Custom Assembly
136(4)
Adding an Assembly Reference to a Report
140(3)
Debugging Custom Assemblies
143(2)
Troubleshooting Your Project
145(1)
Summary
146(1)
Rendering Reports from .NET Applications
147(28)
Implementing URL Access
149(4)
URL Report Access Path Format
150(1)
URL Parameters and Prefixes
150(1)
Report Parameters
151(1)
HTML Viewer Commands
151(1)
Report Server Command Parameters
151(1)
Credential Parameters
152(1)
Example URLs
152(1)
Integrating SSRS 2005 with .NET Applications
153(20)
Building the Report Viewer Using a WebBrowser Control
153(2)
Building the Report Viewer Using a Report Viewer Control
155(18)
Summary
173(2)
Deploying Reports
175(22)
Using Report Manager
176(3)
Using SQL Server Management Studio (SSMS)
179(2)
Using BIDS and Visual Studio 2005
181(3)
Configuring Report Deployment Options
181(3)
Using the Report Server Web Service
184(11)
Accessing the Web Service
185(1)
Laying Out the Form
186(1)
Coding the Form
187(6)
Running the Application
193(2)
Summary
195(2)
Managing Reports
197(52)
Exploring Management Roles in SSRS Deployment
197(1)
Managing Content
198(24)
Setting Up Shared Schedules
198(7)
Setting Up a Data Source for the Report
205(1)
Creating Snapshots for the Report History
206(3)
Executing Reports and Performing Caching
209(2)
Managing Subscriptions
211(11)
Using SSMS and SSRS
222(3)
Performing Execution Auditing and Performance Analysis
225(9)
Configuring SSRS Logging
226(5)
Monitoring Performance
231(3)
Controlling SSRS Programmatically
234(12)
Controlling SSRS with SOAP
234(11)
Controlling SSRS with WMI
245(1)
Summary
246(3)
Securing Reports
249(36)
Encrypting Data
250(11)
Introducing Encryption
250(1)
Securing Network Traffic Using SSL
251(10)
Setting Up Authentication and User Access to Data
261(16)
Introducing SSRS Roles
262(5)
Testing SSRS Role Assignments
267(6)
Filtering Report Content with User!UserID
273(2)
Setting Data Source Security
275(1)
Setting SQL Server Permissions
276(1)
Auditing Reports
277(1)
Introducing SSRS Auditing
277(1)
Introducing Log File Auditing
278(1)
Exploring Deployment Models
278(5)
Implementing SSRS with Terminal Services
279(3)
Implementing for Internal Access
282(1)
Summary
283(2)
Delivering Business Intelligence with SSRS
285(36)
Extending Microsoft CRM with SSRS
286(8)
Using the Report Pack for Microsoft CRM 1.2
287(4)
Creating Custom SSRS Reports for Microsoft CRM
291(1)
Creating the Sales Projections Chart Report
292(1)
Creating the Lead Conversion Report
293(1)
Managing Projects with SSRS
294(2)
Building SSRS Reports for SQL Analysis Services
296(12)
Using Analysis Service Cube with SSRS
301(1)
Setting Up the Analysis Services Data Source
301(2)
Working with the Graphical MDX Query Builder
303(5)
Incorporating SSRS with SharePoint Portal Server
308(11)
Creating a Web Part Page
308(2)
Adding Web Parts
310(9)
Summary
319(2)
Performing Ad Hoc Reporting Using Report Builder
321(42)
Getting User Feedback
322(2)
Introducing the Report Model
324(17)
Adding a Report Model to BIDS
324(1)
Adding a Data Source
325(3)
Creating a Data Source View
328(6)
Creating a Report Model
334(7)
Using Report Builder
341(21)
Creating a Table Report
344(7)
Adding a Matrix Report
351(6)
Adding a Chart Report
357(5)
Summary
362(1)
Index 363

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.