问题描述
我有一个报告，其中包含多个 tablix.报告运行后，使用它的团队会将其导出到 Excel 中.
I have a single report which includes several tablixes. Once the report is run, it is exported into Excel by the team using it.
对于我点击进入其属性的每个 tablix 并勾选在之后添加分页符
For each tablix I clicked into its properties and ticked Add a page break after
这样做可确保将报表导出到 Excel 时，每个 tablix 的数据都显示在单独的工作表上.
doing this ensures that when the report is exported to Excel each tablix's data appears on a separate worksheet.
但是，当导出发生时，工作表被命名为工作表 1"、工作表 2"等
However when the export takes place the worksheets are named 'sheet 1', 'sheet 2' etc
理想情况下，我希望 Excel 中的单独工作表能够反映 tablix 的名称，例如上周"、本周"等.或者能够自己命名工作表.
Ideally I'd like the separate worksheets in Excel to reflect the name of the tablix, e.g. 'last week', 'this week' etc etc. Or to be able to name the worksheets myself.
有人知道可以这样做的方法吗?
Is anyone aware of a way this can be done?
谢谢.
推荐答案
我通过将 tablix 放入一个矩形中来实现这一点，该矩形在常规设置部分有一个页面名称"选项，这就是过去的在 Excel 中创建导出的工作表名称.
I have gotten this to work by placing the tablix into a rectangle, which has a "Page Name" option in the general settings section, this is what's used to create the exported worksheet name in Excel.
这篇关于将 SSRS 报告导出到 Excel 后命名工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！