Introduction

How to use reports and search views (Webinar Video)

The Reports system is a search engine that is a great way to filter information stored on your eKeeper CRM. 

Perhaps you want to view all cases that have been administered by a certain person, or view all cases that completed during a specific time period. Once you have the information you want, perhaps you would like to export that to an excel spreadsheet. All of this is done through eKeeper's Reports. 

For a quick start walkthrough example, continue reading on. For a more in-depth guide to Reports click here.

How to produce a simple Report..

Product Groups

• To start, click on the Reports button, found on the homepage. 

• Do you wish to search by a product type, customers or more broadly across all cases. Click on the corresponding icon to do so. 

• For this example we want to search our Residential Products, so after clicking the icon, we can select the criteria for our search.

Set Criteria

As an example:

• We want to produce a report on all residential cases that are against a particular stage. 

• Click on the dropdown box, next to the field: Stage. Select a stage. 

• On the bottom left of the screen, click the Search button.

Display the results - Search View

• This will bring you to the results page, showing all Residential Cases that are against the stage we specified. 

• Let's decide that we want to export the property details of these cases to an excel spreadsheet.

• near the top right of the page is a field labelled: Search View. Click the dropdown box, and select the option: Property Details.

• You will notice the page refresh and the property details of our cases to be displayed. 

• Search Views are the fields of information your report will show, you can create your own custom Search Views based on the information relevant to what you need. This is done under System Settings >> Search Views

• To export this information to excel, click on the link near the bottom left of our results named: Select All.

• Finally, click on the button labelled: Export to Spreadsheet.

Your data will now be in an excel spreadsheet, ready for you to format, as you wish.

Export to Excel

• Select a Search View - the bottom bar does not appear for ‘Cases’

Saved Searches

Top Tip!

If you have produced a report that you would like to run again in the future, you can save time by clicking the Save Search Criteria link. So when you wish to produce that report, it will be just a click away.

• With a Saved Searches you specify criteria, you can also specify a desired search view which will display the results. This is found at the bottom of the criteria page.