# SQL2008R2 Reporting Services 報表產生器 3.0 快速上手 今天去客戶那邊教了一堂 SQL Server 2008 R2 Reporting Services 基礎課程，雖然短短三個小時能教的東西不多但重點應該都點到了，而且快速上手之後只要有資料在手，透過內建的報表產生器 ( Report Builder ) 應該隨時都很迅速的製作出報表，算是非常方便的報表開發工具，以下就是使用報表產生器快速上手的密技。 ### § 報表設計的三大重點 § 1. 資料來源(Data Source) **有資料**才能設計報表，設定資料來源(Data Source)與建立資料集(DataSet)為重要的第一步驟！ 2. 版面設計(Layout) 清單 (List)、資料表 (Tablix)、矩陣 (Matrix)、圖表 (Chart)、量測器、地圖、走勢圖、指示器、文字方塊、影像、線條、矩形、… 3. 輸出轉譯(Render) XML、CSV、Excel、PDF、MHTML、TIFF、Word 、… ### § 啟動報表產生器的方式 § 報表產生器可以直接從「報表管理員」網站直接利用 ClickOnce 技術線上啟動程式 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b571773de39f0b9b2cbe-image_41.png)  ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5134c7c14ec553e4dbb9-image_42.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ec21c434d55ad3749b2b-image_43.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/585f60fbe60ed770336a-image_44.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/14115f632f912b970b06-image_thumb_5.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/1a1419e3520f50826e53-image_45.png) ### § 報表快速上手第一步：建立資料來源 § ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/483ad451969ee7e56540-image_46.png) **選項一：建立全站共用的資料來源** 建立資料來源就等於「選用資料庫」的意思，讓你可以在報表中選擇要用哪個資料庫當成資料來源，進而運用這個資料來源的資料進行報表設計。 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c9935d1008738a738251-image_47.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8325fa079fde274a20eb-image_48.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/197f63da85e7e457b32d-image_49.png) ****選項二：**直接內嵌資料來源於報表內** [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/8184dc39eaa4ac9d70d3-image_thumb_6.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9124210974953316a232-image_50.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/234c6b41a730a7ead3ce-image_thumb_7.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/399b3557f131df7add11-image_51.png) ### § 報表快速上手第二步：建立資料集 § 注意：要有資料，才能設計報表。有了資料來源後，還要建立**資料集**才能將資料顯示於報表上！ ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ba7eaedd11810f9b3ad4-image_52.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d4b43d50ef83abb03478-image_thumb_8.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/148c4ccb8146756c5f9a-image_53.png) 注意：報表產生器也能建立「共享資料集」，也就是將資料集儲存在報表伺服器上供有權限的人使用。 ![新報表或資料集](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7f6473233662dad91e86-image_54.png "新報表或資料集") ### § 報表快速上手第三步：設計報表 §  ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/22f5bdb5362936dd7900-image_55.png) 用滑鼠在設計畫布上用拖曳的方式拉出一個資料表，高度不用太高： [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c2b198bc1c2f3d4d34c4-image_thumb_9.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/beb0f0a9e209df51f026-image_56.png) 完成的畫面如下： [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b001a8d1e8fc04673d52-image_thumb_10.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/9c92475e3a87434e971d-image_57.png) 接著用拖曳的方式將要放在報表上的欄位拖曳至資料區 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/dc1d429f93e1234c19a8-image_thumb_11.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0883b830eb541611e244-image_58.png) 欄位選取完畢後可以修改「頁首」的欄位名稱 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0ddabb4a543862d8539f-image_thumb_12.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/865e71706878c892bb3a-image_59.png) 直接按下執行按鈕，報表就可以馬上顯示結果： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0b7a72ddd08441f97278-image_60.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ea9bff41b2ee11d107a5-image_61.png) 最後，你可以把報表儲存在 Reporting Services 報表伺服器上！ ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5164b12255322541a7a3-image_62.png) 最後選取要儲存的報表路徑，設定報表名稱，並按下 \[儲存\] 按鈕即可將報表儲存於報表伺服器上 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c6ece14384176305db5e-image_63.png) 儲存後就會出現在報表管理員裡了，可供具有權限的人查閱報表！ ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/fd80427f0c981eada658-image_64.png) 除了查看報表外，還能將報表輸出轉譯(Render)成各種不同的格式 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/75bfd2e1bc974c8c4f2c-image_thumb_13.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5ce8fbcceaabb1d2e7ba-image_65.png)  以上簡單三個步驟，即可快速建立一些常用且簡單的報表，若在進一步熟悉群組的使用或搭配精靈設計其他類型的報表，相信很快就能設計出實用的報表格式，不過有個重要的前提：**你要清楚知道你想要分析什麼資料！** 注意：報表產生器(Report Builder)一次只能設計一張報表，不像報表設計師(Report Designer)可以在一個專案裡同時開發多份報表。 **相關連結** - [開發 (Reporting Services)](http://technet.microsoft.com/zh-tw/library/bb522683.aspx) - [開始使用報表產生器 3.0](http://technet.microsoft.com/zh-tw/library/dd220460.aspx)