My Health Record Reporting

1. Navigate to File >  QuickReports
2. From the Tables column, highlight the [CDA] table.
3. Select the Query button.
4. In the Available Fields column, expand the [CDA] table using the arrow/plus to the left.
5. Select the CreationDate field.
6. Set the Comparison as is greater than or equal to
7. In the Value box, enter the start date of your search in dd/mm/yyyy format.
8. Click the Add Line button.
9. Change the Comparison to is less than or equal to.
10. In the Value box, enter the end date of your search in dd/mm/yyyy format.
11. Click the Add Line button.
12. From Available Fields, select Type.
13. Set the Comparison to is equal to.
14. In the Value box, enter SHS.
15. Click the Add Line button.
16. From Available Fields, select SentToPCEHR.
17. Set the Comparison to is equal to.
18. For the Value, select True.
    At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4-18, however may need to change the dates for Steps 7 & 10. 
19. Select the Query button. This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should read There are X records in the current selection for the CDA table. If you would like to print or export additional details, please see the continued instructions below.
20. Select the Columns tab.
21. Expand [CDA] in the Database Fields list to move the Id field into the Report Columns list by double clicking or dragging the field. This will be unique for each record and is a good indication of the total number of records rather than the number of patients who may have had several records uploaded.
22. Expand PT_Id_Fk [Patient] to select FullName, or the fields for Firstname and Surname.
23. Add any other fields you feel are necessary for your report.
24. Select the Groups tab.
25. Highlight [CDA]Id.
26. Tick the options for Group Column Data & Show Grand Totals.
27. Select the Formats tab.
28. Highlight [CDA]Id and tick the option for Count on the right.

If you will run this report regularly, you can select the Save button in the bottom left. In the future, you can select this in place of Steps 21-27.

The report can be printed by selecting the Print button, or it can be exported to a program such as Excel by choosing Export and following the subsequent prompts to title and export the report.

1. Navigate to File >  QuickReports.
2. From the Tables column, highlight the [CDA] table.
3. Select the Query button.
4. In the Available Fields column, expand the [CDA] table using the arrow/plus to the left.
5. Select the DownloadedDate field.
6. Set the Comparison as is greater than or equal to.
7. In the Value box, enter the start date of your search in dd/mm/yyyy format.
8. Click the Add Line button.
9. Change the Comparison to is less than or equal to.
10. In the Value box, enter the end date of your search in dd/mm/yyyy format.
    At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4-10, however may need to change the dates for Steps 6 & 9.
11. Click the Query button. This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should read There are X records in the current selection for the CDA table. If you would like to print or export additional details, please see the continued instructions below.
12. Select the Columns tab.
13. Expand [CDA] in the Database Fields list to move the Id field into the Report Columns list by double clicking or dragging the field. This will be unique for each record and is a good indication of the total number of records rather than the number of patients who may have had several records uploaded.
14. Expand PT_Id_Fk [Patient] to select FullName, or the fields for Firstname and Surname.
15. Add any other fields you feel are necessary for your report.

Note: This report can also be run via Open > Patients, then navigating to Records > Search to continue from Step 4.

1. Navigate to File > QuickReports.
2. From the Tables column, highlight the [HIAudit] table.
3. Click on the Query button.
4. In the Available Fields column, expand the [HIAudit] table using the arrow/plus to the left.
5. Select the IHIStatusNew field.
6. Set the Comparison as is equal to.
7. In the Value box, enter Active
8. Click the Add Line button.
9. Select the HIWSOperation field.
10. Set the Comparison as is equal to.
11. In the Value box, enter searchIHI.
    At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4 - 11.
12. 12. Click the Query button. This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should rea There are X records in the current selection for the HIAudit table. If you would like to print or export additional details, please see the continued instructions below.
13. Select the Columns tab.
14. Expand [HIAudit] in the Database Fields list to move any required fields into the Report Columns list by double clicking or dragging the field.
15. Expand PT_Id_Fk [Patient] to select FullName, or the fields for Firstname and Surname.
16. Add any other fields you feel are necessary for your report.

If you will run this report regularly, you can select the Save button in the bottom left. In the future, you can select this in place of Steps 13-16.

