tailieunhanh - Beginning SQL Server 2005 for Developers From Novice to Professional phần 10

Các lĩnh vực chủ yếu tập trung xử lý lỗi và tham gia các bảng để trả lại kết quả. Hãy dành thời gian để hoàn toàn hiểu những gì đang xảy ra và làm thế nào bạn có thể sử dụng hai tính năng cả các quyền. Không có một phần của công việc này có thể được sao chép | 454 CHAPTER 14 SQL SERVER 2005 REPORTING SERVICES The Application Layer At the application layer level you will find report design tools configuration tools and custom applications that use Reporting Services. Let s see how they re used. Web Browser The simplest way to access a report server is using a browser. On the report server all the items such as reports report models and shared data sources are organized using a folder hierarchy. The folder hierarchy looks like a file system but actually all folders and items are stored in SQL Server databases. You can navigate through this hierarchy and view reports using a browser. The path to a report will be included in the URL used by the browser to display the report. For example one of the reports we will create in the demo section Building a Report Model can be viewed with a browser using this URL http localhost Reports Pages Report .aspx ItemPath 2fAd Hoc Report. Another use for a web browser is web-based management using Report Manager. Report Manager is an web application used as a management tool for Reporting Services. Report Tools A new option in SQL Server 2005 Reporting Services is the ability to create report models and ad hoc reports. A report model hides the complexity of a report. Based on a model a business user can create with limited technical knowledge ad hoc reports. You will see them at work in the examples later in the chapter. To create reports report models or ad hoc reports you have several options from Notepad to third-party tools. I will not talk about Notepad but I will mention briefly the other options. Business Intelligence Management Studio Based on a Visual Studio 2005 shell Business Intelligence Management Studio is the tool that allows you to create Business Intelligence projects. For Reporting Services you have three project templates available Report Model Project Report Server Project and Report Server Project Wizard. Using the project templates will actually start the .