---
title: "How to Run a Report"
canonical: "https://support.inphonite.com/space/KBPUB/77463576/How%20to%20Run%20a%20Report"
format: markdown
---
## Introduction

Reports can display a range of very useful details, from just your patients' names and contact information, to a list of itemized reminder results. Each report can be customized to ensure you’re able to fully realize the potential of your reminder service.

During the implementation process, condensed results reports are configured to be sent to you automatically. There are also other types of reports that can be run ad-hoc, to show information such as credit usage or even upcoming appointments. 

## Instant Reporting

If all that is needed are the results of messages completed yesterday or messages completed today, there are options for both of those on the home screen of Inphonite, under Monitor.

![image-20240604-193733.png](media://e59cd2af-cae1-4091-b42a-77fc59a7e24c)

## How to Run a Custom Report

To begin, select *Run a Report* in the side menu or the *Run a Report* icon in the third row, “Reporting” on the Dashboard.


#### Choose a Type of Report

There should now be a screen with a header of *View Reports* with options below.

![image-20240604-194037.png](media://bc4f051b-0ef7-4a3d-9f44-4ab8816f3451)

Click on the first drop-down menu called *Report* to view the types of reports that can be chosen.

To see the layout of each report type, take a look at [this page](https://support.inphonite.com/space/KBPUB/962691106/Report+Types).

| **Report Type:** | **Description:** |
| --- | --- |
| Account Usage | How many credits have been used during the specified time period |
| Account Usage By Account | Used by accounts that have a passthrough model (Not used in a normal circumstance) |
| Account Usage by Location | Find the amount of credits used broken up by location (Not by "Location Code" or "Appointment Custom Field 2") |
| Appointment Custom Fields by Result | View the reports sorted by the final result with the data from Appointment Custom Fields 1 through 5. |
| Call Tally by Status | View each of the statuses from the date range in a bar graph form with the number of each below |
| Condensed Results | View the list of patients contacted in a date range. This option has filters that allows you to choose the how the reports are organized in date/time modified by default |
| Condensed Results by Appointment | View the list of patients contacted in a date range organized by their appointment date ascending order |
| Condensed Results by Name | View the list of patients contacted in a date range organized by their last name, first name ascending order |
| Condensed Results by Result | View the list of patients contacted in a date range organized by their status ascending order |
| Contact List | All patients that have been imported with their primary number, mobile number, source key, date of birth |
| Do Not Contact | A List of all Patients that were added to the do not contact list |
| Duplicate Numeric Identifier | Displays a list of patients with duplicate numeric identifiers (If your patients have the ability to log in for special messages) |
| Full Results | Lists the results for all attempts by the date\time in descending order modified with the options to customize what order the data appears in |
| Results by Appointment | Report with for each patient by appointment date/time in ascending order with each attempt and status listed |
| Results by Message | Report with for each patient (ascending from last name) and all statuses associated with this contact all messages are grouped together |
| Results by Name | Report with each patient (ascending from last name) and all statuses associated with this contact grouped by the name of the patient |
| Results by Rule | Report with each status for each attempt categorized by the rule name in alphabetical order |
| Results by Status | All of the statuses that appeared on the report for each of the attempts |
| Retrieved Messages | View who called in to receive their assigned message (Customer Called in for Lab results for example) |
| Survey Results | View results for a selected survey |
| Unretrieved Messages | View who did not call in to receive their assigned message (Customer Called in for Lab results for example) |
| Upcoming Appointments | View the list of all appointments that have been imported into Inphonite from the time you run the report going forward |

#### Choose a Date Range

After the type of report has been chosen, choose the start date and end date of when the messages were sent. These options are the dates for all correspondence related to that message. If a reply is sent after the reports are generated, there will not be an additional report sent

> ℹ️ These dates <u>DO NOT</u> represent the dates of the appointments unless calls are made on the same day of the appointment.

#### Choose Filters

If *Filter* is available for the style of reports chosen, there will be a drop-down menu with each of the 10 Appointment Custom Fields and 10 Contact Custom Fields as well as Type, Group, and Provider. Once the filter is selected, the search option will allow you to choose from what data has been imported. 

First, the field that is to be filtered needs to be selected. 

![image-20240604-194121.png](media://718a0fcb-58cc-433c-a94c-c87b6de5208f)

Once that field has been selected, click the magnifying glass which will show all data from that field that has been imported. 

> ℹ️ ***NOTE:**** Appointment Custom Fields 1, 2, and 3 are defaulted to *<u>*Provider code*</u>*, *<u>*Location Code*</u>*, and *<u>*Reason Code*</u>*. If the *<u>*Status*</u>* filter is selected, each status will need to be typed in manually.*

#### Using Filter Expressions

> ⚠️ **FOR ADVANCED USERS: **Filter Expressions are based on C#. These allows one to customize the reports with as many filters as one could imagine.

| **Filter Expression** | **Description** |
| --- | --- |
| (AppointmentCustomField# = "VALUE") | Show only entries that have "VALUE" in Appointment Custom Field |
| (AppointmentCustomField# <>"VALUE") | Show a report with all entries except "VALUE" in the Appointment Field specified |
| (ContactCustomField# = "VALUE") | Show only entries that have "VALUE" in Custom Custom Field |
| (ContactCustomField# <> "VALUE") | Show a report with all entries except "VALUE" in the Contact Custom Field specified |
| (RuleName = "VALUE") | Show only entries that have "VALUE" as the Rule Name |
| (RuleName <> "VALUE") | Show a report with all entries except "VALUE" as the Rule Name |
| StartDate > DateTime.Parse("MM/dd/yyyy h:mm tt") | Show only the appointments earlier than a specific time [UTC Time Zone](https://en.wikipedia.org/wiki/List_of_UTC_time_offsets) |
| StartDate < DateTime.Parse("MM/dd/yyyy h:mm tt") | Show only the appointments later than a specific date and time. The dates and times need to be the [UTC Time Zone](https://en.wikipedia.org/wiki/List_of_UTC_time_offsets) |

Each of these filter expressions can be mixed and matched with "AND/OR" for example (AppointmentCustomField# <> "VALUE") AND (RuleName = "VALUE") 


#### Using Sorting Reports

If the type of chosen report allows for Sorting, reports can be sorted by each of the available columns in both directions.

![image](media://053141f7-a026-4b64-a987-5b5c7bfeb27c)


|  |  |
| --- | --- |
| **Sort Type** | **Description** |
| NONE | Self-explanatory, but no sort |
| [APPT] Custom Field 1 through [APPT] Custom Field 10 | Sort by data entered into one of the Appointment Custom Fields. NOTE: Appointment Custom Fields 1, 2, and 3 are defaulted to <u>Provider code</u>, <u>Location Code</u>, and <u>Reason Code</u>. |
| [Contact] Custom Field 1 through [Contact] Custom Field 10 | Sort by data entered into one of the Contact Custom Fields |
| Appointment Date/Time | Sort by appointment start date and appointment start time |
| Appointment Subject | Sort by subject name |
| Attempt Data | Organizes the phone numbers or email addresses in order |
| Attempt Name | Sorts the report by the LASTNAME, FIRSTNAME |
| Attempt on Date | Sorts the report by the date the notification was attempted |
| Attempt Try Number | Sorts by the report by the number of attempts |
| Message Name | Sorts the report by the name of the message played for the patient |
| Modified on Date | Sorts by the date the patient record was modified |
| Notification Method | Groups patients on the reports by who received an email, who received a text, and who received a phone call. |
| Provider | Groups patients by their provider (Does not look at Appointment Custom Field 1 or Provider Code) |
| Result Code | Groups the patients based on each status. It is recommended to sort by this using a condensed report. |
| Rule Name | Sorts the report by the rule that the message went out under. |

## Report Menu

Once the type of report has been chosen, along with any customizations, the reports can either be viewed in the browser or downloaded as a PDF.

![image-20240604-194224.png](media://4c549e55-4fb7-4602-b7f4-dce99701e880)

The formats available to download the reports are:  
[•Acrobat (PDF) file](https://en.wikipedia.org/wiki/Portable_Document_Format)  
[•CSV](https://en.wikipedia.org/wiki/Comma-separated_values)

[•HTML](https://en.wikipedia.org/wiki/HTML)

## Related Articles

- [Report Types](https://support.inphonite.com/space/KBPUB/962691106/Report+Types)

---

# Support

If you are unable to find answers to your questions, our Technical Support Department is here to help.

**Contact Us:**

- **Email:** [support@inphonite.com](mailto:support@inphonite.com) to open a support ticket.

**Support Hours:**

- **Eastern Time:** 9:00 AM - 6:00 PM
- **Pacific Time:** 6:00 AM - 3:00 PM
- **Days:** Monday through Friday

All requests will be responded to within one business day. Our Technical Support team addresses requests in the order they are received. Customers with Elite support will be prioritized and attended to by the next available Support Technician.

**PLEASE NOTE:** Before contacting our Technical Support Team, please review our article [Before You Contact Support](https://support.inphonite.com/space/KBPUB/56950798/Before+You+Contact+Support).

For more tips and useful information check out our other resources**:**  
● [Inphonite Blog](https://www.inphonite.com/resources/blog) ● [News](https://www.inphonite.com/resources/news) ● [YouTube](https://www.youtube.com/user/inphonite)