Microsoft SQL Server 2012 Reporting Services Advanced Tutorial (2nd Edition)

About this manual

This book provides a comprehensive guide to SQL Server 2012 Reporting Services, targeting report designers, developers, system engineers, DBAs, and BI analysts. It explains basic concepts, advanced features such as Power View and Power Pivot, and includes many examples and code samples.

The text covers installation, architecture, rendering extensions (PDF, Excel, Word), database structures, scheduling, security, and deployment considerations. It also discusses the evolution of Reporting Services and its role in self‑service BI. This manual is written in Chinese.

What's inside

• Introduction
• Installation and Architecture
• Rendering Extensions (PDF, Excel, Word)
• Report Server Database
• Planning and Delivery
• Security and Management
• Advanced Features (Power View, Power Pivot)
• Appendix

Specifications

Frequently asked questions

What software is needed to view PDF reports generated by Reporting Services?

You need Adobe Acrobat Reader 8.0 or a later version to view PDF reports.

What file format does Reporting Services generate for Excel by default?

Reporting Services generates Excel OOXML (XLSX) files by default.

Which database stores the main Reporting Services data such as report definitions?

The ReportServer database stores the main Reporting Services data.