No Data AvailableReportName()Which dates:MONTHLYMonthly: the start of last month, plus 3 months aheadSetup: the last 24 months, plus 3 months aheadFrom a custom start date (then Next), plus 3 months aheadCustom: choose it, then click Next to pick the dates. Anything else: click OK.
NextOK
ReportName()The start date:2026-09-01
BackOK
/content/package[@name='eCWEBO']/model[@name='model']SELECT
u.RowType AS RowType,
u.C01 AS C01,
u.C02 AS C02,
u.C03 AS C03,
u.C04 AS C04,
u.C05 AS C05,
u.C06 AS C06,
u.C07 AS C07,
u.C08 AS C08,
u.C09 AS C09,
u.C10 AS C10,
u.C11 AS C11,
u.C12 AS C12,
u.C13 AS C13,
u.C14 AS C14,
u.C15 AS C15,
u.C16 AS C16,
u.C17 AS C17,
u.C18 AS C18,
u.C19 AS C19,
u.C20 AS C20,
u.C21 AS C21,
u.C22 AS C22,
u.C23 AS C23,
u.C24 AS C24,
u.C25 AS C25,
u.C26 AS C26,
u.C27 AS C27,
u.C28 AS C28,
u.C29 AS C29,
u.C30 AS C30,
u.C31 AS C31,
u.C32 AS C32,
u.C33 AS C33,
u.C34 AS C34,
u.C35 AS C35,
u.C36 AS C36
FROM (
SELECT
'CTL' AS RowType,
CAST('stamp' AS varchar(200)) AS C01,
CAST(CONVERT(varchar(16), GETDATE(), 120) AS varchar(200)) AS C02,
CAST(CONVERT(varchar(10), CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END, 120) AS varchar(200)) AS C03,
CAST(CONVERT(varchar(10), DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0), 120) AS varchar(200)) AS C04,
CAST('visits-6' AS varchar(200)) AS C05,
CAST(NULL AS varchar(200)) AS C06,
CAST(NULL AS varchar(200)) AS C07,
CAST(NULL AS varchar(200)) AS C08,
CAST(NULL AS varchar(200)) AS C09,
CAST(NULL AS varchar(200)) AS C10,
CAST(NULL AS varchar(200)) AS C11,
CAST(NULL AS varchar(200)) AS C12,
CAST(NULL AS varchar(200)) AS C13,
CAST(NULL AS varchar(200)) AS C14,
CAST(NULL AS varchar(200)) AS C15,
CAST(NULL AS varchar(200)) AS C16,
CAST(NULL AS varchar(200)) AS C17,
CAST(NULL AS varchar(200)) AS C18,
CAST(NULL AS varchar(200)) AS C19,
CAST(NULL AS varchar(200)) AS C20,
CAST(NULL AS varchar(200)) AS C21,
CAST(NULL AS varchar(200)) AS C22,
CAST(NULL AS varchar(200)) AS C23,
CAST(NULL AS varchar(200)) AS C24,
CAST(NULL AS varchar(200)) AS C25,
CAST(NULL AS varchar(200)) AS C26,
CAST(NULL AS varchar(200)) AS C27,
CAST(NULL AS varchar(200)) AS C28,
CAST(NULL AS varchar(200)) AS C29,
CAST(NULL AS varchar(200)) AS C30,
CAST(NULL AS varchar(200)) AS C31,
CAST(NULL AS varchar(200)) AS C32,
CAST(NULL AS varchar(200)) AS C33,
CAST(NULL AS varchar(200)) AS C34,
CAST(NULL AS varchar(200)) AS C35,
CAST(NULL AS varchar(200)) AS C36
FROM sys.tables t WHERE t.name = 'enc'
UNION ALL
SELECT
'CTL',
REPLACE(REPLACE(REPLACE(CAST('enc_month' AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CONVERT(varchar(10), x.M, 120),
CAST(CAST(x.T AS int) AS varchar(24)),
CAST(CAST(x.N AS int) AS varchar(24)),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM (
SELECT DATEADD(month, DATEDIFF(month, 0, e.date), 0) AS M, e.encType AS T, COUNT(*) AS N
FROM enc e
WHERE e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
GROUP BY DATEADD(month, DATEDIFF(month, 0, e.date), 0), e.encType
) x
UNION ALL
SELECT
'CTL',
REPLACE(REPLACE(REPLACE(CAST('rows_STH' AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CONVERT(varchar(10), CAST((CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AS date), 120),
CAST(CAST(x.N AS int) AS varchar(24)),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM (
SELECT COUNT(*) AS N FROM encstatushistory h JOIN enc e ON e.encounterID = h.encId AND e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
) x
UNION ALL
SELECT
'CTL',
REPLACE(REPLACE(REPLACE(CAST('rows_BKG' AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CONVERT(varchar(10), CAST((CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AS date), 120),
CAST(CAST(x.N AS int) AS varchar(24)),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM (
SELECT COUNT(*) AS N FROM encounterlog l JOIN enc e ON e.encounterID = l.encid AND e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0)) WHERE l.actiontype = 'Created'
) x
UNION ALL
SELECT
'CTL',
REPLACE(REPLACE(REPLACE(CAST('rows_INS' AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CONVERT(varchar(10), CAST((CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AS date), 120),
CAST(CAST(x.N AS int) AS varchar(24)),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM (
SELECT COUNT(*) AS N FROM insurancedetail d JOIN insurance i ON i.insId = d.insid WHERE d.DeleteFlag = 0 AND d.pid IN (SELECT e.patientID FROM enc e WHERE e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0)) AND e.encType = 1)
) x
UNION ALL
SELECT
'ENC',
CAST(CAST(e.encounterID AS int) AS varchar(24)),
CAST(CAST(e.patientID AS int) AS varchar(24)),
CONVERT(varchar(10), e.date, 120),
CASE WHEN e.startTime IS NULL OR CAST(e.startTime AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.startTime AS time), 108) END,
CASE WHEN e.endTime IS NULL OR CAST(e.endTime AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.endTime AS time), 108) END,
CAST(CAST(e.encType AS int) AS varchar(24)),
CAST(CAST(e.doctorID AS int) AS varchar(24)),
CAST(CAST(e.ResourceId AS int) AS varchar(24)),
CAST(CAST(e.facilityId AS int) AS varchar(24)),
CAST(CAST(e.visittypeid AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(e.VisitType AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(e.STATUS AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(e.visitstscodeid AS int) AS varchar(24)),
CAST(CAST(e.InvoiceId AS int) AS varchar(24)),
CAST(CAST(e.ClaimReq AS int) AS varchar(24)),
CAST(CAST(e.ClaimRequired AS int) AS varchar(24)),
CAST(CAST(e.readytobill AS int) AS varchar(24)),
CAST(CAST(CASE WHEN e.notesDoneTime > '1902-01-01' THEN 1 ELSE 0 END AS int) AS varchar(24)),
CAST(CAST(e.encLock AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(e.EncEligibilityStatus AS varchar(10)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(CASE WHEN e.EligSubId > 0 THEN 1 ELSE 0 END AS int) AS varchar(24)),
CAST(CAST(e.VisitCopay AS decimal(16, 2)) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(CASE WHEN LEN(LTRIM(RTRIM(ISNULL(u.zipcode, SPACE(0))))) >= 5 THEN LEFT(LTRIM(u.zipcode), 5) END AS varchar(5)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(CASE WHEN u.ptDob > '1901-01-02' AND u.ptDob <= e.date THEN CASE WHEN DATEDIFF(year, u.ptDob, e.date) - CASE WHEN DATEADD(year, DATEDIFF(year, u.ptDob, e.date), u.ptDob) > e.date THEN 1 ELSE 0 END >= 90 THEN 90 ELSE DATEDIFF(year, u.ptDob, e.date) - CASE WHEN DATEADD(year, DATEDIFF(year, u.ptDob, e.date), u.ptDob) > e.date THEN 1 ELSE 0 END END END AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(u.sex AS varchar(10)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(e.newPt AS int) AS varchar(24)),
CAST(CAST(e.refPrId AS int) AS varchar(24)),
CASE WHEN e.arrivedTime IS NULL OR CAST(e.arrivedTime AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.arrivedTime AS time), 108) END,
CASE WHEN e.timeIn IS NULL OR CAST(e.timeIn AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.timeIn AS time), 108) END,
CASE WHEN e.timeOut IS NULL OR CAST(e.timeOut AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.timeOut AS time), 108) END,
CASE WHEN e.depTime IS NULL OR CAST(e.depTime AS time) = '00:00:00' THEN NULL ELSE CONVERT(varchar(5), CAST(e.depTime AS time), 108) END,
REPLACE(REPLACE(REPLACE(CAST(pt.ControlNo AS varchar(20)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(bf.Fee AS decimal(16, 2)) AS varchar(24)),
CAST(CAST(bf.Lines AS int) AS varchar(24)),
CAST(CAST(bf.Unpriced AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(CASE WHEN LEN(LTRIM(RTRIM(ISNULL(u.ulname, SPACE(0))))) = 0 THEN NULL WHEN LEN(LTRIM(RTRIM(ISNULL(u.ufname, SPACE(0))))) = 0 THEN LTRIM(RTRIM(u.ulname)) ELSE LTRIM(RTRIM(u.ulname)) + ', ' + LTRIM(RTRIM(u.ufname)) END AS varchar(100)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' ')
FROM enc e
LEFT JOIN users u ON u.uid = e.patientID
LEFT JOIN patients pt ON pt.pid = e.patientID
LEFT JOIN (
SELECT bd.EncounterId AS EncId, COUNT(*) AS Lines,
SUM(CASE WHEN f.Fee IS NULL THEN 1 ELSE 0 END) AS Unpriced,
SUM(CASE WHEN bd.units > 0 THEN bd.units ELSE 1 END * f.Fee) AS Fee
FROM billingdata bd
JOIN enc e2 ON e2.encounterID = bd.EncounterId AND e2.deleteFlag = 0 AND e2.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e2.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
LEFT JOIN encdetail ed2 ON ed2.encounterID = bd.EncounterId
LEFT JOIN patients p2 ON p2.pid = e2.patientID
LEFT JOIN (
SELECT c.itemId AS ItemId, c.FeeSchId AS FeeSchId, MAX(c.Fee) AS Fee
FROM cptfeesch c
WHERE c.DeleteFlag = 0
GROUP BY c.itemId, c.FeeSchId
) f ON f.ItemId = bd.itemID AND f.FeeSchId = COALESCE(NULLIF(ed2.FeeSchId, 0), p2.DefFeeSchId)
WHERE bd.deleteFlag = 0
GROUP BY bd.EncounterId
) bf ON bf.EncId = e.encounterID
WHERE e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
UNION ALL
SELECT
'BKG',
CAST(CAST(l.id AS int) AS varchar(24)),
CAST(CAST(l.encid AS int) AS varchar(24)),
CONVERT(varchar(19), l.modifydate, 120),
CAST(CAST(l.userid AS int) AS varchar(24)),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM encounterlog l
JOIN enc e ON e.encounterID = l.encid AND e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
WHERE l.actiontype = 'Created'
UNION ALL
SELECT
'INS',
CAST(CAST(d.Id AS int) AS varchar(24)),
CAST(CAST(d.pid AS int) AS varchar(24)),
CAST(CAST(d.insid AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(i.insuranceclass AS varchar(20)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.copayType AS varchar(10)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(d.insOrder AS int) AS varchar(24)),
CAST(CAST(d.SeqNo AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(d.startDate AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.endDate AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.copays AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.PCPCoPay AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.SpecialistCoPay AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
REPLACE(REPLACE(REPLACE(CAST(d.OtherCoPay AS varchar(30)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
CAST(CAST(d.MultipleCoPay AS int) AS varchar(24)),
CONVERT(varchar(10), d.ptInsStartDate, 120),
CONVERT(varchar(10), d.ptInsEndDate, 120),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM insurancedetail d
JOIN insurance i ON i.insId = d.insid
WHERE d.DeleteFlag = 0 AND d.pid IN (SELECT e.patientID FROM enc e WHERE e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0)) AND e.encType = 1)
UNION ALL
SELECT
'STH',
CAST(CAST(h.id AS int) AS varchar(24)),
CAST(CAST(h.encId AS int) AS varchar(24)),
CONVERT(varchar(19), h.logDate, 120),
CAST(CAST(h.userId AS int) AS varchar(24)),
REPLACE(REPLACE(REPLACE(CAST(h.statusCode AS varchar(40)), CHAR(9), ' '), CHAR(10), ' '), CHAR(13), ' '),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM encstatushistory h
JOIN enc e ON e.encounterID = h.encId AND e.deleteFlag = 0 AND e.date >= (CASE #sq(prompt('DateType','token','''MONTHLY'''))# WHEN 'SETUP' THEN DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 24, 0) WHEN 'CUSTOM' THEN CAST(#sq(prompt('StartDate','date','''2026-09-01'''))# AS datetime) ELSE DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0) END) AND e.date < (DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 4, 0))
) u[SQL1].[RowType][SQL1].[C01][SQL1].[C02][SQL1].[C03][SQL1].[C04][SQL1].[C05][SQL1].[C06][SQL1].[C07][SQL1].[C08][SQL1].[C09][SQL1].[C10][SQL1].[C11][SQL1].[C12][SQL1].[C13][SQL1].[C14][SQL1].[C15][SQL1].[C16][SQL1].[C17][SQL1].[C18][SQL1].[C19][SQL1].[C20][SQL1].[C21][SQL1].[C22][SQL1].[C23][SQL1].[C24][SQL1].[C25][SQL1].[C26][SQL1].[C27][SQL1].[C28][SQL1].[C29][SQL1].[C30][SQL1].[C31][SQL1].[C32][SQL1].[C33][SQL1].[C34][SQL1].[C35][SQL1].[C36]KPI VisitsParamValue('DateType') = 'CUSTOM'