Skip to main content
Reports is a builder for the exports your organisation runs again and again. You pick what the report is about, tick the columns you want, add filters, watch the table fill in beside you, and download a CSV. Nothing is typed as a query and nothing is capped at a page: the file holds every row that matched. This page is about Reports only. If you want to type a question and get a one-off answer on screen, or read the built-in dashboards, that is a different screen: see Insights & Ask Orgo. The two are compared below. Built for admins who need the same extract every month, or a one-off list with exactly the columns a colleague, an auditor or a funder asked for. Replaces exporting the member directory a page at a time, stitching several spreadsheets together, and asking a developer for a data pull.

Where to find it

The Reports screen before any report exists, showing the heading Reports, a New report button, and an empty state reading No reports yet with the line Build a custom spreadsheet from your members, payments, events and more, above a Create your first report button There is no module switch and no setting to turn on. Reports is available to every organisation on the platform, and the sidebar entry appears as soon as you hold the organization admin permission.
The organization admin permission is the only way in, for every part of the feature: building, previewing, exporting and downloading. Reports does not need the Orgo administrator flag that most configuration screens under Settings require, so an organization admin without that flag can still use it. There is no HR, finance or chapter version, so an organization HR manager or a chapter admin cannot open Reports at all, and cannot be given a read-only or chapter-scoped copy of one. A report covers the whole organisation, so treat access to Reports as the same reach as access to every member record. Scoped API tokens are refused too: a scoped token never carries the organization admin permission, whoever minted it.
You can move the Reports entry elsewhere with the Menu Organizer, but the page and its data still need the same permission wherever it sits.

Building a report

The builder has two panes. On the left, the rail holds the report’s name and everything it is made of: what it is Report on, its Columns and its Filters. On the right, the Preview is the report itself, as a table that updates as you work. The report builder with a name typed in, Members chosen as the starting point, five columns ticked in the left rail and the live preview table of members on the right
1

Name it and choose what it is about

Type a Report name and pick what to Report on from the dropdown: members, contacts, payments, event attendees, votes, companies or member roles. A new report starts on members. One report has exactly one starting point, and each row in your file will be one of these records. If you change it after ticking columns or adding filters, Orgo asks first, because they belong to the old choice and are cleared.
2

Tick the columns

Each starting point offers its own list of fields, and each ticked field becomes a column. Select all and Deselect all act on one group at a time. The small information icon beside a field explains what it holds.
3

Add columns from related records

Alongside the record’s own fields you can reach one step outwards, into a record it belongs to: a payment’s product and payer, a member’s chapter and membership type, an attendee’s event. Each related record is a collapsible group in the Columns list, with a counter of how many of its columns you have ticked. Those fields appear as extra columns with the relation named in front of them, so the chapter’s name arrives as Local Center Name rather than a second column called Name.
4

Filter it down

Press Add filter and add conditions until the report describes the group you mean. Filters are typed to the field you chose, so a date field offers dates and a status field offers its real list of values rather than a free text box.
5

Order the table

Click a column header in the preview to sort by it, and click again to reverse. A chip above the table shows the sort (A to Z or Z to A) and clears it. Drag a column header sideways to move the column. The sort and the column order are saved with the report and carried into the file.
6

Save it, then download

Save stores the report. Download saves any unsaved changes first and then starts the export, so the file always matches the table on screen. A report that has not been saved yet is created by pressing either.
The preview runs by itself a moment after you stop editing, and shows the first 10 rows with a “showing 10 of N” count and the same column headers the file will carry. The Refresh button re-runs it. A half-built filter shows a short message in the preview instead of rows. Unsaved changes appears beside the title until you save, and leaving the page then asks you to confirm.

Filters

The operators you are offered depend on the type of the field, so you never have to know what a field is stored as. The Filters section of the report rail with a condition row open on its property, operator and value controls Every filter you add narrows the report further: they are combined with and, always, and the builder shows an AND label between them. There is no or, no bracketing of one group of conditions against another, and no way to say “members in Berlin or Munich” in a single report. Run that as two reports, or filter on something the two have in common. A report has one sort, chosen in the table. There are no totals or grouping: subtotalling and charting are things to do in your spreadsheet once the file has downloaded.

What you can report on

Seven starting points, each with its own fields and its own related records. A few columns are worth knowing about:
  • Tags on members and contacts puts the person’s tag names, sorted, in one cell, and can be used as a filter.
  • Address is available on members and on companies, and a company also brings its Town and Country as related records.
  • Is Voting Representative and Voting Representative Of (members and contacts), and Has Voting Representative (companies), show who represents a company in votes.
  • Personal ID Number Encrypted (members and contacts) holds the personal identification number. Despite the name it is shown readable in the preview and in the file, and every preview or export that contains such values is written to the activity log, with the report name and who ran it.
Every related record in that table is one the row belongs to: a single product, a single chapter, a single event. That is the whole of what a report can reach.
Lists of related records are deliberately left out. A member has many payments, many roles and many course enrolments, and adding one of those to a member report would turn one member into one row per payment, with the member’s own details repeated down the file and every total inflated. So you cannot put members and their payments in one report, and you cannot step twice, from a payment to its payer to that payer’s chapter.Turn it around instead: to see payments with member details, start the report from Payments and add columns from User. One payment has exactly one payer, so the row count stays honest. The same trick covers roles (start from Member Roles) and attendance (start from Event Attendees).

Reading a saved report

