Basic Reporting Part I: Overview
Getting Started With Reports
- Fundly CRM comes with over 160 default reports as well as the ability to write your own custom reports.
- To access custom and default reports, click on Reports on the Main Menu. This will take you to the Reports index page.
- To open an existing report (default or custom report), click the page icon in the upper left to open the list of default and custom reports. Click the gray arrow to the left of the Default and/or NonProfitEasy (your custom reports) folder to navigate the list of reports.
- Default reports contact report categories (sub-folders). Click the gray arrow to the left of any category to open that sub-folder and reveal the list of reports in that folder.
- You can search for default and custom reports by typing keywords into the Search box at the top of the list of reports. Click the three dots on the right of the search box to open up the search options/to indicate whether you wish to search just the report titles or also the report descriptions.
- Prior to running any report, you can click ONCE on the report name/title to select the report and populate the Report Description box at the bottom of the list of reports.
- To run a report, click on the "play" button to the right of the report name OR click the three bars to the right of the report name and select Run from the contextual menu that opens up to run the report on the screen. (Please Note: If you get an error message that your session has timed out and that you need to contact your administrative whenever you attempt to run reports, it’s because you must enable third-party cookies in your browser in order to run reports. Please see this tutorial for more information.)
- You can Export the report (as PDF, Rich Text, CSV, or Excel) without first running it (or you can run it and then export it) by clicking the three bars to the right of the report name and selecting Export As and then selecting the desired format (you can also email it immediately to anyone you choose (including yourself) in the desired format by selecting Email Report from the menu or you can schedule the report to automatically run and email to anyone you want by selecting Schedule. See the Out of the Box Reporting webinar recording for more information scheduling reports).
- With some reports (if filters have been sent to "prompt on run"), when you click Run/run the report, a box will pop up allowing you to specify the report criteria you want. Enter any criteria that you want and then click Okay to finish running the report.
- For Advanced Reports Interface: Once you run the report on the screen, you can right click anywhere on the report to filter and conditionally format the report “on the fly” using the interactive HTML Viewer (see this tutorial for more information on the interactive HTML viewer). In this screenshot, we have right-clicked on the Charles Black's Donation Date. We now have the option to filter the report by donation date (or to conditionally format the donation date field; for example, we could highlight in yellow all donations made on the same date or made after May).
- You can also click on the four dots on the left to open up the Interactive Filters menu to filter and re-sort the report “on the fly” as well as hide or unhide columns (see the above linked tutorial on the Interactive HTML viewer for more information).
- You can search a report by typing what you are searching for in the Find field in the upper right hand corner.
To Create a New Report:
- First check the default reports; the report you need may already exist or there might be a default report you can use as a jumping off point for your custom report so that you do not need to start from scratch.
- If you would like to make changes to a default report (adapt it to your needs), you must make a copy of it. Click the three bars to the right of the report’s name and select Duplicate. This will allow you to copy the report to your custom reports folder and then edit it.
- If you need to create a new report from scratch, first check this tutorial on which report types do which things. We have several different reporting interfaces/tools, including Advanced Search, Express View report interface, Advanced View report interface, and Cross-Tab report interface. In general, Express View will be your “go to” choice for 80% of your reporting needs, but some reports can only be built using Advanced Search, the Advanced Reports interface, or the Cross-Tab Reports interface.
- To create a new Cross-Tab, Dashboard, Express View, or Advanced report, click the + button in the upper left and then select the type of report you want to create (see our tutorials on each report type for more details).
- To save your report, you must click on the gray arrow to the left of the Non-Profit Easy Folder name to open the list of sub-folders and then select/click on your organization’s name. That is the ONLY place you can save custom reports. If you receive a message that “folder is read only” you have not clicked in the correct place (hint: the only place you can save reports is the folder WITHOUT an icon of a lock next to it). In the screenshot below, the name of our organization is NPE Demo and that is the folder we have highlighted/selected to save our report to. It's the only one without a lock icon/the only one we can select.
- For complete instructions on how to create an Express View, Advanced, Crosstab, or Dashboard report, visit the Reports section of the support library and see those tutorials.