Sorting Stored Procedures Report Columns

NextGen® Enterprise EHR Help

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

The Stored Procedure Data function is an advanced reporting feature. To use this function, you must have advanced knowledge of the NextGen database structure and SQL knowledge. If you have questions about using this function, contact your System Administrator. Select SP from the Report Filter Settings List. Note: Stored Procedures Reports are available for Enterprise-Level Reports ONLY. Report Filter Select whether you wish to filter on a Stored Procedure or a View. Select the Stored Procedure or the View from the list. Note: The "ngsprep_care_guidelines" is an SP report when run, pulls the record of all patients (in alphabetical order) due for clinical guidelines. Report Filter Setup any desired filters (Equals, Not Equals, Greater Than, Less Than, Like) for any of the available parameters. Select the Columns tab (in the pane not the Settings List). Report Filter Setup any desired filters (Equals, Not Equals, Greater Than, Less Than, Like) for any of the available Columns. To sort the

NextGen® Enterprise EHR Help

Select Patient Data for a Report

Open the Report Filter. From the Settings List in NextGen Report Filter: Patient window, select Patient. Report Filter Set up filters for the patient demographic data. To search for Gender, Zip, Race, and Ethnicity, select . Note: If you select more than one race for a patient, all the selected races appear for that patient when you generate the report. To filter by patient number, select a parameter from the Person Nbr list and enter the value. Select the patient's Risk Level as high, medium, or low, or select to do the following. Patient Risk Level Enter the search criteria such as, high, medium, or low. Select Search. Use the right arrow to move the status to the selected items pane. Select OK. The risk level appears in the Risk Level filter on the Patient tab. Select the type of patient status to include from the Patient Status list, or select . Patient Status Search Enter the search criteria such as, active, inactive, or deceased. Select Search. Move the status to the selected ite

NextGen® Enterprise EHR Help

Sorting Stored Procedures Report Columns

Starting with NextGen® Enterprise EHR 5.8.1, you can sort columns for Stored Procedures using the Sorting function. For specific steps, see Selecting Stored Procedure Data. Note: For step-by-step instructions on how to filter patient data, see to Selecting Patient Data Parent topic: Selecting and Sorting Report Columns

NextGen® Enterprise EHR Help

Selecting and Sorting Report Columns

When you open the Report Filter, the patient demographic columns display in the right pane. These are the default columns that you can select or clear prior to generating a report. You can further filter the patient demographic data by selecting specific parameters. Selecting Report Columns Select and Sort Columns Sorting Stored Procedures Report Columns Parent topic: Create and Use Custom Reports

NextGen® Enterprise EHR Help

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

The Stored Procedure Data function is an advanced reporting feature. To use this function, you must have advanced knowledge of the NextGen database structure and SQL knowledge. If you have questions about using this function, contact your System Administrator. Select SP from the Report Filter Settings List. Note: Stored Procedures Reports are available for Enterprise-Level Reports ONLY. Report Filter Select whether you wish to filter on a Stored Procedure or a View. Select the Stored Procedure or the View from the list. Note: The "ngsprep_care_guidelines" is an SP report when run, pulls the record of all patients (in alphabetical order) due for clinical guidelines. Report Filter Setup any desired filters (Equals, Not Equals, Greater Than, Less Than, Like) for any of the available parameters. Select the Columns tab (in the pane not the Settings List). Report Filter Setup any desired filters (Equals, Not Equals, Greater Than, Less Than, Like) for any of the available Columns. To sort the

NextGen® Enterprise EHR Help

Search for and Sort Patient Records in NextGen® Enterprise EHR

Open NextGen® Enterprise EHR. On the main toolbar, select Patient, enter search criteria in Patient Lookup, and then select Find. Matching people and patient records appear in the search results. Optional: To sort the results in ascending or descending order, select a column header. You can add or remove columns by right-clicking the column header and then selecting or clearing the checkbox. Optional: Select the down arrow next to Find, and then select Turn on Emergency Access or Turn off Emergency Access as needed. Select the correct patient record, and then select Open. Parent topic: Viewing Patient Information and Generating Charts

Sorting Stored Procedures Report Columns

Recommendations

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

Select Patient Data for a Report

Sorting Stored Procedures Report Columns

Selecting and Sorting Report Columns

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

Search for and Sort Patient Records in NextGen® Enterprise EHR

Sorting Stored Procedures Report Columns

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

Select Patient Data for a Report

Sorting Stored Procedures Report Columns

Selecting and Sorting Report Columns

Select Stored Procedure Data (Enterprise-level NextGen® Enterprise EHR Reports Only)

Search for and Sort Patient Records in NextGen® Enterprise EHR