Using More than 2 Entity Relationships in Report Builder (SQL Server 2005)

views:

553

answers:

+3 Q:

Using More than 2 Entity Relationships in Report Builder (SQL Server 2005)

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.

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 A:

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.

Scott 2008-12-23 07:21:39

I've received some feedback from Microsoft regarding this. Apparently, using a "flat" query is the way around this. Still, I find myself creating a very large, complex query which is starting to put a heavy load on the server. I'm still open to ideas.

Scott 2009-02-26 02:40:55

I am having the same issue... I cannot add more then 2 entities, any help would be greatly appreciated.

Mario 2009-11-06 21:05:07

Mate, it simply cannot be done. Your best bet is to create a model which is based on a single query that joins several tables together and then do group in Report Builder. This is inefficient, but will get the job done.

Scott 2009-11-16 01:34:10

ansaurus

tags:

views:

answers:

Using More than 2 Entity Relationships in Report Builder (SQL Server 2005)

related questions