Drill Through Using Data From More Than One Table

[jglasgow]

Hello,

I am working with educational data and have a report with data from many tables (enrollment, attendance, course grades, GPA...etc.).   All of these tables share a "Student ID" column.  My goal (and where I'm currently stuck) is being able to pull data from multiple tables on a student level drill through page.    

My thought was that since "Student ID" existed in all tables that it would work, but I can only get it to pull data from one table at a time on drill through.   

I have seen some similar questions to this, but not this exactly.   Any help is greatly appreciated!

Jake G.   

[MarkPalmberg]

I have this same question. One table for all the distinct household ID values from my database, then "fact" tables with multiple instances of the household for stuff like geo information, assigned staff role, etc.  I'd like to get a count of households by, e.g. Combined Statistical Area for a selected FUNDRAISERSORTNAME value. Do I just need to flatten all this?

[jglasgow · Accepted solution]

I was able to get this to work by adjusting the relationships between my tables.   

[jglasgow]

@MarkPalmberg Exactly! 

For my project, the ability to have high level reports on all the education topics I mentioned above with the ability to drill through to a single student page that contains data from each topic/table is critical.   I'm hoping for a solution or workaround.