Build CRM Reports Without Writing a Single Line of SQL

The Problem Every Perfex CRM Team Faces

Your CRM is full of valuable data — clients, invoices, payments, projects, tasks, leads, proposals, contracts. But that data lives in separate tables, disconnected from each other.

When your manager asks "Which sales agent generated the most revenue this quarter?", the answer requires joining three tables, writing SQL, and exporting to Excel. That means calling a developer, waiting hours or days, and hoping the query is correct.

This is the reporting bottleneck. Every new question requires a new custom query. Business teams depend on developers for basic operational visibility.

What If Business Teams Could Build Their Own Reports?

Data Builder for Perfex CRM eliminates the SQL dependency entirely. It provides a visual drag-and-drop builder that lets anyone — not just developers — create sophisticated cross-module reports in minutes.

Here's how it works:

1. Search and select tables — Find any CRM table by display name, system name, or short name. Works with core Perfex tables and third-party module tables (HRM, Warehouse, POS, Booking, etc.).

1. Auto-detect joins — The engine scans foreign keys and naming conventions to automatically suggest how tables connect. No need to know SQL JOIN syntax.

1. Drag fields to the canvas — Pick exactly which columns you want. Rename them with user-friendly aliases. Combine multiple columns into concatenated fields (e.g., First Name + Last Name).

1. Set filters and aggregations — Use visual filter UI with operators like BETWEEN, IS NULL, IN, LIKE. Add SUM, COUNT, AVG aggregations with GROUP BY. Apply HAVING clauses — all without writing code.

1. Preview instantly — Click "Run Preview" to see live results before saving. Adjust and iterate in real-time.

1. Save and share — Save as a runtime view accessible at a clean URL. Control who sees it with Public, Private, or Shared scopes.

Templates: Don't Start From Scratch

Data Builder includes pre-built report templates for common business needs:

• Daily Sales by Invoice Item
• Monthly / Quarterly / Half-Year Sales Reports
• Custom templates you create and save for reuse

Templates support Dynamic Date Macros like {{CURDATE}}, {{CURDATE-7}}, {{CURYEAR_Q1}} — so your "This Week's Sales" report always shows current data without manual date changes.

Advanced Query Power, Zero SQL Knowledge

Behind the visual interface, Data Builder generates optimized SQL queries using CodeIgniter's Query Builder (preventing SQL injection). You get enterprise-grade query capabilities:

• Complex WHERE/HAVING/GROUP BY logic
• Advanced operators: BETWEEN, IS NULL, IS NOT NULL, IN, LIKE
• Aggregations: SUM, COUNT, AVG, MIN, MAX
• Total/Summary footer rows in reports
• Sorting by multiple columns with direction control
• Default filters that auto-apply when viewing reports

From Data Tables to Business Decisions

This isn't about making charts. It's about giving business teams direct access to the intelligence locked inside their CRM — without creating developer dependencies.

Build once. Share with your team. Update automatically. That's operational reporting done right.

Get Started

Data Builder works as a module for Perfex CRM 3.0.0+. Install, whitelist your tables, and build your first report in under 5 minutes.

No code. No waiting. No bottleneck.

---

Data Builder for Perfex CRM — The low-code data platform that turns raw CRM tables into business intelligence.