I have a question, i think it is very common; but, i dont know how to do. my project is like this. i have many school. each shcool have many teachers. they have score cards for their student. the scorecard from all school all teachers are in the same single format. so, i collected all the score cards, and stored in one single big database. (each scorecard, i appended two more column for teacher name and school name.) and i already created the dashboards and reports to do the statistics. So, the administrive can view the overall for all schools. now, i want to let the teacher, or school principle to use the same dashboards and reports, to view the data for their school/students. The problem is how to assign and set the premission. As my understanding, i can control the premission and roles setting for allow/disallow user to use some reports/dashboard/data sources. but, now, all my users are using SAME reports/dashboard and even SAME data sources. they just see different segments in the data base table.... i dont know what to do.... any suggestion?