I've created a model using SQL Server Reporting Services. When I try to create a report using the Report Builder, I can drag an entity to the report, followed by a nested sub-entity. I get the two-level grouping as expected.
我使用SQL Server Reporting Services创建了一个模型。当我尝试使用报表生成器创建报表时,我可以将实体拖到报表中,然后是嵌套的子实体。我按预期得到了两级分组。
However, I cannot add a third level entity to the relationship, no matter which combination I try.
但是,无论我尝试哪种组合,我都无法在关系中添加第三级实体。
What can I do to enable multi level entity relationships in Report Builder?
如何在报表生成器中启用多级实体关系?
1 个解决方案
#1
1
I've had lots of time to play here. I haven't found a way using standard role relationships. Instead, I created a named query that joins multiple tables together. I then create folders in the model for each column, depending on from which table they originate. This mimics, more or less, the effect of having multiple entities.
我有很多时间在这里玩。我还没有找到使用标准角色关系的方法。相反,我创建了一个将多个表连接在一起的命名查询。然后,我在模型中为每列创建文件夹,具体取决于它们来自哪个表。这或多或少地模仿了具有多个实体的效果。
I find that this, and using the table wizards and flexible tablix groupings in Report Builder 2.0 work pretty well.
我发现这一点,并使用Report Builder 2.0中的表向导和灵活的tablix分组工作得很好。
#1
1
I've had lots of time to play here. I haven't found a way using standard role relationships. Instead, I created a named query that joins multiple tables together. I then create folders in the model for each column, depending on from which table they originate. This mimics, more or less, the effect of having multiple entities.
我有很多时间在这里玩。我还没有找到使用标准角色关系的方法。相反,我创建了一个将多个表连接在一起的命名查询。然后,我在模型中为每列创建文件夹,具体取决于它们来自哪个表。这或多或少地模仿了具有多个实体的效果。
I find that this, and using the table wizards and flexible tablix groupings in Report Builder 2.0 work pretty well.
我发现这一点,并使用Report Builder 2.0中的表向导和灵活的tablix分组工作得很好。