Jump to content
Sign in to follow this  

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 :


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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