Click a row in the list to open the report on its own page. It shows the saved report as a table, 50 rows to a page, with a row count, and Delete, Download and Edit buttons at the top. Click a column header to sort what you see; the sort here is a view only and is not saved (use Edit to change the saved order). Empty cells show a dash.

Downloading the file

Download hands the report to a background worker rather than making you wait at the screen, so a report matching a hundred thousand members behaves the same as one matching ten. You can start it from the list, from the report page or from the builder. A progress window opens and counts the rows as they are written. It updates live, and keeps checking on its own if the live connection drops, so the count keeps moving either way. You can leave it open or press Continue in background and carry on working. An export moves through pending, then processing, then completed, or failed if something went wrong. When it finishes you get the file two ways: The email arrives every time, which is what makes a long export safe to walk away from. Come back to it tomorrow and the link still works.

The file itself

  • CSV, comma separated, UTF-8 with a byte order mark, so accented names and non-Latin alphabets open correctly in Excel without an import step.
  • Every matching row. There is no row limit and nothing is truncated. Rows are fetched 500 at a time behind the scenes and written straight to the file, which is how a very large report stays within the worker’s memory, but that paging never reaches the file.
  • Readable headers. Field names are turned into words, and a column from a related record is prefixed with the relation, for example Local Center Name or Product Name. The headers match what the preview showed you.
  • Named after the report, so a saved report downloads under the same file name every month.
Every download is written to the activity log with the report name and who asked for it, and so is every save of a report.

Saving, editing and re-running

The list at /reports shows each report’s name, what it is based on, how many columns it has and when it was last updated. Each row has View, Download, Edit and Delete actions, and there is no owner column. The Reports list with three saved reports, each showing what it is based on, its column count and when it was last updated, with the view, download, edit and delete actions on the row Saving a report stores the definition, not the data. Open it again next month, press Download, and it runs against today’s records. Editing a saved report changes what the next export contains. It does not touch files you have already downloaded, and it does not reach back into an export that is already running.
Saved reports belong to the organisation, not to you. Every report is visible to every organization admin in your organisation, and any of them can open it, run it, edit it and delete it. The list shows no owner column, so there is no way to tell from the screen who built a report, and a report you rely on every month can be changed or removed by a colleague without warning. The activity log does record who saved a report and when.This is how the feature is meant to work: reports are a shared library of the organisation’s standard extracts rather than private saved searches. Name them so their purpose is obvious to somebody who did not build them, and treat a report you depend on as shared infrastructure.

Limits


How Reports differs from Ask Orgo and Database Queries

Three features look adjacent and answer different questions. Only the first is this page. Database Queries stores the statement Ask Orgo produced and replays it, so what it can answer is whatever the assistant managed to build that day. Reports is something you fill in yourself, from a fixed set of starting points, and its export walks the entire result set instead of one 500-row page. Ask Orgo is the right tool for a question you have not asked before, or one that needs grouping, a chart or arithmetic the report builder does not do. It involves a language model, which means it can reach further and can also misread you. Reports involves no model at all: you choose the columns, so the same report gives the same shape of file every time. Use Ask Orgo to explore, and a report for the file you download every month. Both Reports and Ask Orgo need the organization admin permission. The built-in Analytics dashboards, also described in Insights & Ask Orgo, have their own access levels.

Common questions

No. Every page and every action behind Reports requires the organization admin permission. There is no chapter-scoped version and no read-only version.If a colleague needs the numbers regularly, build the report, download it and send them the file, or give them the analytics dashboards if a total is enough.
Because a member has many payments, and a row can hold only one. Joining them would give you one row per payment with the member’s details repeated, which is a fine list of payments and a badly wrong list of members: totals and counts computed from it come out several times too high.Start from Payments instead and add columns from User. You get every payment with its payer’s name, email and chapter beside it, and one row means one payment. Roles and event attendance work the same way round.
A report reaches one step out and stops. From a payment you can add the payer’s own fields, but not the payer’s chapter, because that is a second step.Pick the starting point that puts what you need one step away. If the answer genuinely needs two hops, run two reports and join them in a spreadsheet on an id column, or ask the question in Ask Orgo, which can follow a longer path.
Not in the builder. A report produces rows and columns, with one sort you choose in the table; subtotals, pivots and charts are spreadsheet work once the file is open. The one thing worth deciding in Orgo is the filtering, because that is what keeps the file to a size you can work with.
No. Filters are always combined with and, and there is no grouping. A report asking for members in Berlin or Munich has to be two reports.Often there is a single condition that means the same thing: a chapter, a tag, a membership type or a date range that both groups share. Look for that before splitting the report in two.
That is how saved reports work: they belong to the organisation, and every organization admin can open, edit and delete any of them. There is no owner column and no per-report permission. The activity log shows who saved it last.Rebuild it and give it a name that says what it is for and who relies on it. If your organisation runs several standard extracts, agree a naming convention so nobody tidies away a report they did not recognise.
Nothing is lost. The export carries on running on its own, and the report is ready email arrives when it finishes with a link that stays valid for 3 days. Open the report again afterwards if you would rather download it from the screen.
The second press joins the run already in progress rather than starting a second one, so you get one file and the report is not queried twice.
Not yet. A report runs when somebody presses Download. The email you get is the delivery of that run, not a subscription.

  • Insights & Ask Orgo for questions in plain language and the analytics dashboards
  • Members for the directory, its own filters and its paged export
  • Membership fees for the payment screens a payments report draws from
  • Permissions for what the organization admin permission unlocks
  • Activity log for the record of who downloaded what
  • Email lists for building a segment to send to, rather than a file to download