问题描述
我能够使用信息(将每个子报表放置在Rectangle控件中，并将其PageBreak属性设置为开始"). >
我希望设置矩形的 PageName 属性可以将工作表名称设置为我在其中分配的名称，但不能-它们只是" Sheet 2 "，"第3页"等
那么如何为工作表名称分配一个特定的值，以便在将SSRS报告及其子报告导出到Excel时使用这些值?
更新
尝试汉诺威拳的建议，我设置了矩形的PageName属性:
...但是该文件仍使用通用工作表名称创建:
在我的报告中，我在行组"窗口中选择了tablix组，并设置了该组的组">"PageName"属性(甚至可以使用数据集字段命名).我成功了.
在您的情况下，是否可以创建一个Tablix并执行相同的操作，将子报表插入到此主Tablix中?可能有用.
I am able to have a report with multiple subreports export to Excel with each subreport on a separate tab/sheet using the info here (placing each subreport within a Rectangle control and setting its PageBreak property to "Start").
I hoped that setting the Rectangles' PageName property would set the sheet names to what I assign there, but no - they are simply "Sheet 2", "Sheet 3", etc.
So how can I assign a specific value to the sheet names so that those values are used when the SSRS report with its subreports is exported to Excel?
UPDATE
Trying Hannover Fist's suggestion, I set the Rectangles' PageName property:
...but the file is still created with generic sheet names:
On My report, I selected the tablix group on Row Groups window, and I set the Group > PageName property of the group (I could even use a dataset field to name it). I succeeded on that.
In your case, is it possible to create a tablix and do the same, inserting the subreport into this main tablix? It might work.
这篇关于将SSRS报表导出到Excel时，如何分配工作表名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！