快速入門︰建立 Power BI 報表伺服器的編頁報表Quickstart: Create a paginated report for Power BI Report Server

正如其名,編頁報表可以執行至許多頁面。As the name suggests, paginated reports can run to many pages. 其配置使用固定的格式,且提供精確的自訂項目。They're laid out in a fixed format and offer precise customization. 編頁報表為 .rdl 檔案。Paginated reports are .rdl files.

您可以在 Power BI 報表伺服器入口網站中儲存及管理編頁報表,就如同您在 SQL Server Reporting Services (SSRS) 入口網站一樣。You can store and manage paginated reports in the Power BI Report Server web portal, just as you can in the SQL Server Reporting Services (SSRS) web portal. 在 SQL Server Data Tools (SSDT) 的報表產生器或報表設計師中建立和編輯,然後將其發行至其中一個入口網站。You create and edit them in Report Builder or Report Designer in SQL Server Data Tools (SSDT), then publish them to either web portal. 接著貴組織的報表讀者可在瀏覽器,或其行動裝置上的 Power BI 行動裝置應用程式中加以檢視。Then report readers in your organization can view them in a browser or in a Power BI mobile app on their mobile device.

Power BI 報表伺服器編頁報表

如果您已在報表產生器或報表設計師中建立編頁報表,就可建立 Power BI 報表伺服器的編頁報表。If you've already created paginated reports in Report Builder or Report Designer, then you're ready to create paginated reports for Power BI Report Server. 若否,以下是一些快速入門步驟。If not, here are some quick steps to get you started.

步驟 1︰安裝並啟動報表產生器Step 1: Install and start Report Builder

您可能已安裝報表產生器,可建立 SSRS 伺服器的報表。You may already have installed Report Builder to create reports for an SSRS server. 您可以使用相同版本或報表產生器來建立 Power BI 報表伺服器的報表。You can use the same version or Report Builder to create reports for Power BI Report Server. 如果您尚未安裝,此程序很簡單。If you haven't installed it, the process is easy.

  1. 在 Power BI 報表伺服器入口網站中,選取 [新增] > [編頁報表]。In the Power BI Report Server web portal, select New > Paginated Report.

    [新增編頁報表] 功能表

    如果您尚未安裝報表產生器,其現在會引導您完成安裝程序。If you don't have Report Builder installed already, it leads you through the installation process now.

  2. 安裝完畢後,報表產生器會開啟到 [新報表或資料集] 畫面。After it's installed, Report Builder opens to the New Report or Dataset screen.

    [新報表或資料集] 畫面

  3. 選取您想要建立之報表類型的精靈︰Select the wizard for the kind of report you want to create:

    • 資料表或矩陣Table or matrix
    • 圖表Chart
    • 地圖Map
    • 空白Blank
  4. 讓我們以 [圖表精靈] 作為起始。Let's start with the Chart wizard.

    [圖表精靈] 會指引您在報表中建立基本圖表的步驟。The Chart wizard walks you the steps of creating a basic chart in a report. 您可於該處以近乎無限多種的方式自訂您的報表。From there, you can customize your report in almost unlimited ways.

步驟 2︰執行 [圖表精靈]Step 2: Go through the Chart wizard

[圖表精靈] 會指引您在報表中建立視覺效果的基本步驟。The Chart wizard walks you through the basic steps of creating a visualization in a report.

編頁報表可連接至各種資料來源,包括 Microsoft SQL Server 和 Microsoft Azure SQL Database,以及 Oracle 和 Hyperion 等等。Paginated reports can connect to a wide variety of data sources, from Microsoft SQL Server and Microsoft Azure SQL Database to Oracle, Hyperion, and many more. 了解編頁報表支援的資料來源Read about data sources supported by paginated reports.

在 [圖表精靈] 的第一頁 [選擇資料集] 中,您可以建立資料集,或選擇伺服器上的共用資料集。In the first page in the Chart wizard, Choose a dataset, you can create a dataset or choose a shared dataset on a server. 「資料集」會從外部資料來源的查詢傳回報表資料。Datasets return report data from a query on an external data source.

  1. 選取 [瀏覽] > 選取伺服器上的共用資料集 > [開啟] > [下一步]。Select Browse > select a shared dataset on a server > Open > Next.

    圖表精靈:選擇資料集

    需要建立資料集嗎?Need to create a dataset? 請參閱建立共用或內嵌資料集See Create a shared or embedded dataset.

  2. 選擇圖表類型,在此情況下為橫條圖。Choose a chart type -- in this case, a bar chart.

    圖表精靈:圖表類型

  3. 將欄位拖放至 [類別][系列] 及 [值] 方塊來加以排列。Arrange the fields by dragging them to the Categories, Series, and Values boxes.

    圖表精靈:排列欄位

  4. 選取 [下一步] > [完成]。Select Next > Finish.

步驟 3︰設計報表Step 3: Design your report

現在您已在 [報表設計] 檢視中。Now you're in Report Design view. 請注意,資料為預留位置資料,而不是您的資料。Notice the data is placeholder data, not your data.

[報表設計] 檢視

  • 若要檢視您的資料,請選取 [執行]。To view your data, select Run.

    執行報表

  • 若要返回 [設計] 檢視,請選取 [設計]。To go back to Design view, select Design.

您可以修改剛剛建立的圖表,變更其配置、值、圖例等近乎所有項目。You can modify the chart you just created, changing the layout, values, legend... really just about anything.

您也可以新增各種其他視覺效果︰量測計、資料表、矩陣、表格、地圖等等。And you can add all sorts of other visualizations: gauges, tables, matrixes, tables, maps, and more. 您可以新增多個頁面的頁首和頁尾。You can add headers and footers for multiple pages. 請參閱報表產生器教學課程自行嘗試。See the Report Builder tutorials to try them for yourself.

報表產生器設計檢視

步驟 4︰將報表儲存至報表伺服器Step 4: Save your report to the report server

當您的報表就緒時,將其儲存到 Power BI 報表伺服器。When your report is ready, save it to Power BI Report Server.

  1. 在 [檔案] 功能表上,選取 [另存新檔],並將其儲存到報表伺服器。On the File menu, select Save as, and save it to the report server.
  2. 現在您可以在瀏覽器中加以檢視。Now you can view it in the browser.

    瀏覽器中的編頁報表

後續步驟Next steps

您有許多絕佳的資源可用,讓您設計報表設計師和 SQL Server Data Tools 的報表產生器中的報表。There are many great resources for designing reports in Report Builder and in Report Designer in SQL Server Data Tools. 報表產生器教學課程是不錯的起點。The Report Builder tutorials are a good place to start.

有其他問題嗎?More questions? 嘗試在 Power BI 社群提問Try asking the Power BI Community