Building Custom Reports

If the standard DepEd reports do not have what you need, you can build your own.

1. Click Report Builder in the sidebar menu.
2. Choose a data source:
   • Circulation -- borrowing and return transactions
   • Items -- books and other materials in your collection
   • Fines -- fine records
   • Patrons -- student and staff records
3. Select the columns you want in your report. You can choose from the item's own fields or related information (like the borrower's name for a circulation report).
4. Add filters to narrow down the data:
   • Click Add Filter
   • Choose a column, a comparison (equals, greater than, contains, etc.), and a value
5. Click Preview to see the first 100 rows.
6. If it looks good, click Export CSV to download up to 10,000 rows.
7. To save this report for later, type a name and click Save. Your saved reports appear in the sidebar.

If something goes wrong:

• No data in preview -- Your filters may be too strict. Try removing filters one by one to find which one is excluding all data.
• Too much data -- The export is limited to 10,000 rows. Add filters to narrow your results.