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

Treatment Query

I am trying to produce a report to ascertain how many fluoride applications each associate has performed in the last year.  I have set out the following query :

  • > Patients
  • > that have the following attributes
  • > Current is equal to 'Yes'
  • > Clinic is equal to 'X'
  •    registered dentist is equal to 'Y'
  • > who have had a [711]
  • > under scheme [nhs]
  • > after [1 year ago]

My query is not working !

Help please !

Edward Byrne.

Labels (1)
0 Kudos
3 Replies
CS Dental Employee
CS Dental Employee

Re: Treatment Query

 Good Afternoon Edward,

For this information, I would use the management reports section of R4. As this allows you to find out how many of a certain code (up to 10 at a time) a provider has completed.

Go to the main menu,

Select Utilities

Select Management Reports

At the top of the screen, Under Types, select "Treatments"
Select your first dentist, and put in your date range.
At the bottom under DPB put in "711"
Select Run report from the right-hand menu

Excel will load up and populate a graph which will give you the information you require.

hope that helps.

Kind regards

Canine II

Re: Treatment Query

That is great Liam,

Worked a treat.

I never even knew that feature was in utilities !


CS Dental Employee
CS Dental Employee

Re: Treatment Query

Your welcome, Glad I was able to help.

Kind Regards