CRM Software Custom Reports
Custom Reports to suit your business
CRM Software Reports
In Amphis Customer there are many Built-in Reports and you can also create Custom Reports to suit your business requirements.
We have hundreds of example custom reports you can use on our Amphis Software Forums - see links below.
Also these two reports are very popular...
Custom Report Builder
From the Reports->Custom Report Builder menu you can access the Custom Report Builder.
Create Custom Report
Here you can specify your own Custom Reports to suit your requirements. Click Create New Report to create a new report, give it a name, then select it from the drop-down list.
It will have some default Structured Query Language (SQL) statements like this...
SELECT companyname, lastname, firstname FROM customer
If you click Run Report, it will show you details for all customers from the Customer table in the database.
Click Save Report and a new menu for the custom report is automatically added to the Reports Menu under My Custom Reports.
Copy Example Custom Reports
If you're a techie and you know SQL, you can go ahead and modify the SQL statements to create your own custom report, but for most people it may be easier to copy some existing examples. The video below shows how you can do that.
For some help on understanding SQL statements see SQL Statements Help
CRM Database Table Design
For the techies, we have a slightly simplified database schema here to help you (with some of the lookup tables omitted).
And here are the lookup tables.
Or you can take a look at the database itself if you go to Tools->Folders->View Data Folder.
We have some Example Custom Reports below which you can simply copy and replace the default SQL. Then you need to click Save to save the custom report. You can then run the custom report from within the Custom Report Builder and it will also be available to run on the Reports->My Custom Reports menu.
There are hundreds of examples you can copy from the Custom Reports sections of the Amphis Software Forum
Custom Report Suggestions
If you have a suggestion for a custom report you would like to see created, please post the details on our forum here CRM Custom Report Suggestions
We look at the suggestions from time to time and create custom reports for free for some of the suggestions we feel would be the most useful to the most clients. We do not develop bespoke custom reports.
Example CRM Custom Reports
- Quotes not Invoiced
- Customer History
- Customers Not Contacted
- Customers Per Group
- Invoices Total for Today
- Sales Totals and Sales Taxes for this Month
- Supplier Invoices Total for this Month
- Recent Buyers
- Existing customers who have not purchased anything recently
- Invoices Total For This Year To Date
- Yearly Sales Totals
- Quotes and totals per Sales Person
SQL statements used in the standard reports
Sql Server Reports
Please note that most of the Custom Reports we have created on the Amphis Forum are created for use with the supplied Access Database File customer.mdb
If you have upgraded your Access database to a SQL Server database, some of the reports are not compatible with SQL Server because of differences in the SQL Query Syntax. We have information on some of the differences here SQL Server Query Syntax Differences and some example SQL Server Custom Reports here SQL Server Example Custom Reports
Amphis Customer CRM Software
We have some short CRM Videos about Amphis Customer CRM Software and also a CRM Quick Guide with more details and screenshots. We have Prices, Customer testimonials and CRM Software Case Studies or why not Download our CRM Software Free 60 Day Trial and try it for yourself ?
Web and Mobile access to your CRM Data
For information on Web and Mobile access to your CRM Data including using iPhone, iPad, Android, Mac, Windows Phone and other phones and tablets, see Web and Mobile access to CRM Data.