Create a Custom Query Report
Select the Columns
Choose the Columns to display on the Report Output.
- Select the Columns button.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn44eefaa1b6a312c02bb05022a1af497e6b5e7ab6e39fcb9bbda79c2526ef3f99f771c42d77b098c5db38bd4cc31a7fbd?inline=true)
- Enter search word(s) in the Search field; or
- Use the Plus symbols to open a specific category.
- Select the columns.
- As you select columns, they will show in the Reorder Columns pane on the left.
- In the Selected Columns panel, deselect any items that are not needed as Columns.
- Rename the Columns Headings to appear as you want them on the report.
- Use the up-down arrow in the Reorder panel to drag and drop the columns to change how they will display on the report.
- Select Save (F2).
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn654078190d411f6e62ab923a21af7edb12fcdd94bf8407dce5785f997dbda49b767c7955c378e94f1625599d6a7da538?inline=true)
Select the Filters
- Select the Plus symbol beside "And" to add Filters.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsndd3a19bdbd69cb1163348dbe821b437698cc9718b0b1626232e6d16a3264c8e86037b89d2407a784f0ba2d4b8d95b328?inline=true)
- Use the Select Columns Panel to select a Filter to define the outcome of the Report; or
- Select the checkboxes from the lists below the Select Columns Panel.
- Repeat Step 1 and 2 until all pertinent Filters have been selected.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsnec2bc1a118c71d8f666a1f6177983bb697316c1a82eef3f3c60986af51c69f4402fcdb601826345237bcb22ac4da68fe?inline=true)
Or use the checkboxes to select the Filters under the specific categories.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn93c27886e0d989e3299f5df0dd5a82792cd122b18d2de7ec3600491aef1bf1be5a6297e9d6c3bb6d37f049511c25d0a3?inline=true)
- Enter or choose the Criteria for the Filters.
- Select the Run button.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn8a21b82b5db7c40a2d57c6ea4b6dd9aa0b5203f35fae19bb940156913361ed19ef456ebe7d58568367e1b844c2397395?inline=true)
Use a Date Range
In the Filter Criteria panel:
- Select the Plus icon.
- Select Procedure - DOS from the Selected Columns Panel or from the list.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn654078190d411f6e62ab923a21af7edb354f5f98bc195706ad60bb18dca4be6420228d0ec34cb6a8519d11455fa6fa2e?inline=true)
- For the first Date, choose Greater than or equal to.
- Enter the start date.
- For the second Date, choose Less than or equal to.
- Enter the end date.
- Select Run after you have finished choosing all of your criteria.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn44eefaa1b6a312c02bb05022a1af497e9a6cd00b83db9f81ef7243cf3378709660b096fd466a237acd3c907b8944e61c?inline=true)
Run a Self-Pay Patient Report using the Query Reports
- Select the Plus button before AND.
- Select Insurance (1) - ID.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn3f5e183ce3bf275954abceb9d4eca1635c688ec736e52de5d85799adc0c6155430e2156c63528e2658ad67662bb9eef5?inline=true)
- For Policy - Insurance(1) - ID, select Equals.
- Enter the word, Patient, in the Lookup field.
- Select Run after all other criteria have been chosen.
![](https://support.pmhelpcenter.com/galleryDocuments/edbsn39808cb25dfa2997f10fe3ab32bd1610d0d9ae14939e432fa4324ad240d72d1ce1668141b89c5825dde362cdf7f34c81?inline=true)