cancel
Showing results for 
Search instead for 
Did you mean: 
aichclarke
Canine II

Treatments

I can get a list of patients who have received a certain treatment, can I get the date this treatment was received incorporated into this query?

0 Kudos
Reply
1 Reply
liamrushton
CS Dental Employee
CS Dental Employee

Re: Treatments

In Report Manager  click on New Report then click ‘Start’

Click the ellipsis and create a new query

Select Treatment Plan Items and click ‘Next’

Place a tick in ‘That have certain [attributes]’ and click on ‘Specify Attributes’

Add the attributes to be able to select the dates and patient code by ticking the ‘Ask’ column for each and choosing the appropriate ‘Operator’  also add the ‘Completed’ criteria  equal to Yes.  See below:

1.png

Finish and Save the query and then select it

Click ‘Next’ and then ‘Report Layout’

Click ‘Click here to edit report properties’

Choose whichever properties you need – see below:

2.png

The click OK, Finish and Save.

The final report should look something like this:

3.png

Note: This report will display Patient Codes, instead of patients Names.

 

Kind Regards
Liam Rushton