Custom reports based on the image

Hi @t.santatriniaina

Thanks for sharing the image.

What you’re trying to build is possible in Gibbon, but it helps to think data preparation first, report design second. This can be done using Reporting Cycles in the Reports module, or by combining the Reports and Markbook modules. I’ve built several custom reports similar to this, so here’s a practical overview.


1. Subject / Module Setup (Most Important)

Before working on reports, make sure your academic structure is consistent.

Best practices:

  • Each subject (Marketing, Finance, Management, Law, Languages, etc.) should exist as a Course.

  • Within each course, create topics (Markbook columns), each of which should:

    • Be assigned a credit value

    • Be linked to the correct Term / Semester (e.g. Semester 2)

  • Ideally, map course classes to Form Groups for clean, predictable reporting.

Inconsistent course or class setup will make reporting much harder.


2. Grades & Comments

Your example shows one final grade per subject, plus credits and comments.

  • Use Markbook for assessments

  • Define one final calculated grade per subject:

    • A weighted Markbook column, or

    • A dedicated Final Grade assessment

  • Ensure grades are numeric and use a consistent scale (e.g. /20)

Subject comments can be added via:

  • Markbook comment fields, or

  • A custom assessment type for comments


3. Reporting Cycle

In Reporting Cycles:

  • Create a cycle such as Semester 2 – Academic Year 2024–2025

  • Link it to the correct School Year and Term

  • Enable grades and comments

  • Control visibility for students and parents

This tells Gibbon which data belongs to which semester.


4. Report Template Design

Using the Reports module:

  • Create a custom report

  • Group content by Courses

  • Loop through courses to display:

    • Markbook columns

    • Credits

    • Grades

  • Add calculations for:

    • Credits earned

    • Averages per group

    • Overall semester average and total credits

For PDFs:

  • Use tables

  • Control page breaks

  • Keep each subject block together

Your screenshot layout is very achievable with careful table structure.


5. Sharing Reports

Reports can be:

  • Generated in bulk

  • Exported as PDFs

  • Released by reporting cycle

  • Shared with students and/or parents using access controls


6. Examples

I’ve shared working examples and screenshots here:

Exploring what’s possible with the Reports module
https://ask.gibbonedu.org/t/exploring-what-s-possible-with-the-reports-module/15472


Let me know if you have any questions.

4 Likes