What else is on the report? Are there calculations, Domain Aggregate functions, etc.?
Yes. This is the query that runs the report:
SELECT Format(Avg(([SumOfTuition]-[SumOfAid]-[SumOfAmount])),'$#,#00') AS AvgFamilyContribution, Format(Avg([CountOfStudent ID]),'Fixed') AS AvgChildren, Format(Avg([Income]),'$0,000') AS AvgIncome, Format(([AvgFamilyContribution]/[AvgChildren]),'$#,#00') AS AvgChildContribution, Sum([qSum of Amounts by Family].[CountOfStudent ID]) AS Students, [qHomeschool Avg Last Year].AvgOfSumOfAmountPaid AS HomeAvg, Format(Sum([SumOfAmount]),'$0,000') AS [Total Money], Format(([Total Money]/([Students]-[HomeKids])),'$#,#00') AS AvgScholarship, tDatabaseLookup.RegionName, [qSum of Amounts by Family].GuardYear, tCustomization.ElemCap, tCustomization.SecCap, [qAverages from Last Year].AvgOfTuition, [qAverages from Last Year].AvgOfAmount, [qAverages from Last Year].AvgOfIncome, Sum([qSum of Amounts by Family].HSTuition) AS HSTuitionTotal, Sum([qSum of Amounts by Family].ElemTuition) AS ElemTuitionTotal, Sum([qSum of Amounts by Family].HSAmount) AS TotalHS, Sum([qSum of Amounts by Family].ElemAmount) AS TotalElem, Sum([qSum of Amounts by Family].HSKids) AS HSKidsTotal, Sum([qSum of Amounts by Family].ElemKids) AS ElemKidsTotal, Sum([HomeHSKids]+[HomeESKids]) AS HomeKids, Sum([qSum of Amounts by Family].Siblings) AS SumOfSiblings, Sum([qSum of Amounts by Family].Returning) AS SumOfReturning, Sum([qSum of Amounts by Family].AtCap) AS SumOfAtCap, Format(Sum([SumOfTuition])/([Students]-[HomeKids]),'$#,#00') AS AverageTuition, 'All Funding Types' AS Funding, 12 AS UpperGrade, 0 AS LowerGrade
FROM [qSum of Amounts by Family], [qAverages from Last Year], [qHomeschool Avg Last Year], tCustomization INNER JOIN tDatabaseLookup ON tCustomization.DatabaseID = tDatabaseLookup.LetterCode
GROUP BY [qHomeschool Avg Last Year].AvgOfSumOfAmountPaid, tDatabaseLookup.RegionName, [qSum of Amounts by Family].GuardYear, tCustomization.ElemCap, tCustomization.SecCap, [qAverages from Last Year].AvgOfTuition, [qAverages from Last Year].AvgOfAmount, [qAverages from Last Year].AvgOfIncome;