The report can be printed by selecting the Print button, or it can be exported to a program such as Excel by choosing Export and following the subsequent prompts to title and export the report.

Note: This report can also be run via Open > Patients, then navigating to Records > Search to continue from Step 4.

1. Navigate to File > QuickReports.
2. From the Tables column, highlight the [Patient] table.
3. Click on the Query button.
4. In the Available Fields column, expand the [Patient] table using the arrow/plus to the left.
5. Select the IHI field.
6. Set the Comparison as is greater than.
7. In the Value box, enter 0 (zero).
   At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4-7.
8. Click the Query button. This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should read There are X records in the current selection for the Patient table. If you would like to print or export additional details, please see the continued instructions below.
9. Select the Columns tab.
10. Expand [Patient] in the Database Fields list to move any required fields into the Report Columns list by double clicking or dragging the field.
11. Expand PT_Id_Fk [Patient] to select FullName, or the fields for Firstname and Surname.
12. Add any other fields you feel are necessary for your report.

If you will run this report regularly, you can select the Save button in the bottom left. In the future, you can select this in place of Steps 9-12.

The report can be printed by selecting the Print button, or it can be exported to a program such as Excel by choosing Export and following the subsequent prompts to title and export the report.

Note: This report can also be run via Open > Patients, then navigating to Records > Search to continue from Step 4.

1. Navigate to File > QuickReports.
2. From the Tables column, highlight the [Patient] table.
3. Click on the Query button.
4. In the Available Fields column, expand the [Patient] table using the arrow/plus to the left.
5. Select the IHI field.
6. Set the Comparison as is less than.
7. In the Value Box, enter 1.
   At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4 - 7.
8. Click the Query button.
   This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should read There are X records in the current selection for the Patient table. If you would like to print or export additional details, please see the continued instructions below.
9. Select the Columns tab.
10. Expand [Patient] in the Database Fields list to move any required fields into the Report Columns list by double clicking or dragging the field. You may wish to add fields for FullName, or the fields for Firstname and Surname.
11. Add any other fields you feel are necessary for your report.

If you will run this report regularly, you can select the Save button in the bottom left. In the future, you can select this in place of Steps 9 - 11.

The report can be printed by selecting the Print button, or it can be exported to a program such as Excel by choosing Export and following the subsequent prompts to title and export the report.

Note: This report can also be run via Open > Patients, then navigating to Records > Search to continue from Step 4.

1. Navigate to File > QuickReports.
2. From the Tables column, highlight the [PCEHRRegisterAudit] table.
3. Click on the Query button.
4. In the Available Fields column, expand the [PCHERRegisterAudit] table using the arrow/plus to the left.
5. Select the RequestDate field.
6. Set the Comparison as is greater than or equal to.
7. In the Value box, enter the start date of your search in dd/mm/yyyy format.
8. You may optionally set an end date by choosing the Add Line button, changing the Comparison to is less than or equal to and entering the Value as the end date.
   At this stage, you can choose the Save button in the top right of the window to save your query for future use. This will be saved onto your computer, so it is recommended you choose a location where you can find it next time and won’t be accidentally deleted. Next time you run this report, you select Load and choose the file in place of Steps 4-8.
9. Click the Query button. This will return you to the Report Builder window, and you can determine the number of results from the text above the Query button, which should read There are X records in the current selection for the PCEHRRegisterAudit table. If you would like to print or export additional details, please see the continued instructions below.
10. Select the Columns tab.
11. Expand [PCEHRRegisterAudit] in the Database Fields list to move any required fields into the Report Columns list by double clicking or dragging the field.
12. Expand PRFUSR_Id_Fk [Preference] to select FullName to identify the user.
13. Expand PT_Id_Fk [Patient] to select FullName, or the fields for Firstname and Surname.
14. Add any other fields you feel are necessary for your report.

If you will run this report regularly, you can select the Save button in the bottom left. In the future, you can select this in place of Steps 10-14.

The report can be printed by selecting the Print button, or it can be exported to a program such as Excel by choosing Export and following the subsequent prompts to title and export the report.