Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Reporting Services

Model for Report Builder

I made a model for report builder and I am limited to selecting from 2 tables I have one main tabletable1 with a PK to FK withtable2 - table12.I am limited to only going 2 levels deep is this right? How can I correct this or work around it. I tried building a view, but have never had to do so with so many joins it this possible or do I have to break things up?
[391 byte] By [RayClark096] at [2007-12-24]
«« Saving Information
»» Command Line arguments make me say arrg
# 1

I'm not sure I understand the limitation you are hitting. Are you seeing problems during model design or in Report Builder after you publish the model?

BobMeyersMSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
I have one main table with PK and several tables with a FK to the main table. After building my model I am limited to select only from the main table and one other table, the ths most I can grab from is 2 tables.
RayClark096 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

I'm not aware of any existing issues like this. Here's a few things you could double check:

- The entities in the model that correspond to the "other" tables all have IsLookup=false and Hidden=false

- The roles in the model from the main entity to the "other" entities all have Cardinality=OptionalMany

- I assume you are using Model Designer to build the model against a SQL database, not generating the model from an Analysis Services cube.

BobMeyersMSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
SQL Server
SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified