/* Open Receivables Aging — company totals only (DatawarehouseNCM) Crystal: OpenReceivablesAging.rpt with Pm-Output = 2 */ DECLARE @CorpCode varchar(15) = NULL; DECLARE @ParentRollup bit = 0; SELECT CASE WHEN @ParentRollup = 1 THEN f.ParentCompany ELSE f.CorpCode END AS CompanyKey, SUM(f.OpenAmount) AS OpenAmount, SUM(f.CurrentAmt) AS CurrentAmt, SUM(f.Days1To30Amt) AS Days1To30Amt, SUM(f.Days31To60Amt) AS Days31To60Amt, SUM(f.Days61To90Amt) AS Days61To90Amt, SUM(f.DaysOver90Amt) AS DaysOver90Amt, MAX(f.AsOfDate) AS AsOfDate FROM dbo.FactOpenReceivable f WHERE (@CorpCode IS NULL OR @CorpCode = '' OR f.CorpCode = @CorpCode OR (@ParentRollup = 1 AND f.ParentCompany = @CorpCode)) GROUP BY CASE WHEN @ParentRollup = 1 THEN f.ParentCompany ELSE f.CorpCode END ORDER BY CompanyKey;