Geek Answers Handbook

Using more than two entity relationships in Report Builder (SQL Server 2005)

I created a model using SQL Server Reporting Services. When I try to create a report using the report builder, I can drag an object into the report, followed by a nested sub-object. I get a two-level grouping as expected.

However, I cannot add a third-level object to the relation, no matter what combination I try to perform.

What can I do to enable multi-level entity relationships in Report Builder?

+3
source share
1 answer

I had a lot of time to play here. I did not find a way to use standard role relationships. Instead, I created a named query that joins multiple tables. Then I create folders in the model for each column, depending on which table they come from. This mimics, more or less, the effect of having multiple objects.

I find that using both table wizards and tablix flexible groups in Report Builder 2.0 works very well.

+1
source

More articles:


All Articles