null

Applying Ad Hoc Reporting Filters in the New Izenda Interface

This article contains instructions for creating ad hoc reports in the new Izenda interface. In an ad hoc report, you can apply a range of filters to display only the data that you're interested in, and print, export or email the results. NOTE: The filters you apply using these instructions are not permanently saved. To permanently save changes as a custom report, use the report designer (click the pencil icon at the top of the page). Click here for instructions on using the powerful report design features. Reports that use the Izenda interface will automatically open in a mode where you can apply the most common filters like date range, amount, etc. In the following illustration, the default filter is by Purchase Date.

Default filter for a report

DefaultFilter

 

  1. To select or enter parameters for a filter, follow these steps:
  • If the filter displays a menu, click the displayed menu and select the desired information (see image below).
  • If the filter displays a field, enter the text or data (such as a date in mm/dd/yyyy format) that you want to apply.
  1. Click Update Results. Only the results that match your parameters will be displayed.

Changing the Purchase Date filter to Current Quarter

UsingFilter

To add a new filter, follow these steps:
  1. Click the blue + at the right of the existing filters. A new blank filter will be displayed.
  2. In the menu below the blue border, select the data field that you want to use in the filter.
  3. Hover the mouse over the blue filter, and click the Settings icon (a gear). The Filter Properties dialog box will be displayed.
  4. In the Filter Operator menu, select the operator for the filter. For example, if you’re setting a filter for Balance, you can select Is Greater Than to limit the results to those with a balance greater than the amount you enter.
  5. Click OK to return to the report.
  6. Enter or select data in the filters, and click Update Results

Adding a filter that applies to the Balance data field

AddingFilter

 

Setting the operator for the new Balance filter

SettingOperatorNewFilter

 

To modify an existing filter, follow these steps:

  1. Hold the mouse over the blue title bar, and click the Settings icon (the gear). The Filter Properties dialog box will be displayed (see above).
  2. In the Filter Operator menu, select the operator for the filter. For example, if you’re setting a filter for Balance, you can select Is Greater Than to limit the results to those with a balance greater than the amount you enter.
  3. Click OK to return to the report.
  4. Enter or select data in the filters, and click Update Results.
When the report shows exactly the data you want, use the icons at the top of the page to print the results, export the results in the format of your choice, or email the results.

 

Saving the updated results as an Excel document

SaveAsExcel

Related Articles

3 Ways to Maintain Quality Relationships With Your Donors
Behind every successful organization is a donor community that is passionate about your cause. A ...
Zoo Management Software: Choosing a Solution + 8 Top Picks
Zoo management systems are an integral part of zoos around the country and world. They serve as ...
Museum Software: FAQ + 12 Top Management Solutions for 2024
The term “museum management software” is often used in the context of museum archive and ...
The New and Improved Doubleknot: 3 Key Features for 2023
It’s no secret that the management of admissions-based organizations like museums, nature centers, ...
Mastercard's 4 New Recurring Payments Rules (and What They ...
In an ongoing initiative to drive continuity and transparency amongst merchants, customers, and the ...
5 Ticketing & Registration Tips for Experiential ...
Take a second to think about the first moment that your patrons’ “experience” with your business ...
Running Your Children's Museum: How Software Can Help
Picture this: It’s a sunny autumn morning, you’ve just opened your museum’s doors, and it’s only a ...
Building an Inclusive Museum Community: A Complete Guide
For as long as museums have existed, they’ve been essential to their communities. They do more than ...
6 Ticketing Software Features to Enhance Your Museum
What does a successful day at your museum look like? Perhaps it involves a number of group tours, ...
Planning Safe Programming for Your Community This Summer
Community programming will look different this summer, but that doesn’t mean it shouldn’t happen at ...