Build a report from your members, payments, events or votes, and download the whole result set as a CSV
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
Surface
Route
Who can open it
Reports list
/reports, sidebar item Reports in the Administration section
Organization admins
A report, read-only
/reports/:item, opened by clicking a row in the list
Organization admins
Build a report
/reports/create
Organization admins
Edit a report
/reports/edit/:item
Organization admins
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.
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.
Field
Operators
Text
contains, equals
Number and amount
equals, greater than, less than, at least, at most
Date
on, after, before
Yes or no
is, with Yes or No
A field with a fixed list of values, such as a status
is, choosing from the real list
Tags (members and contacts)
is, choosing from your organisation’s tags
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.
Report is about
Fields on the record
Related records you can add columns from
Members
21
Local Center, Type, Town Current, Fee Tenant Product Price, Voting Representative Of
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:
Where
How long the link lasts
Download in the progress window
About 15 minutes
The report is ready email, sent to you whether or not the window is still open
3 days
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.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
Limit
Value
Columns in one report
20
Filters in one report
20
Steps out to related records
1
Related records joined
6
Rows in the downloaded file
No limit
Rows in the builder preview
10
Rows per page on a saved report’s own page
50
How Reports differs from Ask Orgo and Database Queries
Three features look adjacent and answer different questions. Only the first is
this page.
What you do
What comes back
Reports
Fill in a form: one of seven record types, columns, filters
A CSV of the whole result set, downloaded again whenever you need it
Re-run a statement Ask Orgo wrote earlier and you saved
The saved query’s results, exported a page at a time
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
Can I give Reports to an HR admin or a chapter admin?
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.
Why can I not put members and their payments in one report?
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.
I need columns from a record two steps away
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.
Can I add a total row?
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.
Can I write a filter that means one thing or another?
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.
Somebody else edited, or deleted, my report
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.
I closed the progress window before the file was ready
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 download link stopped working
The link in the progress window is deliberately short lived, about 15
minutes, and the emailed one lasts 3 days. Both are meant to expire so a
forwarded link does not become a permanent open door to your organisation’s
data.Once a link has expired, open the report and press Download again. The
report re-runs against today’s records, so the new file may differ from the
old one, which is usually what you wanted anyway.
I pressed Download twice
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.
Can I schedule a report, or have it emailed every month?
Not yet. A report runs when somebody presses Download. The email you get
is the delivery of that run, not a subscription.
Related
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
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Orgo Documentation","colors":{"primary":"#16A34A","light":"#07C983","dark":"#15803D"},"logo":{"light":"https://mintcdn.com/orgo-dc7abe63/BNSJo8TfEHWYUUsw/images/orgo-logo-transparent.png?fit=max\u0026auto=format\u0026n=BNSJo8TfEHWYUUsw\u0026q=85\u0026s=b68efcea74a9c92be763019ff7faf5ff","dark":"https://mintcdn.com/orgo-dc7abe63/BcaQGMmLlvrr9oyS/images/orgo-logo-white.png?fit=max\u0026auto=format\u0026n=BcaQGMmLlvrr9oyS\u0026q=85\u0026s=4da1dfe66530649ff52ed677d39f0037","href":"https://orgo.space/docs/platform"},"favicon":"https://mintcdn.com/orgo-dc7abe63/Et5eDshrgsaFMKz4/favicon.svg?fit=max\u0026auto=format\u0026n=Et5eDshrgsaFMKz4\u0026q=85\u0026s=96f65e3e14f23ca1a179e6462a2398f8","api":{"playground":{"display":"simple"}},"navbar":{"links":[{"href":"https://app.orgo.space/start","label":"Get Started"}]},"footer":{"socials":{"website":"https://orgo.space","linkedin":"https://www.linkedin.com/company/orgospace","github":"https://github.com/Orgo-space"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"styling":{"latex":false},"navigation":{"global":{"anchors":[]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"orgo-dc7abe63","hasAudioNarration":false,"actualSubdomain":"orgo-dc7abe63","customDomains":["orgo.space"],"gitSource":{"type":"github","owner":"orgo-space","repo":"api-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6afb29ec64ef06e8fe2f7e72","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"default","tag":"API Reference","count":939},{"language":"default","tag":"Documentation","count":135},{"language":"default","tag":"Website","count":35},{"language":"default","tag":"Event","count":27},{"language":"default","tag":"Company","count":26},{"language":"default","tag":"Post","count":26},{"language":"default","tag":"Users \u0026 Profiles","count":25},{"language":"default","tag":"User","count":23},{"language":"default","tag":"Webhooks","count":18},{"language":"default","tag":"Events","count":17}]},"assistantConfig":{},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"platform/reports","slug":"/platform/reports","pageMetadata":{"title":"Reports","description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","og:title":"Reports | Orgo","og:description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","twitter:title":"Reports | Orgo","twitter:description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","href":"/platform/reports"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,hr:`hr`,li:`li`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Heading,Note,OptimizedImage,Step,Steps,Table,Warning}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Reports`}),` is a builder for the exports your organisation runs again and again.\nYou pick what the report is about, tick the columns you want, add filters, watch\nthe table fill in beside you, and download a CSV. Nothing is typed as a query and\nnothing is capped at a page: the file holds every row that matched.`]}),`\n`,_jsxs(_components.p,{children:[`This page is about `,_jsx(_components.strong,{children:`Reports`}),` only. If you want to type a question and get a\none-off answer on screen, or read the built-in dashboards, that is a different\nscreen: see `,_jsx(_components.a,{href:`/platform/insights`,children:`Insights \u0026 Ask Orgo`}),`. The two are compared\n`,_jsx(_components.a,{href:`#how-reports-differs-from-ask-orgo-and-database-queries`,children:`below`}),`.`]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Built for`}),` admins who need the same extract every month, or a one-off list\nwith exactly the columns a colleague, an auditor or a funder asked for.`]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Replaces`}),` exporting the member directory a page at a time, stitching several\nspreadsheets together, and asking a developer for a data pull.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`where-to-find-it`,children:`Where to find it`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=a91636ee1c8ef15617bdc27e9a1c83bf`,alt:`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`,style:{width:`100%`,borderRadius:`8px`,border:`1px solid var(--border-color)`,marginBottom:`1rem`},\"data-og-width\":`3840`,width:`3840`,\"data-og-height\":`2160`,height:`2160`,\"data-path\":`images/platform/reports/reports-empty.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=280\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=43904d720175aff95429c397f5c07c3d 280w, https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=560\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=2f7733776cb8a9347f42f6c778448f05 560w, https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=840\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=be9d8aaa186c7125b66c762c4942e493 840w, https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=1100\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=728f3d103bdc4101fd6ed341c460edb1 1100w, https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=1650\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=94500d7c62f65188809aac10b9caf499 1650w, https://mintcdn.com/orgo-dc7abe63/viLz0s2uGN1O99y6/images/platform/reports/reports-empty.png?w=2500\u0026fit=max\u0026auto=format\u0026n=viLz0s2uGN1O99y6\u0026q=85\u0026s=bd40581ee2946716624cf8e4b14dd8a7 2500w`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Surface`}),_jsx(_components.th,{children:`Route`}),_jsx(_components.th,{children:`Who can open it`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`Reports`}),` list`]}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`/reports`}),`, sidebar item `,_jsx(_components.strong,{children:`Reports`}),` in the Administration section`]}),_jsx(_components.td,{children:`Organization admins`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`A report, read-only`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`/reports/:item`}),`, opened by clicking a row in the list`]}),_jsx(_components.td,{children:`Organization admins`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Build a report`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`/reports/create`})}),_jsx(_components.td,{children:`Organization admins`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Edit a report`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`/reports/edit/:item`})}),_jsx(_components.td,{children:`Organization admins`})]})]})]}),`\n`,_jsx(_components.p,{children:`There is no module switch and no setting to turn on. Reports is available to\nevery organisation on the platform, and the sidebar entry appears as soon as you\nhold the organization admin permission.`}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`The organization admin permission is the only way in, for every part of the\nfeature: building, previewing, exporting and downloading. Reports does `,_jsx(_components.strong,{children:`not`}),`\nneed the Orgo administrator flag that most configuration screens under Settings\nrequire, so an organization admin without that flag can still use it. There is no\nHR, finance or chapter version, so an organization HR manager or a chapter admin\ncannot open Reports at all, and cannot be given a read-only or chapter-scoped\ncopy of one. A report covers the whole organisation, so treat access to Reports\nas the same reach as access to every member record. `,_jsx(_components.a,{href:`/platform/api`,children:`Scoped API\ntokens`}),` are refused too: a scoped token never carries the\norganization admin permission, whoever minted it.`]})}),`\n`,_jsxs(_components.p,{children:[`You can move the `,_jsx(_components.strong,{children:`Reports`}),` entry elsewhere with the `,_jsx(_components.a,{href:`/platform/customization/menu-organizer`,children:`Menu Organizer`}),`,\nbut the page and its data still need the same permission wherever it sits.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`building-a-report`,children:`Building a report`}),`\n`,_jsxs(_components.p,{children:[`The builder has two panes. On the left, the `,_jsx(_components.strong,{children:`rail`}),` holds the report’s name and\neverything it is made of: what it is `,_jsx(_components.strong,{children:`Report on`}),`, its `,_jsx(_components.strong,{children:`Columns`}),` and its\n`,_jsx(_components.strong,{children:`Filters`}),`. On the right, the `,_jsx(_components.strong,{children:`Preview`}),` is the report itself, as a table that\nupdates as you work.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=bf6b93061ea85a2957485ce958ff9750`,alt:`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`,style:{width:`100%`,borderRadius:`8px`,border:`1px solid var(--border-color)`,marginBottom:`1rem`},\"data-og-width\":`3840`,width:`3840`,\"data-og-height\":`2580`,height:`2580`,\"data-path\":`images/platform/reports/reports-builder.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=280\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=036b6edc846a1b24336af07bfcfc9971 280w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=560\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=d97611f40aa321c09f25814a29742f8b 560w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=840\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=34b928e26ccd89be49cb3e3c38466cc0 840w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=1100\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=a26d4fd0de03d6433eb674bb107b083c 1100w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=1650\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=d2a497b4e9adee2994b8da4ca81916ef 1650w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-builder.png?w=2500\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=c496d0dbf87efd43d09c09cf2a6312f9 2500w`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Name it and choose what it is about`,children:_jsxs(_components.p,{children:[`Type a `,_jsx(_components.strong,{children:`Report name`}),` and pick what to `,_jsx(_components.strong,{children:`Report on`}),` from the dropdown: members,\ncontacts, payments, event attendees, votes, companies or member roles. A new\nreport starts on members. One report has exactly one starting point, and each row\nin your file will be one of these records. If you change it after ticking columns\nor adding filters, Orgo asks first, because they belong to the old choice and are\ncleared.`]})}),_jsx(Step,{title:`Tick the columns`,children:_jsxs(_components.p,{children:[`Each starting point offers its own list of fields, and each ticked field becomes a\ncolumn. `,_jsx(_components.strong,{children:`Select all`}),` and `,_jsx(_components.strong,{children:`Deselect all`}),` act on one group at a time. The small\ninformation icon beside a field explains what it holds.`]})}),_jsx(Step,{title:`Add columns from related records`,children:_jsxs(_components.p,{children:[`Alongside the record’s own fields you can reach one step outwards, into a record\nit belongs to: a payment’s product and payer, a member’s chapter and membership\ntype, an attendee’s event. Each related record is a collapsible group in the\nColumns list, with a counter of how many of its columns you have ticked. Those\nfields appear as extra columns with the relation named in front of them, so the\nchapter’s name arrives as `,_jsx(_components.strong,{children:`Local Center Name`}),` rather than a second column called\n`,_jsx(_components.strong,{children:`Name`}),`.`]})}),_jsx(OptimizedImage,{src:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=198efc317a61f3e834b118bf68b6fe97`,alt:`The Columns rail of a saved report with a related record group expanded, showing the fields it can add and the counter of how many are ticked`,style:{width:`100%`,borderRadius:`8px`,border:`1px solid var(--border-color)`,marginBottom:`1rem`},\"data-og-width\":`3840`,width:`3840`,\"data-og-height\":`2160`,height:`2160`,\"data-path\":`images/platform/reports/reports-field-groups.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=280\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=6c837857eeb3cbad89d10cfa05217e9c 280w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=560\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=d5ddc071c1d4cc49017a8b6cf274ddab 560w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=840\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=7c716b3437823365e05e2533b7faf884 840w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=1100\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=6dfcfcf4b3680999e56ba58ae6079806 1100w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=1650\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=ecf76b71bedc0cbd670685a32be8f3fb 1650w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-field-groups.png?w=2500\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=260bf24228d16faea74b6600c41c30b6 2500w`}),_jsx(Step,{title:`Filter it down`,children:_jsxs(_components.p,{children:[`Press `,_jsx(_components.strong,{children:`Add filter`}),` and add conditions until the report describes the group you\nmean. Filters are typed to the field you chose, so a date field offers dates and a\nstatus field offers its real list of values rather than a free text box.`]})}),_jsx(Step,{title:`Order the table`,children:_jsxs(_components.p,{children:[`Click a column header in the preview to sort by it, and click again to reverse. A\nchip above the table shows the sort (`,_jsx(_components.strong,{children:`A to Z`}),` or `,_jsx(_components.strong,{children:`Z to A`}),`) and clears it. Drag\na column header sideways to move the column. The sort and the column order are\nsaved with the report and carried into the file.`]})}),_jsx(Step,{title:`Save it, then download`,children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Save`}),` stores the report. `,_jsx(_components.strong,{children:`Download`}),` saves any unsaved changes first and then\nstarts the export, so the file always matches the table on screen. A report that\nhas not been saved yet is created by pressing either.`]})})]}),`\n`,_jsxs(_components.p,{children:[`The preview runs by itself a moment after you stop editing, and shows the first 10\nrows with a “showing 10 of N” count and the same column headers the file will carry.\nThe `,_jsx(_components.strong,{children:`Refresh`}),` button re-runs it. A half-built filter shows a short message in the\npreview instead of rows. `,_jsx(_components.strong,{children:`Unsaved changes`}),` appears beside the title until you\nsave, and leaving the page then asks you to confirm.`]}),`\n`,_jsx(Heading,{level:`3`,id:`filters`,children:`Filters`}),`\n`,_jsx(_components.p,{children:`The operators you are offered depend on the type of the field, so you never have\nto know what a field is stored as.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=350c54e97cd4a8597c6c76b9c6025da2`,alt:`The Filters section of the report rail with a condition row open on its property, operator and value controls`,style:{width:`100%`,borderRadius:`8px`,border:`1px solid var(--border-color)`,marginBottom:`1rem`},\"data-og-width\":`3840`,width:`3840`,\"data-og-height\":`2580`,height:`2580`,\"data-path\":`images/platform/reports/reports-filters.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=280\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=1bd4e348109b4addf1bd8123a1589584 280w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=560\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=bc47dbede11375f3bd895b64ff6dff23 560w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=840\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=ecd85b8ad533f9a2a21bfca86792ac3d 840w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=1100\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=6fc8a19c6e15342ff621a388fcf60dee 1100w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=1650\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=3f6043934bbffa564cebb14ad02efe1c 1650w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-filters.png?w=2500\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=4c4c4dce3f1e136c59808e693e7309a1 2500w`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Field`}),_jsx(_components.th,{children:`Operators`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Text`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`contains`}),`, `,_jsx(_components.strong,{children:`equals`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Number and amount`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`equals`}),`, `,_jsx(_components.strong,{children:`greater than`}),`, `,_jsx(_components.strong,{children:`less than`}),`, `,_jsx(_components.strong,{children:`at least`}),`, `,_jsx(_components.strong,{children:`at most`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Date`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`on`}),`, `,_jsx(_components.strong,{children:`after`}),`, `,_jsx(_components.strong,{children:`before`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Yes or no`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`is`}),`, with `,_jsx(_components.strong,{children:`Yes`}),` or `,_jsx(_components.strong,{children:`No`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`A field with a fixed list of values, such as a status`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`is`}),`, choosing from the real list`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Tags (members and contacts)`}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`is`}),`, choosing from your organisation’s tags`]})]})]})]}),`\n`,_jsxs(_components.p,{children:[`Every filter you add narrows the report further: they are combined with `,_jsx(_components.strong,{children:`and`}),`,\nalways, and the builder shows an `,_jsx(_components.strong,{children:`AND`}),` label between them. There is no `,_jsx(_components.strong,{children:`or`}),`, no\nbracketing of one group of conditions against another, and no way to say “members\nin Berlin or Munich” in a single report. Run that as two reports, or filter on\nsomething the two have in common.`]}),`\n`,_jsx(_components.p,{children:`A report has one sort, chosen in the table. There are no totals or grouping:\nsubtotalling and charting are things to do in your spreadsheet once the file has\ndownloaded.`}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`what-you-can-report-on`,children:`What you can report on`}),`\n`,_jsx(_components.p,{children:`Seven starting points, each with its own fields and its own related records.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Report is about`}),_jsx(_components.th,{children:`Fields on the record`}),_jsx(_components.th,{children:`Related records you can add columns from`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Members`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`21`}),_jsx(_components.td,{children:`Local Center, Type, Town Current, Fee Tenant Product Price, Voting Representative Of`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Contacts`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`12`}),_jsx(_components.td,{children:`Local Center, Voting Representative Of`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Payments`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`18`}),_jsx(_components.td,{children:`Product, Subscription Profile, Contact, User, Price, Manual Fee Payment, Accepted By, Identity, Invoice, Company`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Event Attendees`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`7`}),_jsx(_components.td,{children:`Event, User, External, Product Payment, Product Price, Invoice`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Votes`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`5`}),_jsx(_components.td,{children:`Owner, Event`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Companies`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`12`}),_jsx(_components.td,{children:`Town, Country, Fee Tenant Product Price, Voting Representative, Voting Representative Contact`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Member Roles`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:`4`}),_jsx(_components.td,{children:`Role, User, Unit`})]})]})]}),`\n`,_jsx(_components.p,{children:`A few columns are worth knowing about:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Tags`}),` on members and contacts puts the person’s tag names, sorted, in one cell, and can be used as a filter.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Address`}),` is available on members and on companies, and a company also brings its `,_jsx(_components.strong,{children:`Town`}),` and `,_jsx(_components.strong,{children:`Country`}),` as related records.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Is Voting Representative`}),` and `,_jsx(_components.strong,{children:`Voting Representative Of`}),` (members and contacts), and `,_jsx(_components.strong,{children:`Has Voting Representative`}),` (companies), show who represents a company in votes.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`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 `,_jsx(_components.a,{href:`/platform/logs`,children:`activity log`}),`, with the report name and who ran it.`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`Every related record in that table is one the row belongs to: a single product,\na single chapter, a single event. That is the whole of what a report can reach.`}),`\n`,_jsxs(Note,{children:[_jsx(_components.p,{children:`Lists of related records are deliberately left out. A member has many payments,\nmany roles and many course enrolments, and adding one of those to a member\nreport would turn one member into one row per payment, with the member’s own\ndetails repeated down the file and every total inflated. So you cannot put\nmembers and their payments in one report, and you cannot step twice, from a\npayment to its payer to that payer’s chapter.`}),_jsxs(_components.p,{children:[`Turn it around instead: to see payments with member details, start the report\nfrom `,_jsx(_components.strong,{children:`Payments`}),` and add columns from `,_jsx(_components.strong,{children:`User`}),`. One payment has exactly one\npayer, so the row count stays honest. The same trick covers roles (start from\n`,_jsx(_components.strong,{children:`Member Roles`}),`) and attendance (start from `,_jsx(_components.strong,{children:`Event Attendees`}),`).`]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`reading-a-saved-report`,children:`Reading a saved report`}),`\n`,_jsxs(_components.p,{children:[`Click a row in the list to open the report on its own page. It shows the saved\nreport as a table, 50 rows to a page, with a row count, and `,_jsx(_components.strong,{children:`Delete`}),`, `,_jsx(_components.strong,{children:`Download`}),`\nand `,_jsx(_components.strong,{children:`Edit`}),` buttons at the top. Click a column header to sort what you see; the\nsort here is a view only and is not saved (use Edit to change the saved order).\nEmpty cells show a dash.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`downloading-the-file`,children:`Downloading the file`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Download`}),` hands the report to a background worker rather than making you wait\nat the screen, so a report matching a hundred thousand members behaves the same\nas one matching ten. You can start it from the list, from the report page or from\nthe builder.`]}),`\n`,_jsxs(_components.p,{children:[`A progress window opens and counts the rows as they are written. It updates\nlive, and keeps checking on its own if the live connection drops, so the count\nkeeps moving either way. You can leave it open or press `,_jsx(_components.strong,{children:`Continue in\nbackground`}),` and carry on working. An export moves through `,_jsx(_components.strong,{children:`pending`}),`, then\n`,_jsx(_components.strong,{children:`processing`}),`, then `,_jsx(_components.strong,{children:`completed`}),`, or `,_jsx(_components.strong,{children:`failed`}),` if something went wrong.`]}),`\n`,_jsx(_components.p,{children:`When it finishes you get the file two ways:`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Where`}),_jsx(_components.th,{children:`How long the link lasts`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`Download`}),` in the progress window`]}),_jsx(_components.td,{children:`About 15 minutes`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[`The `,_jsx(_components.strong,{children:`report is ready`}),` email, sent to you whether or not the window is still open`]}),_jsx(_components.td,{children:`3 days`})]})]})]}),`\n`,_jsx(_components.p,{children:`The email arrives every time, which is what makes a long export safe to walk\naway from. Come back to it tomorrow and the link still works.`}),`\n`,_jsx(Heading,{level:`3`,id:`the-file-itself`,children:`The file itself`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`CSV`}),`, comma separated, UTF-8 with a byte order mark, so accented names and\nnon-Latin alphabets open correctly in Excel without an import step.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Every matching row.`}),` There is no row limit and nothing is truncated. Rows\nare fetched 500 at a time behind the scenes and written straight to the file,\nwhich is how a very large report stays within the worker’s memory, but that\npaging never reaches the file.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Readable headers.`}),` Field names are turned into words, and a column from a\nrelated record is prefixed with the relation, for example `,_jsx(_components.code,{children:`Local Center Name`}),`\nor `,_jsx(_components.code,{children:`Product Name`}),`. The headers match what the preview showed you.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Named after the report`}),`, so a saved report downloads under the same file\nname every month.`]}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`Every download is written to the `,_jsx(_components.a,{href:`/platform/logs`,children:`activity log`}),` with the report\nname and who asked for it, and so is every save of a report.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`saving-editing-and-re-running`,children:`Saving, editing and re-running`}),`\n`,_jsxs(_components.p,{children:[`The list at `,_jsx(_components.code,{children:`/reports`}),` shows each report’s name, what it is based on, how many\ncolumns it has and when it was last updated. Each row has `,_jsx(_components.strong,{children:`View`}),`, `,_jsx(_components.strong,{children:`Download`}),`,\n`,_jsx(_components.strong,{children:`Edit`}),` and `,_jsx(_components.strong,{children:`Delete`}),` actions, and there is no owner column.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=68f8616ecd2cfe7e332386adfa002a46`,alt:`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`,style:{width:`100%`,borderRadius:`8px`,border:`1px solid var(--border-color)`,marginBottom:`1rem`},\"data-og-width\":`3840`,width:`3840`,\"data-og-height\":`2160`,height:`2160`,\"data-path\":`images/platform/reports/reports-list.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=280\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=12b6518609914e5870b4af3e458e2dc3 280w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=560\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=67d57ab2cfeba67f85201d38d69edf2a 560w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=840\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=5f5d3e275145335e829d101f79450fed 840w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=1100\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=3cb9f80d1987fdc8688d64909adc1820 1100w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=1650\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=50693b566992d90005fbc771435fc6ea 1650w, https://mintcdn.com/orgo-dc7abe63/9KcNMl_fMrFpEcOK/images/platform/reports/reports-list.png?w=2500\u0026fit=max\u0026auto=format\u0026n=9KcNMl_fMrFpEcOK\u0026q=85\u0026s=ee9b909c6e53287e454b145aebe1175c 2500w`}),`\n`,_jsxs(_components.p,{children:[`Saving a report stores the definition, not the data. Open it again next month,\npress `,_jsx(_components.strong,{children:`Download`}),`, and it runs against today’s records.`]}),`\n`,_jsx(_components.p,{children:`Editing a saved report changes what the next export contains. It does not touch\nfiles you have already downloaded, and it does not reach back into an export\nthat is already running.`}),`\n`,_jsxs(Warning,{children:[_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Saved reports belong to the organisation, not to you.`}),` Every report is\nvisible to every organization admin in your organisation, and any of\nthem can open it, run it, edit it and delete it. The list shows no owner column,\nso there is no way to tell from the screen who built a report, and a report you\nrely on every month can be changed or removed by a colleague without warning.\nThe activity log does record who saved a report and when.`]}),_jsx(_components.p,{children:`This is how the feature is meant to work: reports are a shared library of the\norganisation’s standard extracts rather than private saved searches. Name them\nso their purpose is obvious to somebody who did not build them, and treat a\nreport you depend on as shared infrastructure.`})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`limits`,children:`Limits`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Limit`}),_jsx(_components.th,{children:`Value`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Columns in one report`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`20`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Filters in one report`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`20`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Steps out to related records`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`1`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Related records joined`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`6`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Rows in the downloaded file`}),_jsx(_components.td,{children:`No limit`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Rows in the builder preview`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`10`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Rows per page on a saved report’s own page`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`50`})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`how-reports-differs-from-ask-orgo-and-database-queries`,children:`How Reports differs from Ask Orgo and Database Queries`}),`\n`,_jsx(_components.p,{children:`Three features look adjacent and answer different questions. Only the first is\nthis page.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{}),_jsx(_components.th,{children:`What you do`}),_jsx(_components.th,{children:`What comes back`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Reports`})}),_jsx(_components.td,{children:`Fill in a form: one of seven record types, columns, filters`}),_jsx(_components.td,{children:`A CSV of the whole result set, downloaded again whenever you need it`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:_jsx(_components.a,{href:`/platform/insights#ask-orgo`,children:`Ask Orgo`})})}),_jsx(_components.td,{children:`Type a question in your own words`}),_jsx(_components.td,{children:`A one-off answer on screen, as a table or chart, from a language model`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:_jsx(_components.a,{href:`/platform/insights#database-queries`,children:`Database Queries`})})}),_jsx(_components.td,{children:`Re-run a statement Ask Orgo wrote earlier and you saved`}),_jsx(_components.td,{children:`The saved query’s results, exported a page at a time`})]})]})]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Database Queries`}),` stores the statement Ask Orgo produced and replays it, so\nwhat it can answer is whatever the assistant managed to build that day. Reports\nis something you fill in yourself, from a fixed set of starting points, and its\nexport walks the entire result set instead of one 500-row page.`]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Ask Orgo`}),` is the right tool for a question you have not asked before, or one\nthat needs grouping, a chart or arithmetic the report builder does not do. It\ninvolves a language model, which means it can reach further and can also\nmisread you. Reports involves no model at all: you choose the columns, so the\nsame report gives the same shape of file every time. Use Ask Orgo to explore,\nand a report for the file you download every month.`]}),`\n`,_jsxs(_components.p,{children:[`Both Reports and Ask Orgo need the organization admin permission. The built-in\n`,_jsx(_components.strong,{children:`Analytics`}),` dashboards, also described in `,_jsx(_components.a,{href:`/platform/insights`,children:`Insights \u0026 Ask Orgo`}),`,\nhave their own access levels.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`common-questions`,children:`Common questions`}),`\n`,_jsxs(AccordionGroup,{children:[_jsxs(Accordion,{title:`Can I give Reports to an HR admin or a chapter admin?`,id:`can-i-give-reports-to-an-hr-admin-or-a-chapter-admin`,children:[_jsx(_components.p,{children:`No. Every page and every action behind Reports requires the organization admin\npermission. There is no chapter-scoped version and no read-only version.`}),_jsxs(_components.p,{children:[`If a colleague needs the numbers regularly, build the report, download it and\nsend them the file, or give them the `,_jsx(_components.a,{href:`/platform/insights`,children:`analytics\ndashboards`}),` if a total is enough.`]})]}),_jsxs(Accordion,{title:`Why can I not put members and their payments in one report?`,id:`why-can-i-not-put-members-and-their-payments-in-one-report`,children:[_jsx(_components.p,{children:`Because a member has many payments, and a row can hold only one. Joining\nthem would give you one row per payment with the member’s details repeated,\nwhich is a fine list of payments and a badly wrong list of members: totals\nand counts computed from it come out several times too high.`}),_jsxs(_components.p,{children:[`Start from `,_jsx(_components.strong,{children:`Payments`}),` instead and add columns from `,_jsx(_components.strong,{children:`User`}),`. You get every\npayment with its payer’s name, email and chapter beside it, and one row means\none payment. Roles and event attendance work the same way round.`]})]}),_jsxs(Accordion,{title:`I need columns from a record two steps away`,id:`i-need-columns-from-a-record-two-steps-away`,children:[_jsx(_components.p,{children:`A report reaches one step out and stops. From a payment you can add the\npayer’s own fields, but not the payer’s chapter, because that is a second\nstep.`}),_jsxs(_components.p,{children:[`Pick the starting point that puts what you need one step away. If the answer\ngenuinely needs two hops, run two reports and join them in a spreadsheet on\nan id column, or ask the question in `,_jsx(_components.a,{href:`/platform/insights`,children:`Ask Orgo`}),`, which\ncan follow a longer path.`]})]}),_jsx(Accordion,{title:`Can I add a total row?`,id:`can-i-add-a-total-row`,children:_jsx(_components.p,{children:`Not in the builder. A report produces rows and columns, with one sort you\nchoose in the table; subtotals, pivots and charts are spreadsheet work once the\nfile is open. The one thing worth deciding in Orgo is the filtering, because\nthat is what keeps the file to a size you can work with.`})}),_jsxs(Accordion,{title:`Can I write a filter that means one thing or another?`,id:`can-i-write-a-filter-that-means-one-thing-or-another`,children:[_jsxs(_components.p,{children:[`No. Filters are always combined with `,_jsx(_components.strong,{children:`and`}),`, and there is no grouping. A\nreport asking for members in Berlin or Munich has to be two reports.`]}),_jsx(_components.p,{children:`Often there is a single condition that means the same thing: a chapter, a\ntag, a membership type or a date range that both groups share. Look for that\nbefore splitting the report in two.`})]}),_jsxs(Accordion,{title:`Somebody else edited, or deleted, my report`,id:`somebody-else-edited-or-deleted-my-report`,children:[_jsxs(_components.p,{children:[`That is how saved reports work: they belong to the organisation, and every\norganization admin can open, edit and delete any of them. There is no owner\ncolumn and no per-report permission. The `,_jsx(_components.a,{href:`/platform/logs`,children:`activity log`}),` shows\nwho saved it last.`]}),_jsx(_components.p,{children:`Rebuild it and give it a name that says what it is for and who relies on it.\nIf your organisation runs several standard extracts, agree a naming\nconvention so nobody tidies away a report they did not recognise.`})]}),_jsx(Accordion,{title:`I closed the progress window before the file was ready`,id:`i-closed-the-progress-window-before-the-file-was-ready`,children:_jsxs(_components.p,{children:[`Nothing is lost. The export carries on running on its own, and the `,_jsx(_components.strong,{children:`report\nis ready`}),` email arrives when it finishes with a link that stays valid for 3\ndays. Open the report again afterwards if you would rather download it from\nthe screen.`]})}),_jsxs(Accordion,{title:`The download link stopped working`,id:`the-download-link-stopped-working`,children:[_jsx(_components.p,{children:`The link in the progress window is deliberately short lived, about 15\nminutes, and the emailed one lasts 3 days. Both are meant to expire so a\nforwarded link does not become a permanent open door to your organisation’s\ndata.`}),_jsxs(_components.p,{children:[`Once a link has expired, open the report and press `,_jsx(_components.strong,{children:`Download`}),` again. The\nreport re-runs against today’s records, so the new file may differ from the\nold one, which is usually what you wanted anyway.`]})]}),_jsx(Accordion,{title:`I pressed Download twice`,id:`i-pressed-download-twice`,children:_jsx(_components.p,{children:`The second press joins the run already in progress rather than starting a\nsecond one, so you get one file and the report is not queried twice.`})}),_jsx(Accordion,{title:`Can I schedule a report, or have it emailed every month?`,id:`can-i-schedule-a-report-or-have-it-emailed-every-month`,children:_jsxs(_components.p,{children:[`Not yet. A report runs when somebody presses `,_jsx(_components.strong,{children:`Download`}),`. The email you get\nis the delivery of that run, not a subscription.`]})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`related`,children:`Related`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/insights`,children:`Insights \u0026 Ask Orgo`}),` for questions in plain language and the analytics dashboards`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/users`,children:`Members`}),` for the directory, its own filters and its paged export`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/fees/fees`,children:`Membership fees`}),` for the payment screens a payments report draws from`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/permissions`,children:`Permissions`}),` for what the organization admin permission unlocks`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/logs`,children:`Activity log`}),` for the record of who downloaded what`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.a,{href:`/platform/emails/email-lists`,children:`Email lists`}),` for building a segment to send to, rather than a file to download`]}),`\n`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Reports","description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","og:title":"Reports | Orgo","og:description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","twitter:title":"Reports | Orgo","twitter:description":"Build a report from your members, payments, events or votes, and download the whole result set as a CSV","href":"/platform/reports"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Where to find it","slug":"where-to-find-it","depth":2,"children":[]},{"title":"Building a report","slug":"building-a-report","depth":2,"children":[{"title":"Filters","slug":"filters","depth":3,"children":[]}]},{"title":"What you can report on","slug":"what-you-can-report-on","depth":2,"children":[]},{"title":"Reading a saved report","slug":"reading-a-saved-report","depth":2,"children":[]},{"title":"Downloading the file","slug":"downloading-the-file","depth":2,"children":[{"title":"The file itself","slug":"the-file-itself","depth":3,"children":[]}]},{"title":"Saving, editing and re-running","slug":"saving-editing-and-re-running","depth":2,"children":[]},{"title":"Limits","slug":"limits","depth":2,"children":[]},{"title":"How Reports differs from Ask Orgo and Database Queries","slug":"how-reports-differs-from-ask-orgo-and-database-queries","depth":2,"children":[]},{"title":"Common questions","slug":"common-questions","depth":2,"children":[]},{"title":"Related","slug":"related","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"orgo-dc7abe63","siteName":"Orgo Documentation","title":"Reports | Orgo","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-11T20:47:21.518Z","originalFileLocation":"platform/reports.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\">\u003cmeta data-mint-head name=\"application-name\" content=\"Orgo Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Reports | Orgo\">\u003cmeta data-mint-head property=\"og:description\" content=\"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Orgo Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://orgo.space/docs/platform/reports\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://orgo-dc7abe63.mintlify.site/docs/_mintlify/api/og/v2?division=Organization\u0026amp;title=Reports\u0026amp;description=Build+a+report+from+your+members%2C+payments%2C+events+or+votes%2C+and+download+the+whole+result+set+as+a+CSV\u0026amp;theme=5de34bab2c106b7e5e539a7b\u0026amp;signature=70d6f8726be068cec96c3d897c7b6852c8b844ed966db12881f759cfaa984e46\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Reports | Orgo\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://orgo-dc7abe63.mintlify.site/docs/_mintlify/api/og/v2?division=Organization\u0026amp;title=Reports\u0026amp;description=Build+a+report+from+your+members%2C+payments%2C+events+or+votes%2C+and+download+the+whole+result+set+as+a+CSV\u0026amp;theme=5de34bab2c106b7e5e539a7b\u0026amp;signature=70d6f8726be068cec96c3d897c7b6852c8b844ed966db12881f759cfaa984e46\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/orgo-dc7abe63/8V1Y5PxooYj41P5E/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Orgo Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#16A34A\">\u003clink data-mint-head rel=\"canonical\" href=\"https://orgo.space/docs/platform/reports\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/platform/reports.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://orgo.space/#organization\",\"name\":\"Orgo Documentation\",\"url\":\"https://orgo.space\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/orgo-dc7abe63/BNSJo8TfEHWYUUsw/images/orgo-logo-transparent.png?fit=max\u0026auto=format\u0026n=BNSJo8TfEHWYUUsw\u0026q=85\u0026s=b68efcea74a9c92be763019ff7faf5ff\"}},{\"@type\":\"WebSite\",\"@id\":\"https://orgo.space/docs#website\",\"name\":\"Orgo Documentation\",\"url\":\"https://orgo.space/docs\",\"publisher\":{\"@id\":\"https://orgo.space/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://orgo.space/docs/platform/reports#webpage\",\"url\":\"https://orgo.space/docs/platform/reports\",\"name\":\"Reports\",\"description\":\"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\",\"dateModified\":\"2026-11-11T20:47:21.518Z\",\"isPartOf\":{\"@id\":\"https://orgo.space/docs#website\"},\"breadcrumb\":{\"@id\":\"https://orgo.space/docs/platform/reports#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://orgo.space/docs/platform/reports#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Organization\",\"item\":\"https://orgo.space/docs/platform/organisation\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reports\",\"item\":\"https://orgo.space/docs/platform/reports\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://orgo.space/docs/platform/reports#article\",\"headline\":\"Reports\",\"name\":\"Reports\",\"description\":\"Build a report from your members, payments, events or votes, and download the whole result set as a CSV\",\"url\":\"https://orgo.space/docs/platform/reports\",\"mainEntityOfPage\":{\"@id\":\"https://orgo.space/docs/platform/reports#webpage\"},\"dateModified\":\"2026-11-11T20:47:21.518Z\",\"publisher\":{\"@id\":\"https://orgo.space/#organization\"},\"isPartOf\":{\"@id\":\"https://orgo.space/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Orgo Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Orgo Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/platform/reports.md","siteName":"Orgo Documentation","nav":{"global":{"anchors":[]},"tabs":[{"tab":"Documentation","groups":[{"group":"Home","pages":[{"title":"Welcome to Orgo","href":"/platform"}]},{"group":"Setup Templates","pages":[{"title":"Setup Templates","href":"/platform/templates/index"},{"title":"Orgo for federations and multi-tier organizations","href":"/platform/templates/federations"},{"title":"Orgo for political parties","href":"/platform/templates/political-party"},{"title":"Orgo for fundraising","href":"/platform/templates/fundraising"},{"title":"Orgo for member communication","href":"/platform/templates/communication"},{"title":"Orgo for scouting and youth organizations","href":"/platform/templates/scouting"}]},{"group":"Organization","pages":[{"title":"Organization Settings","href":"/platform/organisation/index"},{"title":"Organization Info","href":"/platform/organisation/organisation-info"},{"title":"Branding","href":"/platform/organisation/branding"},{"title":"Custom Domain","href":"/platform/custom-domain"},{"title":"Website Builder","href":"/platform/organisation/website-builder"},{"title":"Modules","href":"/platform/organisation/modules"},{"title":"Usage \u0026 Billing","href":"/platform/usage-billing"},{"title":"Activity Log","href":"/platform/logs"},{"title":"Insights \u0026 Ask Orgo","description":"Ask questions about your organisation in plain language, and read the built-in analytics dashboards","href":"/platform/insights"},{"title":"Reports","href":"/platform/reports"}]},{"group":"Users \u0026 Profiles","pages":[{"title":"Users \u0026 Profiles","description":"Set up registration, manage members, and handle the complete member lifecycle","href":"/platform/users/index"},{"title":"Member Profile","href":"/platform/users/member-profile"},{"title":"Adding Members","href":"/platform/users/adding-members"},{"title":"Registration Form","href":"/platform/users/registration-form"},{"title":"Profile Fields","href":"/platform/users/profile-fields"},{"title":"Profile Activity \u0026 Notes","href":"/platform/users/profile-activity"},{"title":"User Types \u0026 Roles","href":"/platform/users/user-types"},{"title":"Custom Fields","href":"/platform/users/custom-fields"},{"title":"Lists \u0026 Segments","href":"/platform/users/lists"},{"title":"Merging Duplicates","href":"/platform/users/merging-duplicates"},{"title":"Permissions","href":"/platform/permissions"},{"title":"Assigning Permissions","href":"/platform/permissions-assigning"},{"title":"Member Invitations","href":"/platform/users/invitations"},{"title":"Family Members","href":"/platform/users/family-members"},{"title":"Companies","href":"/platform/users/companies"},{"title":"Adhesion (Membership Applications)","href":"/platform/users/adhesion"},{"title":"Referral Program","href":"/platform/users/referral"},{"title":"Waitlist","href":"/platform/users/waitlist"},{"title":"User Statuses","href":"/platform/users/statuses"},{"title":"Troubleshooting Member Access","href":"/platform/users/troubleshooting-access"},{"title":"Privacy Settings","href":"/platform/users/privacy-settings"},{"title":"Professional Network","href":"/platform/professional-network"},{"title":"Identity Validation","href":"/platform/identity-validation"},{"title":"Resignation","href":"/platform/users/resignation"},{"title":"Deletion of Account","href":"/platform/users/deletion-of-account"}]},{"group":"Contacts","pages":[{"title":"Contacts","href":"/platform/contacts/index"},{"title":"The Contact Record","href":"/platform/contacts/record"},{"title":"Where contacts come from","href":"/platform/contacts/sources"},{"title":"Contacts and Money","href":"/platform/contacts/payments"},{"title":"Contacts and the newsletter","href":"/platform/contacts/newsletter"},{"title":"Contacts at Events","href":"/platform/contacts/events"},{"title":"Turning a Contact into a Member","href":"/platform/contacts/becoming-a-member"},{"title":"Contact Permissions \u0026 Data Protection","href":"/platform/contacts/permissions"}]},{"group":"Groups","pages":[{"title":"Groups \u0026 Teams","href":"/platform/groups/index"},{"title":"Main Group","href":"/platform/groups/main-group"},{"title":"Local Centers","href":"/platform/groups/local-groups"},{"title":"Units","href":"/platform/groups/units"},{"title":"Member Transfers","href":"/platform/groups/transfers"},{"title":"Role Groups","href":"/platform/groups/role-groups"},{"title":"Private Groups","href":"/platform/groups/private-groups"}]},{"group":"Communication","pages":[{"title":"Discussions","href":"/platform/discussion/index"},{"title":"Discussion Namespaces","href":"/platform/discussion/discussion-namespaces"},{"title":"Discussion Moderation","href":"/platform/discussion/moderation"},{"title":"Blocking Members","href":"/platform/discussion/blocking-members"},{"title":"Newsletter","href":"/platform/newsletter"},{"title":"Newsletter builder","href":"/platform/newsletter-builder"},{"title":"Newsletter signup widgets","href":"/platform/newsletter-widgets"},{"title":"Communication analytics","href":"/platform/communication-analytics"},{"title":"Notifications","href":"/platform/notifications"}]},{"group":"Emails","pages":[{"title":"Emails","href":"/platform/emails/index"},{"title":"System emails","href":"/platform/emails/system-emails"},{"title":"Email templates","href":"/platform/emails/email-templates"},{"title":"Email logs","href":"/platform/emails/email-log"},{"title":"Email lists","href":"/platform/emails/email-lists"}]},{"group":"Events","pages":[{"title":"Events","href":"/platform/events/index"},{"title":"Create Event","href":"/platform/events/create-event"},{"title":"Event Registration Forms","href":"/platform/events/registration-forms"},{"title":"Event Types and Statuses","href":"/platform/events/event-types"},{"title":"Event Templates","href":"/platform/events/event-templates"},{"title":"Event Ticketing","href":"/platform/events/ticketing"},{"title":"Public Event Page","href":"/platform/events/public-page"},{"title":"Sharing Events","href":"/platform/events/sharing"},{"title":"Event Attendance","href":"/platform/events/attendance"},{"title":"Speakers and Trainers","href":"/platform/events/speakers-trainers"},{"title":"QR Check-in","href":"/platform/events/check-in"},{"title":"Event Analytics","href":"/platform/events/analytics"},{"title":"Event Reports","href":"/platform/events/event-report"},{"title":"Annual Event Report","href":"/platform/events/annual-report"},{"title":"Event App","href":"/platform/events/event-app"},{"title":"Event App Program, Feed and Votes","href":"/platform/events/event-app-feed"},{"title":"Event App Networking","href":"/platform/events/event-app-networking"}]},{"group":"Projects \u0026 Work","pages":[{"title":"Projects","href":"/platform/projects"},{"title":"Tasks","href":"/platform/tasks"},{"title":"Forms","href":"/platform/forms"},{"title":"Workflows","href":"/platform/workflows"}]},{"group":"Payments \u0026 Fees","pages":[{"title":"Products","href":"/platform/fees/products"},{"title":"Membership Fees","href":"/platform/fees/fees"},{"title":"Recording a Payment Made Outside Orgo","href":"/platform/fees/record-payment"},{"title":"Invoices","href":"/platform/fees/invoices"},{"title":"VAT \u0026 Registration Fees","href":"/platform/fees/vat"},{"title":"Cancelling \u0026 Correcting Invoices","href":"/platform/fees/cancelling-invoices"},{"title":"Renewals \u0026 Reminders","href":"/platform/fees/renewals"},{"title":"Stripe Integration","href":"/platform/fees/stripe-integration"},{"title":"Donations","href":"/platform/fees/donations"},{"title":"Donation Pages \u0026 Widgets","href":"/platform/fees/donation-pages"},{"title":"Chapter Fees","href":"/platform/local-group-fees/create-local-fees"},{"title":"Member Fees Table","href":"/platform/local-group-fees/member-fees"}]},{"group":"Governance","pages":[{"title":"Organizational Chart","href":"/platform/organisational-chart"},{"title":"Official Gazette","href":"/platform/official-gazette"},{"title":"E-Voting","href":"/platform/e-voting"}]},{"group":"Resources","pages":[{"title":"Files \u0026 Documents","href":"/platform/files"},{"title":"E-Document Templates and Signing","href":"/platform/contracts"},{"title":"E-Document Records and Legal Weight","href":"/platform/e-documents"},{"title":"Badges","href":"/platform/badges"},{"title":"Gamification","href":"/platform/gamification"},{"title":"Courses","href":"/platform/courses"}]},{"group":"Support","pages":[{"title":"Issues","href":"/platform/issues"},{"title":"Help Desk","href":"/platform/help-desk"},{"title":"Orgo Support","href":"/platform/orgo-support"}]},{"group":"Customization","pages":[{"title":"Customization","href":"/platform/customization/index"},{"title":"Languages","href":"/platform/customization/languages"},{"title":"Texts (label replacements)","href":"/platform/customization/labels"},{"title":"Menu Organizer","href":"/platform/customization/menu-organizer"},{"title":"Dashboard Builder","href":"/platform/customization/dashboard-organizer"},{"title":"Dashboard Welcome","href":"/platform/customization/dashboard-welcome"},{"title":"Data Import","href":"/platform/customization/import/index"},{"title":"Preparing your file","href":"/platform/customization/import/preparing-your-file"},{"title":"Mapping Columns","href":"/platform/customization/import/mapping-columns"},{"title":"Custom fields in an import","href":"/platform/customization/import/custom-fields"},{"title":"Linking Records","href":"/platform/customization/import/linking-records"},{"title":"Import Type Reference","href":"/platform/customization/import/reference"},{"title":"Mobile Apps","href":"/platform/mobile-apps"}]},{"group":"Developers","pages":[{"title":"Integrations","href":"/platform/integrations"},{"title":"Single Sign-On","href":"/platform/single-sign-on"},{"title":"API Access","href":"/platform/api"},{"title":"Webhooks","href":"/platform/webhooks"},{"title":"Orgo MCP","href":"/platform/mcp"},{"title":"OAuth Server","href":"/platform/oauth"}]}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/concepts/authentication"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog"}]}]},"basePath":"","title":"Reports | Orgo","deploymentId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","buildId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-Cr7fyDws.js","lightbox-handle-r17bVUz3.js"]}