I have a solution for you. I will display the sample report and then explain how it works.
1. I have two lookup tables: District_Lookup, School_Lookup
You would make these part of your Data process. If a district or school name changes then you update these tables.
2. My report data is called "District_School_Enrollment". It only contains id's.
3. All 3 tables are imported into CAS. You will need to create a Join between District_School_Enrollment to the other two lookup tables so you can get District Name and School Name.
First Join to get the District Name
2nd join to get the School Name. The resulting table is called "Data_Join(1). That will be the table we create the report off of.
4. After you have this setup, you can now build your entire report off of Data_Join (1). If you want to add List prompts going against the lookup tables are most efficient. If you do that, you simply need to MAP the tables. District Lookup --> Data_Join(1). School_Lookup --> Data_Join(1).
:
... View more