使用 Reporting Services 2008 R2 重命名 Excel 工作表
我有 2 个 tablix.我在第一个 tablix 之后输入了一个分页符,以便表格显示在两张纸上.但是,每个工作表都被命名为 Sheet1 和 Sheet2.如何通过 Reporting Services 应用程序自动为其指定唯一名称?
I have 2 tablix's. I have entered a page break after the first tablix so that the tables show up on two sheets. However, each sheet is named Sheet1 and Sheet2. How do I give it its own unique name automatically through the reporting services application?
导出到 Excel 时,可以使用 Report -> InitialPageName 属性设置第一个工作表名称:
When exporting to Excel, you can set the first sheet name with the Report -> InitialPageName property:
更多工作表由分页符触发,在 SSRS 2008R2 及更高版本中,您可以使用 PageName 属性命名工作表.这可以设置在可以触发分页符的各个位置,例如一个 Tablix:
Further sheets are triggered by page breaks, and in SSRS 2008R2 and above you can name sheets using the PageName property. This can be set in various locations where page breaks can be triggered, e.g. a Tablix:
或者 tablix 中的一个组,在组实例之间有分页符;在这里,您可以使用报表中的字段使其基于表达式:
Or a group within a tablix that has page breaks between group instances; here you might make it expression-based with a field in the report:
有关详细信息,请参阅工作表标签名称.
See Worksheet Tab Names for more information.