SSRS 详细信息成员只能包含静态内部成员
我正在 SSRS 2008 中开发 RDL，并尝试将子报表直接移动到主报表中，以便我在与主报表相同的存储过程中运行此子报表。
但是，我在连接它时遇到了麻烦。我让存储过程成功运行。但现在，当我尝试将此表复制到主报告中时，出现以下错误：
[rsInvalidDetailDataGrouping] tablix“table1”有一个包含内部成员的详细信息成员。详细信息成员只能包含静态内部成员。
报表项表达式只能引用当前数据集范围内的字段，或者如果在聚合内，则引用指定的数据集范围内的字段
我该如何执行此操作？
我尝试将表移至组级别并删除详细信息分组。我已经删除了排序元素等。但是使此错误消失的唯一方法是删除此表和所有文本框值的所有分组。
I am developing an RDL in SSRS 2008 and am trying to move a subreport table directly into a main report so that I instead run this subreport in the same stored proc as my main report.
However, I'm having trouble hooking this up. I got the stored procedure to run successfully. But now when I try to copy this table into the main report I get the following error:
[rsInvalidDetailDataGrouping] The tablix 'table1' has a detail member with inner members. Detail members can only contain static inner members.
Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope
How can I do this?
I have tried moving the table into the group level and deleting the details grouping. I have removed sorting elements, etc. But the only way I got this error to disappear is to delete all of the groupings for this table and all textbox values.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果这些是从同一个 SP 返回的，那么您应该只有一个详细信息组（和一个 tablix）。
对于数据集返回的每一行，详细信息组（在外部 Tablix 上）将重复一次。同一数据集的该行中包含的 tablix 没有意义：它会重复什么？
听起来您需要将两个 Tablix 合并为一个，而不是将一个嵌套在另一个中。
最简单的方法可能是向父 Tablix 添加一个组，该组将取代以前的详细信息组。它可能会按您加入旧子报表数据集（或类似数据）的任何字段进行分组。
然后将旧子报表字段放入详细信息行中。
If these are being returned from the same SP, then you should only have one Detail group (and one tablix).
The detail group (on your outer tablix) will be repeated once for each row returned by your dataset. A tablix contained within that row for the same dataset doesn't make sense: what would it repeat?
It sounds like you need to combine your two tablixes into one, not nest one in the other.
The easiest approach is probably to add a group to the parent tablix which will take the place of the former detail group. It will probably group by whatever field you joined to your old subreport dataset (or something similar.)
Then put your old subreport fields in the detail rows.
我在 VS2015 SSRS14 中构建报告时遇到此错误。
重新启动 Visual Studio 清除了该错误。
I was getting this error when building a report in VS2015 SSRS14.
A restart of Visual studio cleared the error.
就我而言，一个简单的表格报告 Tablix4 给出了错误。这是因为 Tablix1 有一个 Rectangle 作为子项，而该 Rectangle 有 Tablix4 作为子项。将 Tablix1 替换为 Tablix4 解决了该问题。
In my case, a simple table report, Tablix4 was giving an error. This is because Tablix1 had a Rectangle as a child, and the Rectangle had Tablix4 as a child. Replacing Tablix1 with Tablix4 solved the problem.