Create Custom Query Report

The Reports module allows the user to create custom reports for specific needs that are not met by using the default reports provided. 

Instructions

1. Access Reports > select a report category > select a report type that ends in "Search," e.g., Reports > Patients > Patient Search.
2. Click the + icon.
3. Select Add Report.
4. In the Name field, input a report name.
5. In the Access Roles field, select the User Roles from your practice that can have access to the report.
6. In the Available Fields section, click the arrows to expand the category and review all options available. 
7. Drag and drop Available Fields to the Search Criteria section. (This is the information you want pulled from the charts.) 
   • Additional fields become available (e.g., Operator, Comparison Values) after you have populated a Search Criteria. Complete the search criteria by selecting from the dropdown menu(s) and input text in Comparison Values, as needed.
8. Drag and drop Available Fields to the Result Fields. (These are the data points that display on your report.)
9. Drag and drop Available Fields to the Sort Fields. (This is how you want the data sorted and displayed on your report. If you need more than three fields, we recommend exporting to Excel.)
10. Click 'Save.' The report displays within the list of reports. 
11. Beside the newly created report, click the icon for Run Report.

Helpful Hints

• When learning to create custom queries, it might be beneficial to start with only a few search criteria and sort fields. Run the report to verify the data is the information you wanted and it is displaying in the way you intended. Then open the report and update the query with more search and sort fields. 
• If you run the report and a grid does not display, or, you run the report and a grid displays without data, verify the Search Criteria section is accurate. 
  • If you continue to have issues, we recommend you start with one search criteria and one sort criteria - run the report, and then continue to build from there in order to find the search criteria that is not pulling accurately. 
• See Example