Home/Reports & Analytics/Custom Report Builder

Custom Report Builder

Build a report without SQL · pick a curated source, columns, filters, grouping & sort · preview, then save
🛡️
This builder compiles to a parameterised query against whitelisted sources/columns — no raw SQL is ever exposed or run. The school_id tenant predicate and your RBAC field-mask are always injected server-side. A definition saved by an admin will not leak restricted fields when re-run by a lower-privileged viewer.

1Data Source

whitelisted-only
📝 Marks — Termselected
agg_marks_term · class, section, subject, marks, grade
📅 Attendanceavailable
agg_attendance_daily · present, absent, %
💰 Fees🔒 no permission
Requires fee.read — not selectable for your role

2Columns

5 of 6 selected

3Filters

whitelisted operators
Only whitelisted operators (=, ≠, in, >=, <=, between) are offered — values are bound as parameters, never concatenated.

4Group & Sort

Grouping & sort columns must be selected columns from Step 2.

Preview

sample · 24 rows · Grade 10 · Term 2
StudentClassSubjectMarksGrade
▸ Section A
Ananya Iyer10-AMathematics96A1
Sara Ali10-AMathematics91A1
Ishita Reddy10-AMathematics88A2
Kabir Khan10-AMathematics61C1
▸ Section B
Vivaan Gupta10-BMathematics84A2
Arjun Nair10-BMathematics72B1
Meera Joshi10-BMathematics39D
Preview capped at 24 rows · run full report after saving · 1 student below pass mark (33) flagged