September 19, 2011 at 2:10 am
Hi,
I am trying to create a report model using 5 tables of which one is the primary table and the other 4 are linked to it through a primary key. The problem I am facing is that when I try to build a report in the report builder using the this report model, it does not allow me to drag and drop the fields from the other tables other than the primary table.
I will try to explain fully what happens when I try to build a report:
The 5 tables are:
TB OFFICE (Primary table)
TB OFFICE ADDRESS
TB OFFICE EMAIL
TB OFFICE FAX
TB OFFICE PHONE
When I click on say TB OFFICE FAX for example in the report builder, then I can drag and drop the fields from it as with TB OFFICE. But then the TB OFFICE FAX table comes up right up on the top and the other 4 tables come right underneath it and then I cannot drag and drop the fields from the 3 tables:
TB OFFICE ADDRESS
TB OFFICE EMAIL
TB OFFICE PHONE
Could someone please help me in this regard ? I have tried different things but its not helping at all.
Regards,
Paul
September 20, 2011 at 2:07 am
Could anyone please help me, I am still stuck on this ?
September 20, 2011 at 6:28 am
It sounds like you need to check the detail level and relationships in the model. Also check to see if you can drill down from the fact table; I know that is counter intutitve.
September 21, 2011 at 2:11 am
What you have discovered is true. In the DSV, try to create a single Named Query in which the tables are joined. It is the equivalent of a database table view. You can specify outer joins. Alternatively create subqueries in the Named Query for each column in the related tables. There is copy and paste so that would not take too long!
MWN
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply