建立基本資料表報表 (SSRS 教學課程)Create a Basic Table Report (SSRS Tutorial)

在本教學課程中,您可以使用 Visual Studio / SQL Server Data Tools (SSDT) 中的 [報表設計師] 工具。In this tutorial, you use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT). 您可以建立 SQL Server Reporting Services (SSRS) 編頁報表。You create a SQL Server Reporting Services (SSRS) paginated report. 報表包含查詢資料表,該資料表是從 AdventureWorks2016 資料庫中的資料建立的。The report contains a query table, created from data in the AdventureWorks2016 database.

當您繼續本教學課程時,您將了解如何:As you progress in this tutorial, you're going to learn how to:

  • 建立報表專案。create a report project.
  • 設定資料連線。set up a data connection.
  • 定義查詢。define a query.
  • 新增資料表資料區域。add a table data region.
  • 設定報表格式。format the report.
  • 群組和總計欄位。group and total fields.
  • 預覽報表。preview the report.
  • 選擇性地發佈報表。optionally publish the report.

需求Requirements

您的系統上必須安裝下列元件,才能使用本教學課程:Your system must have the following components installed to take this tutorial:

  • MicrosoftMicrosoft SQL Server 資料庫引擎。SQL Server database engine.
  • SQL Server 2016 Reporting Services 或更新版本 (SSRS)。SQL Server 2016 Reporting Services or later (SSRS).
  • AdventureWorks2016 資料庫。The AdventureWorks2016 database. 如需詳細資訊,請參閱 AdventureWorks 範例資料庫For more information, see Adventure Works Sample Databases.
  • 安裝適用於 Visual Studio 的 SQL Server Data Tools,以及 Reporting Services 延伸模組可啟用對報表設計師的存取。SQL Server Data Tools for Visual Studio along with the Reporting Services extension installed to enable access to the Report Designer.

另外,您也必須擁有從 AdventureWorks2016 資料庫擷取資料的唯讀權限。You must also have read-only permissions to retrieve data from the AdventureWorks2016 database.

完成這個教學課程的估計時間: 30 分鐘。Estimated time to complete the tutorial: 30 minutes.

後續步驟Next steps

第 1 課:建立報表伺服器專案 (Reporting Services)Lesson 1: Creating a Report Server Project (Reporting Services)

第 2 課:指定連接資訊 (Reporting Services)Lesson 2: Specifying Connection Information (Reporting Services)

第 3 課:定義資料表報表的資料集 (Reporting Services)Lesson 3: Defining a Dataset for the Table Report (Reporting Services)

第 4 課:將資料表加入至報表 (Reporting Services)Lesson 4: Adding a Table to the Report (Reporting Services)

第 5 課:格式化報表 (Reporting Services)Lesson 5: Formatting a Report (Reporting Services)

課程 6:加入群組和總計 (Reporting Services)Lesson 6: Adding Grouping and Totals (Reporting Services)

另請參閱See also

Reporting Services 教學課程 有其他問題嗎?Reporting Services Tutorials More questions? 請嘗試詢問 Reporting Services 論壇Try asking the Reporting Services forum