How to create a query report

 Top  Previous  Next

In this step by step, we will show how to create a treatment histogram. See Current repeat females chapter. The user question is:

 

I want to see a list of females with 2 or more services in the current parity. In this list, I would like to show female Id, status, service date and number of service.

 

Instructions to create the above report:

 

1.Click Reports.
2.Click New.
3.Double click Query.
4.Click Query sheet.

clip0003

5.Click Wizard button. The available tables appear in the right side of the screen.

dlg_button_sql_wizard

6.Drag and drop the FemaleEx table to use to left side.
7.In the field list box, select the fields that you want to see. In this example: ID, STATUSCODE, SERVDATE, NSERVICE.

clip0012

8.Click Criteria sheet.
9.Double click the first empty cell. The Expression builder should appear.
10.Enter the filter, in this example ISACTIVE=1 AND NSERVICE>1
11. Click Ok.

clip0013

12.Click Sorting sheet
13.Select the variable to sort, in this example ID.
14. Click Add.
15.Click Accept Query to close the wizard.
16.Click Preview button to see the report.
17.Click Save button to save the report.