reporting-services - 是否有必要构建/编译 SSRS 报告？

Question

我们有一个 2008 R2 native 安装的 SSRS。我通常在一个大型 Visual Studio 报表服务器项目中开发报表，并通过 SSRS 网站的前端手动上传 .rdl 文件。但是，我注意到您可以构建 .rdl 文件的调试/发布版本。到目前为止，我注意到的唯一区别是编译后的 .rdl 比“原始”.rdl 大 2KB - 没有注意到性能提升等。

有人知道使用原始 .rdl 和编译的 .rdl 之间的区别吗？

Answer 1

Visual Studio 中没有原始与编译的 rdl。

混淆来自 Visual Studio 中的其他项目类型，因为每个 .NET 开发人员都知道，如果使用或不使用“优化代码”复选框进行编译，dll/exe 之间存在差异。

即使术语“构建”出现在 SSRS 文档中，也更容易认为 RDL 报告不是构建的(至少不是在部署之前)，因为构建报告与构建 .NET 应用程序完全不同。

Reports are built before they are published to ensure that only valid report definitions are published to the report server. Project configurations include properties for building reports, such as the folder in which to temporarily store the built reports, and how to handle build issues. The configurations also have properties that you use to specify the location and version of the report server, the folders on the report server.

来源: Publishing Reports to a Report Server

在这里，built 应该被视为有效性检查。
编辑 2017-10-25 :但不仅如此，请参阅 comment下面来自迈克尔·伊登菲尔德。

什么时候编制报告？

当您查看报告时。

Stages of Report Processing

When you create a report, you define a report definition file (.rdl) in XML format. This file contains all the information that is needed to combine report data and report layout by the report processor. When you view a report, the report progresses through the following stages:

• Compile. Evaluate expressions in the report definition and store the compiled intermediate format internally on the report server.

• Process. Run dataset queries, and combine intermediate format with data and layout.

• Render. Send processed report to a rendering extension to determine how much information fits on each page and create the paged report.

• Export (optional). Export the report to a different file format.

来源: Reporting Services Reports (SSRS)

下图显示了报告处理的概览:

Compiled report and intermediate report format

The report that uses evaluated expressions, parameters and parameter properties evaluated.

来源: Reporting Services Concepts (SSRS)

调试/发布配置用于什么？

在解决方案/项目配置中，您可以存储部署设置，例如目标服务器 URL、报表路径等。
您可以使用标准的，例如使用 Debug 将报告发布到测试 SSRS 服务器，使用 Release 将报告发布到生产 SSRS 服务器。

SQL Server Data Tools (SSDT) provides project configurations for managing report publication. The configuration specifies the location of the report server, the version of SQL Server Reporting Services installed on the report server, whether the data sources published to the report server are overwritten and so forth. In addition to using the configurations that SQL Server Data Tools (SSDT) provides, you can create additional configurations.