Answer your own questions about your business.
Stop waiting on a custom report. Query Builder lets you pick the fields you want, filter and total them, and see the answer in seconds, with no SQL to write. Save it, share it with your team or have it emailed on a schedule.
From question to answer. No ticket, no wait.
The canned reports cover the basics. Query Builder covers everything else: the one-off question from the owner, the list your accountant wants, the number you check every Monday.
Pick your data
Start from a subject area like sales, inventory or customers. Fields show up with plain business names, not database jargon.
Choose your fields
Search the field list and click to add columns. Related data is linked for you behind the scenes.
Filter and total
Narrow it to the rows you care about, then group and total with sums, counts and averages.
Run, save and share
Preview the results, download them, save the report for your team or put it on an emailed schedule.
The report you need, built the way you think.
Everything a spreadsheet power user would want, without exporting five reports and stitching them together.
Curated data areas
Pick a DataVerse and its fields are grouped and labeled the way your shop talks, so the right field is easy to find.
Automatic joins
Pull customer, vehicle, invoice and product fields into one report. Hoops links the data for you and warns when it can't.
Powerful filters
Equals, contains, in a list, ranges and blanks, nested in AND / OR groups. Fixed-value fields get a friendly dropdown.
Relative dates
Today, last week, this month, last 90 days. Saved reports always show the current period, never a stale date range.
Run-time prompts
Leave a filter open and the report asks for the value each time it runs. One report, every location or customer.
Summarize and total
Count, distinct count, sum, average, minimum and maximum, grouped automatically. Filter on the totals too.
Formula columns
Add calculated columns like quantity × cost, IF logic, text clean-up, or year, quarter, month and week from any date.
Save and share
Keep reports private or share them with your team, organized by category. Anyone can save a copy and make it their own.
Download in seconds
Preview up to 1,000 rows on screen, then download up to 10,000 rows as CSV, ready for a spreadsheet, or JSON.
Just ask. Hank builds the report.
Type your question in plain English. Hank, the Hoops AI assistant, picks the fields, filters and totals and lays the report out in the builder. You check it, tweak it if you like, and run it.
It works from field names and labels only, never your customers or your numbers.
Hank drafts the report and you review it. Nothing runs until you say so.
Set it once. It lands in your inbox.
Put any saved report on a schedule and Hoops emails the results to you and your team, every hour, every morning or the first of every month. No one has to remember to run it.
- Hourly, daily, weekdays, weekly, monthly, or up to six set times a day
- Send to up to five recipients, as a CSV or JSON attachment
- Relative dates roll forward, so “last week” is always last week
- Skip the email when there's nothing to report
- Send now, pause, resume, and see every run's history
Open to your team. Safe for your data.
Read-only by design
Reports read your data and never change it. There's no way to edit, delete or overwrite a record from Query Builder.
No SQL to write
You build with clicks, not code, and every field is checked against an approved list. Power users can still peek at the generated SQL.
Totals you can trust
Query Builder warns you before related data would double-count your totals, so the number on the report is the real number.
Permission-based access
You decide who can build reports and who can schedule them. Your company's data is tied to your Hoops login.
Fast, with limits built in
Every report has a time limit and a row cap, so one oversized question can't run away with the system.
Friendly field names
Fields are curated and labeled in plain business terms, and hidden fields stay hidden, even in scheduled reports.
Your data, your questions, your answers.
Query Builder is an add-on for Hoops & Gears. Talk to us about turning it on for your shop and see it run on your own numbers.