7.61905cmOutside0true00.5cmtrue3030Simple50MPNet=Fields!Ethnic.Value25.75cmtrueOutside0truetruetrue2Pie23.75cmDefault=Sum(Fields!Count.Value)=Fields!Ethnic.Valuetrue6pttextbox1114.75cmtrue0.91429cmScheme Start by Actions and Ethnicity2.53968cm5.27645cm4true=Fields!Actions.Valuetextbox81trueTotal=Fields!Actions.ValueAscending=Fields!Actions.Value1.25cmSex3true=Fields!Sex.Valuetextbox4trueTotal=Fields!Sex.ValueAscending=Fields!Sex.ValueYEAR10true=Fields!YEAR.Valuetextbox69trueTotal=Fields!YEAR.Value0.53333cmMONTH8true=MONTHNAME(Fields!MONTH.Value)textbox77trueTotal=Fields!MONTH.Value0.53333cmEthnic6true=Fields!Ethnic.Valuetextbox55trueTotal=Fields!Ethnic.ValueAscending=Fields!Ethnic.Value0.53333cmMPNet0.91429cm11.60581cmtextbox311true2.66665cm0.53333cmtextbox22true=Sum(Fields!Count.Value)35.86905cm4dda5930-f485-49db-b210-b8eb1631df722.5cmSELECT Person.Sex, CASE WHEN LEFT(lookupngnet.dbo.zStaticData.Code, 1) = 2 THEN 'Maori' WHEN LEFT(lookupngnet.dbo.zStaticData.Code,
1) = 3 THEN 'Pacific' ELSE 'Other' END AS Ethnic, COUNT(DISTINCT Person.LastName + Person.FirstName + Record.ChartLabel)
AS Count, MONTH(PartyData.Column5) AS MONTH, YEAR(PartyData.Column5) AS YEAR, RecordData.SingleLineData AS Actions
FROM Person INNER JOIN
Record ON Person.PartyGUID = Record.SubjectGUID INNER JOIN
PartyData ON Person.PartyGUID = PartyData.PartyGUID AND NOT (PartyData.Column5 IS NULL) AND ISDATE(PartyData.Column5)
= 1 AND PartyData.Column5 > @StartDate AND PartyData.Column5 <= @EndDate AND
PartyData.SingleLineData LIKE @scheme INNER JOIN
RecordData ON Record.RecordGUID = RecordData.RecordGUID LEFT OUTER JOIN
lookupngnet.dbo.zStaticData ON Person.EthnicityID1 = lookupngnet.dbo.zStaticData.StaticDataID
WHERE (RecordData.EnteredDateTime >= @StartDate) AND (RecordData.EnteredDateTime <= @EndDate) AND
(RecordData.RemovedDate IS NULL) AND (NOT (RecordData.SingleLineData IS NULL))
GROUP BY Person.Sex, LEFT(lookupngnet.dbo.zStaticData.Code, 1), PartyData.Column5, RecordData.UseTypeID,
RecordData.SingleLineData
HAVING (RecordData.UseTypeID = 100019)
ORDER BY Year, Month=Parameters!StartDate.Value=Parameters!EndDate.Value=Parameters!scheme.ValueMPNetSystem.StringSexSystem.StringEthnicSystem.Int32CountSystem.Int32MONTHSystem.Int32YEARSystem.StringActions25.25cm11inen-US2.5cm29.7cm