What this does: Builds a report with the exact columns and filters you choose, then lets you save, export or act on the results.
Applies to: ChamberMaster (CM) and MemberZone (MZ) back office, for staff users with access to Reports.
Before you start: Decide which records you need (members, representatives, events, groups and so on) and which details to show for each.
Time needed: About 10–15 minutes for a first report. Saved reports run in seconds.
On this page
Open the Report Builder
Start from a template, a blank report or a report you saved earlier.
- Click Reports in the left-hand menu.
- In the Report Finder panel, find the Advanced Custom Report Builder heading. Then click one of these links:
- Start from a template: lists ready-made reports, such as Member & Rep Listing, Event Listing, Attendee Listing and Billing Pre-Check. To open one, click the run report arrow to the right of its name.
- Create a new report: opens a blank report.
-
Saved custom reports: lists the reports your staff have saved.
The ChamberMaster Report Builder page has three panels:
- Database Fields (left): every field you can report on, grouped by area.
- Selected Fields and Filter by Criteria/Conditions (center): your columns and filters. Results Preview sits below them.
- Menu (right): save, run, clear and export options.
Choose the columns for your report
Each field you add becomes a column in your results.
- In the Selected Fields panel, click [Add new column].
- Point to an area, then a sub-area, and click the field you want. For example, select Members, General, Company Name.
You can also drag a field from the Database Fields panel into Selected Fields. - Repeat for each column you need. Columns appear in your results in the order listed.
- To rename a column’s heading, click the field name and type a new title. Otherwise, the heading shows the full field path, such as “Members_General Company Name”.
-
To change a column, click its name to show its buttons. Point to a button to see its label:
- Sorting (left of the name): sorts the results by this column.
- Change to aggregate column: turns the column into a summary, such as a count or total, instead of one value per row.
- Delete: removes the column.
Checkpoint: Each field you chose is listed under Column Title (Click to Edit) in the Selected Fields panel.
Filter the records with conditions
Conditions limit the report to the records you need. Without them, the report includes every record.
- In the Filter by Criteria/Conditions panel, click [Add new condition].
- Select the field to filter on. For example, select Members, General, Membership Status.
- Click the comparison text (it starts as is equal to) and choose how to compare. The choices depend on the field. For a list field like Membership Status, you can choose is equal to, is in list, is not equal to or is not in list.
- Click [select value] and choose or enter the value. For example, choose Active.
- Add more conditions the same way.
Checkpoint: Your condition reads as a full sentence, such as “Membership Status is equal to Active”, with no [select value] left.
When you have more than one condition, click the word all in Select records where all of the following apply to choose how they combine:
| Option | Records included |
|---|---|
| all | Match every condition |
| any | Match at least one condition |
| none | Match no conditions |
| not all | Miss at least one condition |
Run and save the report
Run the report to check the results, then save it so you can run it again later.
- In the Menu panel, click Run Report. The Results Preview panel shows the row count and your data.
- Check the results. If they look wrong, adjust your columns or conditions and click Run Report again.
- Under Saved Reports, click the Save As button (the second of the three buttons; its label appears when you point to it).
- In the Report Name field, enter a name your team will recognize.
- To keep the report private, select Only visible to Me. Otherwise, other staff can open it.
- Click Save.
Checkpoint: Your report appears in the Saved Reports list in the Menu panel. It is also listed under Saved custom reports on the Reports page.
To update a saved report later, open it, make your changes and click the Save button (the first of the three buttons). To remove it, click the Delete button (the third). Click Clear to empty the builder and start over.
Export or act on the results
The links in the Menu panel use the results of the report you just ran. Run the report at least once before you use them.
- Export to Excel or Export to CSV downloads the results. CSV (comma-separated values) is a plain-text format most programs can open.
- Create Emails starts an email to the people in your results.
- Create Group adds the people in your results to a group.
- Nametags, Tent Cards, Envelopes, Labels & more using Word® Mail Merge sends the results to a Microsoft Word template. For details, see Create Mail Merge Documents From the Report Builder.
Common pitfalls
- Exporting before running: The export and action links show “Please run the report first.” Click Run Report, then try again.
- Overwriting a saved report: Saving with a name that already exists replaces that report. To keep the original, enter a new name in Save As.
- Leaving a value blank: A condition still showing [select value] won’t filter the way you expect. Choose a value or delete the condition.
- Missing RepID: Without the Representatives RepID field, Create Emails and Create Group won’t work.