Help Center
 ›
Create a report

Create a report

Build exactly the view you need, in four steps

Create a report

A report answers a question about your data — which opportunities close this quarter, which tickets are still open, which accounts you haven't spoken to. You build one by picking what to report on, choosing the columns you care about, narrowing the rows with filters, and setting the order. Nothing is fixed: every choice can be changed later, and you see your real data update as you go.

How it works

Reports are built in four steps — Columns, Filters, Sorting and Preview — after you choose a starting point. A progress bar across the top shows where you are, and you can go back to any earlier step without losing your work.

Underneath every step is a live preview of your actual records. Add a column and it appears; add a filter and the rows narrow immediately. You're never guessing what the finished report will look like.

Nothing is saved until you choose to save it, so you can explore freely. Once saved, a report can be run again any time, exported, edited, and shared with the people who need it.

Choose what to report on

  1. Select Reports in the left sidebar, then Create a new report.
  2. Pick the kind of record your report is about: Accounts, Contacts, Tickets, Leads, Opportunities or Documents.
The Create a New Report screen showing six data source cards to choose from — Accounts, Contacts, Tickets, Leads, Opportunities and Documents — each with a short description of what it covers.

This choice sets what each row of the report represents. A report started from Opportunities gives you one row per opportunity; one started from Tickets gives you one row per ticket.

Choose your columns

Columns are what you see across the report. Pick as many or as few as you like.

  1. Type a name for your report over the placeholder at the top of the page. You can change it later.
  2. Select the plus button beside any column in Columns to choose from to add it.
  3. Drag the handle beside a selected column to change the order columns appear in.
  4. Select the minus button to take a column back out.
  5. Select Next step when you're happy with the shape of it.
Step 1 of the report builder, Columns. The left panel lists available columns each with a plus button; the right panel shows six selected columns — Name, Status, One Time Value, Expected Close Date, Decision Maker Identified and Assigned To — each with a drag handle. A live preview of the data appears below.

The list of available columns is wider than it first looks. Alongside the standard details, it includes any custom fields your organization has added for that record type — so anything you've chosen to track shows up here automatically. It also includes details pulled from related records, such as the account an opportunity belongs to or the person it's assigned to. Columns that come from a related record are labeled with where they come from.

Narrow it down with filters

Filters decide which rows make it into the report. Without any, you get everything.

  1. Select Add a filter.
  2. Choose the field to filter on.
  3. Choose how to compare it — the options change to suit the field.
  4. Enter or pick the value. For fields with a fixed set of choices, start typing and select as many values as you want; each becomes a removable chip.
  5. Select + Add another filter to keep narrowing. Filters stack, so a row has to satisfy all of them.
  6. Select Continue, or Skip if you don't need any filters.
Step 2 of the report builder, Filters. A single filter row reads Status, Is any of, with three chips for Qualified, Proposal and Negotiation. The preview below has narrowed to only opportunities in those three statuses.

What you can compare depends on the kind of field:

  • Fields with set choices, such as a status or an assigned teammate: Is any of, Is none of, Is empty, Is not empty.
  • Text: Equals, Not equals, Contains, Does not contain.
  • Numbers and amounts: Equals, Not equals, Greater than or equal, Less than or equal.
  • Dates: Equals, On or after, On or before, Between, or Relative — a moving window such as Today, Last 7 days, Last 30 days, This month, Last month, This quarter or This year.
  • Checkboxes: Equals, Not equals, Is empty, Is not empty.

A relative date filter is worth knowing about: a report filtered to "Last 30 days" always covers the 30 days up to whenever you run it, so it stays current without you editing it.

Set the order

  1. Select Add a sorting rule.
  2. Choose a column and pick Ascending or Descending.
  3. Select + Add another sorting rule to sort within the sort. Rules apply top to bottom: the second rule only breaks ties in the first.
  4. Select Go to preview, or Skip and go to preview.
Step 3 of the report builder, Sorting. Two rules are set: Expected Close Date ascending, then One Time Value descending. The preview below is ordered by close date, with opportunities sharing a date ordered by value.

You can only sort by columns you've already selected, so if a column you want to order by is missing, step back to Columns and add it.

Preview and save

The last step shows the finished report with a summary of what you built — the record type, and how many columns, filters and sorting rules it uses.

  1. Check the results. If something looks wrong, step back and adjust; your work is kept.
  2. Select Save this report.
  3. Confirm the name and add a description if it helps others understand what the report is for.
  4. Select Save Report.
Step 4 of the report builder, Preview. A summary bar reads Opportunities, 6 columns, 1 filters, 2 sorting rules, above the finished table of results. The Save this report menu is open with fields for report name and an optional description.

You don't have to save to get the data out — Export on this same step downloads what you're looking at. Saving is what lets you come back to it, run it again later, and share it.

Once saved, the report gets its own page with Run report to refresh the results, Edit report to reopen the builder at any step, and export options for CSV, Excel and PDF.

Share it with your team

A report you create is yours until you share it. Sharing is per person, so you decide exactly who sees it.

  1. Open the report and go to its share page.
  2. Select a team member.
  3. Choose Can View or Can View & Edit.
  4. Select Add another team member to include more people at once.
  5. Select Share a report. Everyone you add gets an email letting them know.
The Share Report page for a report called Open Opportunities by Close Date, with a team member picker set to Can View, and a Shared With list showing Carter Burke with Can View and Dallas Arthur with Can View and Edit, each with a Remove link.

Everyone you've shared with is listed under Shared with, along with the access you gave them. Select Remove beside a name to take their access away again.

Good to know

  • Your report only ever shows records from your own organization, and only people in your organization can be given access to it.
  • Can View lets someone open and run the report. Can View & Edit also lets them change how it's built. Only you and people with edit access can change or delete it.
  • You can't share a report with yourself, and a person can only be added once — change their access rather than adding them again.
  • The preview while you're building shows up to 50 rows so it stays quick. Saved reports page through the full set of results when you run them.
  • A saved report is a set of instructions, not a snapshot. Every run reads your data as it stands right then, so results change as your records do.
  • Exports of more than 5,000 rows are prepared in the background and emailed to you instead of downloading straight away.
  • There's a ceiling on how often reports can run — 10 times a minute and 100 times an hour per person — so a report that's already running is worth waiting for rather than re-running.
  • Deleting a report removes it for everyone it was shared with.

Still need help? Email us at support@heycustomer.com

Related articles

No items found.
report, reports, create a report, build a report, report builder, custom report, columns, choose fields, select fields, filter, filters, filtering, sort, sorting, order results, save report, share report, share with team, export report, CSV, Excel, PDF, data source, opportunities report, tickets report, leads report, accounts report, contacts report, documents report, custom fields in reports, relative date