Jump to content
Sign in to follow this  
Matt_

Create a Matrix Report

Recommended Posts

I've got a Filemaker solution that I'm working on and I've run into some difficulty. I'm trying to create a timetable matrix report for a school information system - but it seems pretty difficult to do what I want.

The report will have columns representing each term, which are managed by adding/removing records in the tblTerm table.

The rows in each table are the individual periods that appear in the schedule, these are managed in the tblPeriod table.

The information that needs to be displayed in the rows/columns comes from tblCourseEnrolment, and contains information such as CourseCodes, CourseNames, CourseTeacher, CourseRoom, CourseTerm, etc.

The tricky part is that the number of terms and periods are variable, and that in the course enrollment varies between terms.

I've attached a PDF with a sample of what I'd like the end product to look like, with some notes and additional information.

I realize this is pretty demanding, if you have another suggestion on how to do something like this, or a different way to organize it, let me know :

Student_Schedule.pdf

Share this post


Link to post
Share on other sites

Here are two threads that could get you started:

http://fmforums.com/forum/showpost.php?post/209659/

http://fmforums.com/forum/showtopic.php?tid/176396/

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.