11.25cmOutside0true00.25cmtrue55611MPNET=Fields!FirstName.Value & " " & Fields!LastName.Value1.25cmtrueOutside0truetruetrue2Line22.75cm=Fields!Year.Value=Fields!Year.ValueAscendingDefault=Sum(Fields!Fee.Value)textbox1112.69841cmtrue0.91429cmIncome2.25cm1cm0.25cm2.53968cmLastName5true=Fields!FirstName.Value & " " & Fields!LastName.Valuetextbox81trueTotal=Fields!LastName.Value4.5cmServiceTypeDescription4true=Fields!ServiceTypeDescription.Valuetextbox9trueTotal=Fields!ServiceTypeDescription.ValueAscending=Fields!ServiceTypeDescription.ValueYear9true=Fields!Year.Valuetextbox48trueTotal=Fields!Year.ValueAscending=Fields!Year.Value0.53333cm0.53333cmtextbox67trueAmounttextbox76trueNo.MPNET30.5cm13.53968cmtextbox510trueIncome by Services0.53333cmtextbox23true=Sum(Fields!Fee.Value)textbox32true=Sum(Fields!Quanity.Value)32.63332cm3222af3d-d8e5-4297-b16b-5c19034cff9e2.5cmSELECT Person.FirstName, Person.LastName, InvoiceLine.LineExtn, SUM(InvoiceLine.LineExtn) AS Fee, COUNT(*) AS Quanity,
SUM(InvoiceLine.OutstandingAmount) AS Unpaid, RTRIM(InvoiceLine.ServiceTypeDescription) AS ServiceTypeDescription,
MONTH(InvoiceLine.InvoiceLineDate) AS Month, YEAR(InvoiceLine.InvoiceLineDate) AS Year, Person.OccupationID, zStaticData_1.Description
FROM InvoiceLine INNER JOIN
Invoice ON InvoiceLine.InvoiceGUID = Invoice.InvoiceGUID INNER JOIN
Person ON Invoice.ProviderGUID = Person.PartyGUID LEFT OUTER JOIN
lookupngnet.dbo.zStaticData AS zStaticData_1 ON Person.OccupationID = zStaticData_1.StaticDataID
GROUP BY Person.FirstName, Person.LastName, InvoiceLine.LineExtn, InvoiceLine.OutstandingAmount, RTRIM(InvoiceLine.ServiceTypeDescription),
MONTH(InvoiceLine.InvoiceLineDate), YEAR(InvoiceLine.InvoiceLineDate), InvoiceLine.Status, InvoiceLine.RemovedDate, Person.OccupationID,
zStaticData_1.Description
HAVING (InvoiceLine.RemovedDate IS NULL) AND (InvoiceLine.Status IS NULL OR
LEN(InvoiceLine.Status) = 0) AND (InvoiceLine.LineExtn > 0) AND (YEAR(InvoiceLine.InvoiceLineDate) > 1990)
ORDER BY MONTH(InvoiceLine.InvoiceLineDate), YEAR(InvoiceLine.InvoiceLineDate)MPNETSystem.StringFirstNameSystem.StringLastNameSystem.DoubleLineExtnSystem.DoubleFeeSystem.Int32QuanitySystem.DecimalUnpaidSystem.StringServiceTypeDescriptionSystem.Int32MonthSystem.Int32YearSystem.Int32OccupationIDSystem.StringDescription23.5cm11inen-US2.5cm29.7cm