| Home > Synergy > Hints and tips > Reports |
 |
If you are on Synergy 1.4 this can be done with a single query
Report for each Patient wherePatient.Registration_Type = “Full GMS”with/without note where Note.Read_Code = “8B314” and Note.Start_Date > -15Mwith Authorisation where Authorisation.Current = Trueand Authorisation.Auth_Type = “Repeat”and authorisation.read_code not between “a” and “b” # topical medicines range and authorisation.read_code not between “x” and “y” # in case another exclusion needed and Authorisation.Count >= 4 ;