d122bb09-a9be-4beb-b75b-fdbc9248dd08SQLData Source=ASHWIN;Initial Catalog=MPNetMD111inStringtrueStaff CodeStringtrueStart Date (YYYY-MM-DD)StringtrueEnd Date (YYYY-MM-DD)true8.5in0.25cmtrue2.5cm2.5cm2.5cm3278947b-3b06-4c27-869b-e47df37aabb821cmFirstNameSystem.StringLastNameSystem.StringShortCodeSystem.StringApptCountSystem.Int32MPNetMD1SELECT p.FirstName, p.LastName, u.ShortCode, count(*) as ApptCount
FROM Appointment a
JOIN Record r ON a.refGUID = r.SubjectGUID
LEFT OUTER JOIN [dbo].[User] u ON a.WithGUID = u.PartyGUID
INNER JOIN Patients p ON p.partyGUID = r.SubjectGUID
WHERE a.AppointStartDate > @StartDate
AND a.AppointEndDate < @EndDate
AND a.RefGUID <> '00000000-0000-0000-0000-000000000000'
AND r.PreferredPractitionerGUID <> '00000000-0000-0000-0000-000000000000'
AND r.PreferredPractitionerGUID =( SELECT TOP 1 partyGUID
FROM [dbo].[User]
WHERE shortCode = @StaffCode
)
Group by u.ShortCode, p.firstname, p.lastname
ORDER BY FirstName, LastName ASC=Parameters!StartDate.Value=Parameters!EndDate.Value=Parameters!StaffCode.Valuetrue15cm1cmOutside0true2MPNetMD1true3030Simple500=Fields!ShortCode.Value1.25cmExplodedtrueOutside0truetruetruePie14cmDefault=Sum(Fields!ApptCount.Value)=Fields!ShortCode.ValueToptrue6pt8.5cm0.25cmtextbox114.75cm1true0.91429cmAppointments with other practitioners