OleDbConnection
4Br1609o+pnie72c6rRil8LI38tWA0L18WT5hHoEd2P6cIECT3FamWdcFaV7wCXjkGhpTtlRY9liSdWE+1jnu9/WmYPNCMPIawahCGAl6XPxYNVMT1HK3W9EpYFh/PYTkNbNAu9pu8hhTf2s6UziE4A6lcthCfMJ4hPtbOkE7A/5eA==
OleDbConnection
dsDatabaseVersion
versionno,System.String
6000
False
dsDatabaseVersion
OleDbConnection
select dbv.versionno
from databaseversion dbv
where dbv.databaseversion = (
select max(dbv2.databaseversion)
from databaseversion dbv2)
dsSubmittal
Project,System.String
Register,System.String
Discipline,System.String
DisciplineDescription,System.String
Total,System.Int32
Description,System.String
Revision_x0020_Files,System.Int32
Submitted,System.Int32
6000
False
dsSubmittal
OleDbConnection
SELECT
Main.Project, Main.Register "Register", Main.Discipline, Main.DisciplineDescription, Main.Total,
Main.Description "Description" ,AttachmentTotal.[Revision Files],
SubmittedTotal.Submitted
FROM
(
SELECT
project.projectno 'Project',
cmdocumentdefn.cmdocumentdefn,
cmdocumentdefn.code 'Register',
cmdocumentdefn.description 'Description',
cmdocument.pvdiscipline,
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ',cmdiscipline.description) END 'Discipline',
cmdiscipline.description 'DisciplineDescription',
COUNT(cmdocument.cmdocument) 'Total',
cmdiscipline.sequenceno
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
project.projectno,
cmdocumentdefn.cmdocumentdefn,
cmdocumentdefn.code,
cmdocument.pvdiscipline,
cmdiscipline.code,
cmdocumentdefn.description,
cmdiscipline.description,
cmdiscipline.sequenceno
) Main
LEFT JOIN
(
SELECT
project.projectno 'Project',
cmdocumentdefn.cmdocumentdefn,
cmdocumentdefn.code 'Register',
cmdocument.pvdiscipline,
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ',cmdiscipline.description) END 'Discipline',
COUNT(cmattachment.cmattachment) 'Revision Files'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
INNER JOIN cmattachment ON cmattachment.cmdocument = cmdocument.cmdocument
WHERE 1=1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
project.projectno,
cmdocumentdefn.cmdocumentdefn,
cmdocumentdefn.code,
cmdocumentdefn.description,
cmdocument.pvdiscipline,
cmdiscipline.code, cmdiscipline.description
) AttachmentTotal ON AttachmentTotal.Project = Main.Project
AND AttachmentTotal.cmdocumentdefn = Main.cmdocumentdefn
AND AttachmentTotal.Discipline = Main.Discipline
LEFT JOIN
(
SELECT
project.projectno 'Project',
cmdoc.cmdocumentdefn,
cmdoc.pvdiscipline,
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ',cmdiscipline.description) END 'Discipline',
COUNT(cmdoc.cmdocument) 'Submitted'
FROM cmdocumentlink
INNER JOIN cmdocument cmdoc ON cmdoc.cmdocument = cmdocumentlink.linkeddocument
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdoc.pvdiscipline
INNER JOIN cmdocument cmdocsubmittal ON cmdocsubmittal.cmdocument = cmdocumentlink.cmdocument
INNER JOIN project ON project.project = cmdocsubmittal.project
INNER JOIN cmaction ON cmaction.cmaction = cmdocsubmittal.cmaction
WHERE 1=1
AND cmdoc.project = {pProject}
AND cmdoc.cmdocumentdefn = {pCmDefn}
AND cmaction.AttributeConstant = 2 --Active/Current
GROUP BY
project.projectno,
cmdoc.cmdocumentdefn,
cmdoc.pvdiscipline,
cmdiscipline.code, cmdiscipline.description
) SubmittedTotal ON SubmittedTotal.project = Main.project
AND SubmittedTotal.cmdocumentdefn = Main.cmdocumentdefn
AND SubmittedTotal.Discipline = Main.Discipline
ORDER BY Main.sequenceno, 1,4
dsOriginator
Originator,System.String
Total,System.Int32
cmdefndescription,System.String
Submitted,System.String
Outstanding,System.String
Responded,System.String
Overdue,System.String
zeroTothreeDays,System.String
fourTosevenDays,System.String
gtSevenDays,System.String
6000
False
dsOriginator
OleDbConnection
SELECT
TotalDocs.Originator, TotalDocs.Total, TotalDocs.cmdefndescription,
ISNULL(CAST(SubmittedDocs.Submitted AS NVARCHAR(20)), 0) 'Submitted',
ISNULL(CAST(OutstandingDocs.Outstanding AS NVARCHAR(20)), 0) 'Outstanding',
ISNULL(CAST(ClosedDocs.Responded AS NVARCHAR(20)), 0) 'Responded',
ISNULL(CAST(OverdueDocs.Overdue AS NVARCHAR(20)), 0) 'Overdue',
ISNULL(CAST(UnderReview0to3Days.zeroTothreeDays AS NVARCHAR(20)), 0) 'zeroTothreeDays',
ISNULL(CAST(UnderReviewfourTosevenDays.fourTosevenDays AS NVARCHAR(20)), 0) 'fourTosevenDays',
ISNULL(CAST(UnderReviewMore7Days.gtSevenDays AS NVARCHAR(20)), 0) 'gtSevenDays'
FROM
(
SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', COUNT(cmdocument.cmdocument) 'Total',
cmdocumentdefn.description 'cmdefndescription'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name),
cmdocumentdefn.description
) TotalDocs
LEFT JOIN
(
SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', COUNT(cmdocument.cmdocument) 'Submitted'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsPublished = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name)
) SubmittedDocs ON SubmittedDocs.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', COUNT(cmdocument.cmdocument) 'Closed', count(cmdocument.cmdocument) 'Responded'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name)
) ClosedDocs ON ClosedDocs.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', COUNT(cmdocument.cmdocument) 'Outstanding'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name)
) OutstandingDocs ON OutstandingDocs.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', COUNT(cmdocument.cmdocument) 'Overdue'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOverdue = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name)
) OverdueDocs ON OverdueDocs.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
Main.Originator, COUNT(Main.[Days Count]) 'zeroTothreeDays'
FROM
( SELECT
CONCAT(contact.RecipientCode, ' - ', contact.name) 'Originator', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) BETWEEN 0 AND 3
) Main
GROUP BY
Originator
) UnderReview0to3Days ON UnderReview0to3Days.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
Main.Originator, COUNT(Main.[Days Count]) 'fourTosevenDays'
FROM
( SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) BETWEEN 4 AND 7
) Main
GROUP BY
Originator
) UnderReviewfourTosevenDays ON UnderReviewfourTosevenDays.Originator = TotalDocs.Originator
LEFT JOIN
(
SELECT
Main.Originator, COUNT(Main.[Days Count]) 'gtSevenDays'
FROM
( SELECT
CONCAT(contact.RecipientCode, IIF(contact.RecipientCode IS NOT null, ' - ', ''), contact.name) 'Originator', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
INNER JOIN cmdocumentaddress ON cmdocumentaddress.cmdocument = cmdocument.cmdocument
AND cmdocumentaddress.addresstype = 1 --FROM
INNER JOIN contact ON contact.contact = cmdocumentaddress.contact
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) > 7
) Main
GROUP BY
Originator
) UnderReviewMore7Days ON UnderReviewMore7Days.Originator = TotalDocs.Originator
dsOutstanding
Discipline,System.String
cmdefndescription,System.String
Total,System.Int32
Submitted,System.String
Responded,System.String
Outstanding,System.String
Overdue,System.String
zeroTothreeDays,System.String
fourTosevenDays,System.String
gtSevenDays,System.String
cmdisciplinedescription,System.String
6000
False
dsOutstanding
OleDbConnection
SELECT
TotalDocs.Discipline,
TotalDocs.cmdefndescription,
TotalDocs.Total,
ISNULL(CAST(SubmittedDocs.Submitted AS NVARCHAR(20)), 0) 'Submitted',
ISNULL(CAST(ClosedDocs.Responded AS NVARCHAR(20)), 0) 'Responded',
ISNULL(CAST(OutstandingDocs.Outstanding AS NVARCHAR(20)), 0) 'Outstanding',
ISNULL(CAST(OverdueDocs.Overdue AS NVARCHAR(20)), 0) 'Overdue',
ISNULL(CAST(UnderReview0to3Days.zeroTothreeDays AS NVARCHAR(20)), 0) 'zeroTothreeDays',
ISNULL(CAST(UnderReviewfourTosevenDays.fourTosevenDays AS NVARCHAR(20)), 0) 'fourTosevenDays',
ISNULL(CAST(UnderReviewMore7Days.gtSevenDays AS NVARCHAR(20)), 0) 'gtSevenDays',
TotalDocs.cmdisciplinedescription
FROM
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline',
COUNT(cmdocument.cmdocument) 'Total', cmdiscipline.sequenceno,
cmdocumentdefn.description 'cmdefndescription', cmdiscipline.description 'cmdisciplinedescription'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.sequenceno,
cmdocumentdefn.description,
cmdiscipline.description
) TotalDocs
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Submitted'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsPublished = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) SubmittedDocs ON SubmittedDocs.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Closed', count(cmdocument.cmdocument) 'Responded'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) ClosedDocs ON ClosedDocs.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Outstanding'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) OutstandingDocs ON OutstandingDocs.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Overdue'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOverdue = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) OverdueDocs ON OverdueDocs.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'zeroTothreeDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) BETWEEN 0 AND 3
) Main
GROUP BY
Discipline
) UnderReview0to3Days ON UnderReview0to3Days.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'fourTosevenDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) BETWEEN 4 AND 7
) Main
GROUP BY
Discipline
) UnderReviewfourTosevenDays ON UnderReviewfourTosevenDays.Discipline = TotalDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'gtSevenDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code, ' - ' , cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
GETUTCDATE()
) > 7
) Main
GROUP BY
Discipline
) UnderReviewMore7Days ON UnderReviewMore7Days.Discipline = TotalDocs.Discipline
ORDER BY TotalDocs.sequenceno
dsClosed
Discipline,System.String
cmdefndescription,System.String
Raised,System.Int32
cmdisciplinedescription,System.String
Closed,System.String
Outstanding,System.String
Overdue,System.String
zeroTothreeDays,System.String
fourTosevenDays,System.String
gtSevenDays,System.String
Rejected,System.String
6000
False
dsClosed
OleDbConnection
SELECT
RaisedDocs.Discipline, RaisedDocs.cmdefndescription,
RaisedDocs.Raised, RaisedDocs.cmdisciplinedescription,
ISNULL(CAST(ClosedDocs.Closed AS NVARCHAR(20)), 0) 'Closed',
ISNULL(CAST(OutstandingDocs.Outstanding AS NVARCHAR(20)), 0) 'Outstanding',
ISNULL(CAST(OverdueDocs.Overdue AS NVARCHAR(20)), 0) 'Overdue',
ISNULL(CAST(ClosedDate0to3Days.zeroTothreeDays AS NVARCHAR(20)), 0) 'zeroTothreeDays',
ISNULL(CAST(ClosedDate4to7Days.fourTosevenDays AS NVARCHAR(20)), 0) 'fourTosevenDays',
ISNULL(CAST(ClosedDateMore7Days.gtSevenDays AS NVARCHAR(20)), 0) 'gtSevenDays',
ISNULL(CAST(RejectedDocs.Rejected AS NVARCHAR(20)), 0) 'Rejected'
FROM
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Raised', cmdiscipline.sequenceno, cmdocumentdefn.description 'cmdefndescription',
cmdiscipline.description 'cmdisciplinedescription'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.sequenceno,
cmdocumentdefn.description,
cmdiscipline.description
) RaisedDocs
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Closed'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) ClosedDocs ON ClosedDocs.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Outstanding'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOutstanding = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) OutstandingDocs ON OutstandingDocs.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Overdue'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdocument.IsOverdue = 1
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) OverdueDocs ON OverdueDocs.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'zeroTothreeDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn ={pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) BETWEEN 0 AND 3
) Main
GROUP BY
Discipline
) ClosedDate0to3Days ON ClosedDate0to3Days.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'fourTosevenDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) BETWEEN 4 AND 7
) Main
GROUP BY
Discipline
) ClosedDate4to7Days ON ClosedDate4to7Days.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
Main.Discipline, COUNT(Main.[Days Count]) 'gtSevenDays'
FROM
( SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', cmdocument.cmdocument, cmdocument.documentno,
DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) 'Days Count'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus IN (7, 14) --Cancelled / Closed
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
AND DATEDIFF(DAY,
cmdocument.PublishedDate,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(),
CONVERT(datetime,SWITCHOFFSET(CONVERT(datetimeoffset,GETUTCDATE()),
(SELECT TOP 1 OffSet from TimeZone where TimeZone = (SELECT TimezoneID FROM project WHERE project.project = cmdocument.project))))
), (SELECT zztimestamp FROM zzcmdocument
WHERE zzcmdocument = (SELECT MAX(zzcmdocument) FROM zzcmdocument WHERE zzcmdocument.cmdocument = cmdocument.cmdocument
AND zzcmdocument.cmdocumentstatus = cmdocument.cmdocumentstatus)))
) > 7
) Main
GROUP BY
Discipline
) ClosedDateMore7Days ON ClosedDateMore7Days.Discipline = RaisedDocs.Discipline
LEFT JOIN
(
SELECT
CASE WHEN cmdiscipline.code IS NULL THEN 'No Discipline' ELSE concat(cmdiscipline.code,' - ', cmdiscipline.description) END 'Discipline', COUNT(cmdocument.cmdocument) 'Rejected'
FROM cmdocument
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
INNER JOIN cmdocumentstatus ON cmdocumentstatus.cmdocumentstatus = cmdocument.cmdocumentstatus
INNER JOIN cmdefnstatus ON cmdefnstatus.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
AND cmdefnstatus.cmdocumentstatus = cmdocumentstatus.cmdocumentstatus
LEFT JOIN cmdiscipline ON cmdiscipline.cmdiscipline = cmdocument.pvdiscipline
INNER JOIN project ON project.project = cmdocument.project
WHERE 1=1
AND cmdefnstatus.BaseStatus = 7 --Cancelled
AND cmdocument.cmdocumentdefn = {pCmDefn}
AND cmdocument.project = {pProject}
GROUP BY
cmdiscipline.code,
cmdiscipline.description
) RejectedDocs ON RejectedDocs.Discipline = RaisedDocs.Discipline
ORDER BY RaisedDocs.sequenceno
dsLayout4
Process_x0020_Workflow,System.String
Person,System.String
In_x0020_Progress,System.Int32
Overdue,System.String
6000
False
dsLayout4
OleDbConnection
WITH WorkflowActivityOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFActivity.WFActivity,
WFActivity.ActivityDeadlineDate,
WFactivity.IsOverdue
FROM WFworkflow
INNER JOIN WFActivity ON WFActivity.WFWorkFlow = WFWorkFlow.WFWorkFlow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFActivityContact ON WFActivityContact.WFActivity = WFActivity.WFActivity
INNER JOIN contact ON contact.contact = WFActivityContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFActivity.IsStarted = 1 --Activity Started
AND WFActivity.isclosed = 0 --Activity waiting for Outcome
AND WFActivityContact.ContactType = 1 --Activity Owner'
AND cmdocument.project = {pProject}
)
SELECT
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Person,
COUNT(WorkflowActivityOwner.WFActivity) 'In Progress',
ISNULL(CAST(ActivityPersonOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue'
FROM WorkflowActivityOwner
LEFT JOIN (
SELECT
WorkflowActivityOwner.Register,
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Person,
COUNT(WFActivity) 'Overdue'
FROM WorkflowActivityOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Person,
WorkflowActivityOwner.Register
) ActivityPersonOverdue ON ActivityPersonOverdue.[Process Workflow] = WorkflowActivityOwner.[Process Workflow]
AND ActivityPersonOverdue.Person = WorkflowActivityOwner.Person
AND ActivityPersonOverdue.Register = WorkflowActivityOwner.Register
GROUP BY
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Person,
ActivityPersonOverdue.Overdue,
WorkflowActivityOwner.[Class Seq],
WorkflowActivityOwner.[Register Seq]
ORDER BY
WorkflowActivityOwner.[Class Seq],
WorkflowActivityOwner.[Register Seq],
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Person
dsLayout5
Process_x0020_Workflow,System.String
Company,System.String
In_x0020_Progress,System.Int32
Overdue,System.String
6000
False
dsLayout5
OleDbConnection
WITH WorkflowActivityOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
parent.name 'Company',
WFActivity.WFActivity,
WFActivity.ActivityDeadlineDate,
WFactivity.IsOverdue
FROM WFworkflow
INNER JOIN WFActivity ON WFActivity.WFWorkFlow = WFWorkFlow.WFWorkFlow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFActivityContact ON WFActivityContact.WFActivity = WFActivity.WFActivity
INNER JOIN contact ON contact.contact = WFActivityContact.contact
INNER JOIN contact parent ON parent.contact = contact.parentcontact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFActivity.IsStarted = 1 --Activity Started
AND WFActivity.isclosed = 0 --Activity waiting for Outcome
AND WFActivityContact.ContactType = 1 --Activity Owner
AND cmdocument.project = {pProject}
)
SELECT
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Company,
COUNT(WorkflowActivityOwner.WFActivity) 'In Progress',
ISNULL(CAST(ActivityCompanyOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue'
FROM WorkflowActivityOwner
LEFT JOIN (
SELECT
WorkflowActivityOwner.Register,
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Company,
COUNT(WFActivity) 'Overdue'
FROM WorkflowActivityOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Company,
WorkflowActivityOwner.Register
) ActivityCompanyOverdue ON ActivityCompanyOverdue.[Process Workflow] = WorkflowActivityOwner.[Process Workflow]
AND ActivityCompanyOverdue.Company = WorkflowActivityOwner.Company
AND ActivityCompanyOverdue.Register = WorkflowActivityOwner.Register
GROUP BY
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Company,
ActivityCompanyOverdue.Overdue,
WorkflowActivityOwner.[Class Seq],
WorkflowActivityOwner.[Register Seq]
ORDER BY
WorkflowActivityOwner.[Class Seq],
WorkflowActivityOwner.[Register Seq],
WorkflowActivityOwner.[Process Workflow],
WorkflowActivityOwner.Company
dsLayout6
Process_x0020_Workflow,System.String
Person,System.String
In_x0020_Progress,System.Int32
Overdue,System.String
6000
False
dsLayout6
OleDbConnection
WITH WorkflowOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFworkflow.WFworkflow,
WFworkflow.WFDeadlineDate,
WFworkflow.IsOverdue
FROM WFworkflow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFWorkflowContact ON WFWorkflowContact.WFworkflow = WFworkflow.WFworkflow
INNER JOIN contact ON contact.contact = WFWorkflowContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFWorkflowContact.ContactType = 1 --Workflow Owner
AND cmdocument.project = {pProject}
)
SELECT
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WorkflowOwner.WFworkflow) 'In Progress',
ISNULL(CAST(WorkflowPersonOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue'
FROM WorkflowOwner
LEFT JOIN (
SELECT
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WFworkflow) 'Overdue'
FROM WorkflowOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowOwner.Register
) WorkflowPersonOverdue ON WorkflowPersonOverdue.[Process Workflow] = WorkflowOwner.[Process Workflow]
AND WorkflowPersonOverdue.Person = WorkflowOwner.Person
AND WorkflowPersonOverdue.Register = WorkflowOwner.Register
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowPersonOverdue.Overdue,
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq]
ORDER BY
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq],
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person
dsLayout7Combined
Process_x0020_Workflow,System.String
Responsible_x0020_Owner,System.String
In_x0020_Progress,System.Int32
Overdue,System.String
Current_x0020_Activity_x0020_to_x0020_Action,System.String
Person_x0020_to_x0020_Action,System.String
sequenceNo,System.Int32
6000
False
dsLayout7Combined
OleDbConnection
WITH WorkflowOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFworkflow.WFworkflow,
WFworkflow.WFDeadlineDate,
WFworkflow.IsOverdue
FROM WFworkflow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFWorkflowContact ON WFWorkflowContact.WFworkflow = WFworkflow.WFworkflow
INNER JOIN contact ON contact.contact = WFWorkflowContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFWorkflowContact.ContactType = 1 --Workflow Owner
AND cmdocument.project = {pProject}
)
SELECT
WorkflowOwnerMainSorted.[Process Workflow], WorkflowOwnerMainSorted.[Responsible Owner],
WorkflowOwnerMainSorted.[In Progress], WorkflowOwnerMainSorted.Overdue,
WorkflowOwnerMainSorted.[Current Activity to Action], WorkflowOwnerMainSorted.[Person to Action]
, WorkflowOwnerMainSorted.[Class Seq] 'sequenceNo'
FROM
(
SELECT --DISTINCT
WorkflowOwnerMain.[Class Seq], WorkflowOwnerMain.[Register Seq],
WorkflowOwnerMain.[Process Workflow], WorkflowOwnerMain.Person 'Responsible Owner',
WorkflowOwnerMain.[In Progress], WorkflowOwnerMain.Overdue,
WorkflowActivityToAction.[Current Activity to Action],
WorkflowActivityToAction.[Person to Action]
FROM
(
SELECT
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq],
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WorkflowOwner.WFworkflow) 'In Progress',
ISNULL(CAST(WorkflowPersonOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue'
FROM WorkflowOwner
LEFT JOIN (
SELECT
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WFworkflow) 'Overdue'
FROM WorkflowOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowOwner.Register
) WorkflowPersonOverdue ON WorkflowPersonOverdue.[Process Workflow] = WorkflowOwner.[Process Workflow]
AND WorkflowPersonOverdue.Person = WorkflowOwner.Person
AND WorkflowPersonOverdue.Register = WorkflowOwner.Register
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowPersonOverdue.Overdue,
WorkflowOwner.Register,
--WorkflowActivityToAction.[Current Activity to Action],
--WorkflowActivityToAction.[Person to Action],
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq]
) WorkflowOwnerMain
LEFT JOIN (
SELECT
WorkflowOwner.Register, WorkflowOwner.Person, WorkflowOwner.[Process Workflow],
WFDefinitionActivity.Name 'Current Activity to Action',
concat(contact2.name,' - ' ,contact2.RecipientCode, ' - ', projectroletype.description) 'Person to Action'
FROM WorkflowOwner
LEFT JOIN WFActivity ON WFActivity.WFWorkFlow = WorkflowOwner.WFWorkFlow
LEFT JOIN WFDefinitionActivity ON WFDefinitionActivity.WFDefinitionActivity = WFActivity.WFDefinitionActivity
LEFT JOIN WFActivityContact ON WFActivityContact.WFActivity = WFActivity.WFActivity
LEFT JOIN contact contact2 ON contact2.contact = WFActivityContact.Contact
INNER JOIN authuser ON authuser.authuser = contact2.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE 1=1
AND WFActivity.IsStarted = 1 --Activity Started
AND WFActivity.isclosed = 0 --Activity waiting for Outcome
AND WFActivityContact.ContactType = 1 --Activity Owner
) WorkflowActivityToAction ON WorkflowActivityToAction.[Process Workflow] = WorkflowOwnerMain.[Process Workflow]
AND WorkflowActivityToAction.Person = WorkflowOwnerMain.Person
AND WorkflowActivityToAction.Register = WorkflowOwnerMain.Register
) WorkflowOwnerMainSorted
ORDER BY
WorkflowOwnerMainSorted.[Class Seq]
,WorkflowOwnerMainSorted.[Register Seq]
,WorkflowOwnerMainSorted.[Process Workflow]
,WorkflowOwnerMainSorted.[Responsible Owner]
dsMasterLayout7
Process_x0020_Workflow,System.String
Responsible_x0020_Owner,System.String
In_x0020_Progress,System.Int32
Overdue,System.String
sequenceNo,System.Int32
authuser,System.Int32
WFdefinition,System.Int32
primary,System.Int32
6000
False
dsMasterLayout7
OleDbConnection
WITH WorkflowOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFworkflow.WFworkflow,
WFworkflow.WFDeadlineDate,
WFworkflow.IsOverdue,
cmdocumentclass.sequenceno 'sequenceNo',
authuser.authuser -- added
, WFdefinition.WFDefinition -- added
, (authuser.authuser + wfdefinition.WFDefinition + contact.contact + cmdocumentclass.cmdocumentclass) 'primary'-- added
FROM WFworkflow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFWorkflowContact ON WFWorkflowContact.WFworkflow = WFworkflow.WFworkflow
INNER JOIN contact ON contact.contact = WFWorkflowContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFWorkflowContact.ContactType = 1 --Workflow Owner
AND cmdocument.project = {pProject}
),WorkflowOwner2 AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFworkflow.WFworkflow,
WFworkflow.WFDeadlineDate,
WFworkflow.IsOverdue
FROM WFworkflow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFWorkflowContact ON WFWorkflowContact.WFworkflow = WFworkflow.WFworkflow
INNER JOIN contact ON contact.contact = WFWorkflowContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFWorkflowContact.ContactType = 1 --Workflow Owner
AND cmdocument.project = {pProject} -- project parameter
)
SELECT
[Process Workflow],
[Responsible Owner],
COUNT(WFworkflow) 'In Progress',
Overdue,
sequenceNo,
authuser,
WFdefinition,
[primary]
FROM
(
SELECT DISTINCT
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person 'Responsible Owner',
--COUNT(WorkflowOwner.WFworkflow) 'In Progress',
WorkflowOwner.WFworkflow,
ISNULL(CAST(WorkflowPersonOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue',
WorkflowOwner.sequenceNo,
WorkflowOwner.authuser -- added,
, WorkflowOwner.WFDefinition -- added
, WorkflowOwner.[primary]
, WorkflowOwner.[Register Seq]
, WorkflowOwner.[Person]
FROM WorkflowOwner
LEFT JOIN (
SELECT
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WFworkflow) 'Overdue'
, WorkflowOwner.[primary]
FROM WorkflowOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowOwner.Register,
WorkflowOwner.authuser,
workflowowner.WFDefinition -- added
, WorkflowOwner.[primary]
) WorkflowPersonOverdue ON WorkflowPersonOverdue.[Process Workflow] = WorkflowOwner.[Process Workflow]
AND WorkflowPersonOverdue.Person = WorkflowOwner.Person
AND WorkflowPersonOverdue.Register = WorkflowOwner.Register
LEFT JOIN WFActivity ON WFActivity.WFWorkFlow = WorkflowOwner.WFWorkFlow
LEFT JOIN WFDefinitionActivity ON WFDefinitionActivity.WFDefinitionActivity = WFActivity.WFDefinitionActivity
LEFT JOIN WFActivityContact ON WFActivityContact.WFActivity = WFActivity.WFActivity
LEFT JOIN contact ON contact.contact = WFActivityContact.Contact
WHERE 1=1
AND WFActivity.IsStarted = 1 --Activity Started
AND WFActivity.isclosed = 0 --Activity waiting for Outcome
AND WFActivityContact.ContactType = 1 --Activity
) DistinctQuery
GROUP BY
[Process Workflow],
[Responsible Owner],
Overdue,
sequenceNo,
authuser -- added
, WFDefinition
, [primary],
DistinctQuery.[Register Seq],
DistinctQuery.[Process Workflow],
DistinctQuery.Person
ORDER BY
--WorkflowOwner.[Class Seq],
--WorkflowOwner.[Register Seq],
--WorkflowOwner.[Process Workflow],
--WorkflowOwner.Person
DistinctQuery.sequenceNo,
DistinctQuery.[Register Seq],
DistinctQuery.[Process Workflow],
DistinctQuery.Person
dsDetailsLayout7
Process_x0020_Workflow,System.String
Responsible_x0020_Owner,System.String
In_x0020_Progress,System.Int32
Overdue,System.Int32
Current_x0020_Activity_x0020_to_x0020_Action,System.String
Person_x0020_to_x0020_Action,System.String
sequenceNo,System.Int32
primary,System.Int32
6000
False
dsDetailsLayout7
OleDbConnection
WITH WorkflowOwner AS
(
SELECT
cmdocumentclass.cmdocumentclass 'Class', cmdocumentclass.sequenceno 'Class Seq',
cmdocumentdefn.code 'Register',
cmdocumentdefn.sequenceno 'Register Seq',
WFDefinition.Name 'Process Workflow',
CONCAT(contact.name, ', ', contact.RecipientCode, ' - ', projectroletype.description) 'Person',
WFworkflow.WFworkflow,
WFworkflow.WFDeadlineDate,
WFworkflow.IsOverdue
, authuser.authuser + (wfdefinition.WFDefinition + contact.contact + cmdocumentclass.cmdocumentclass) 'primary' -- added xxx
FROM WFworkflow
INNER JOIN WFDefinition ON WFDefinition.WFDefinition = WFWorkFlow.WFDefinition
INNER JOIN WFWorkflowContact ON WFWorkflowContact.WFworkflow = WFworkflow.WFworkflow
INNER JOIN contact ON contact.contact = WFWorkflowContact.contact
INNER JOIN cmdocument ON cmdocument.cmdocument = WFWorkFlow.LinkedObjectId
INNER JOIN cmdocumentdefn ON cmdocumentdefn.cmdocumentdefn = cmdocument.cmdocumentdefn
LEFT JOIN cmdocumentclass ON cmdocumentclass.cmdocumentclass = cmdocumentdefn.cmdocumentclass
INNER JOIN authuser ON authuser.authuser = contact.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
WHERE
WFWorkFlow.Status = 1 --In Progress
AND WFWorkflowContact.ContactType = 1 --Workflow Owner
AND cmdocument.project = {pProject}
)
SELECT
WorkflowOwnerMainSorted.[Process Workflow], WorkflowOwnerMainSorted.[Responsible Owner],
WorkflowOwnerMainSorted.[In Progress], WorkflowOwnerMainSorted.Overdue,
WorkflowOwnerMainSorted.[Current Activity to Action], WorkflowOwnerMainSorted.[Person to Action]
, WorkflowOwnerMainSorted.[Class Seq] 'sequenceNo'
, WorkflowOwnerMainSorted.[primary]
FROM
(
SELECT --DISTINCT
WorkflowOwnerMain.[Class Seq], WorkflowOwnerMain.[Register Seq],
WorkflowOwnerMain.[Process Workflow], WorkflowOwnerMain.Person 'Responsible Owner',
WorkflowOwnerMain.[In Progress], WorkflowOwnerMain.Overdue,
WorkflowActivityToAction.[Current Activity to Action],
WorkflowActivityToAction.[Person to Action],
WorkflowActivityToAction.[primary]
FROM
(
SELECT
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq],
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WorkflowOwner.WFworkflow) 'In Progress',
ISNULL(CAST(WorkflowPersonOverdue.Overdue AS NVARCHAR(20)), '') 'Overdue'
, WorkflowOwner.[primary] -- added xxx
FROM WorkflowOwner
LEFT JOIN (
SELECT
WorkflowOwner.Register,
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
COUNT(WFworkflow) 'Overdue'
, WorkflowOwner.[primary] -- added xxx
FROM WorkflowOwner
WHERE IsOverdue = 1
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowOwner.Register
, WorkflowOwner.[primary] -- added xxx
) WorkflowPersonOverdue ON WorkflowPersonOverdue.[Process Workflow] = WorkflowOwner.[Process Workflow]
AND WorkflowPersonOverdue.Person = WorkflowOwner.Person
AND WorkflowPersonOverdue.Register = WorkflowOwner.Register
GROUP BY
WorkflowOwner.[Process Workflow],
WorkflowOwner.Person,
WorkflowPersonOverdue.Overdue,
WorkflowOwner.Register,
WorkflowOwner.[Class Seq],
WorkflowOwner.[Register Seq]
,WorkflowOwner.[primary] -- added xxx
) WorkflowOwnerMain
LEFT JOIN (
SELECT
WorkflowOwner.Register, WorkflowOwner.Person, WorkflowOwner.[Process Workflow],
WFDefinitionActivity.Name 'Current Activity to Action',
concat(contact2.name,' - ' ,contact2.RecipientCode, ' - ', projectroletype.description) 'Person to Action'
,WorkflowOwner.[primary] 'primary' --added xxx
FROM WorkflowOwner
LEFT JOIN WFActivity ON WFActivity.WFWorkFlow = WorkflowOwner.WFWorkFlow
LEFT JOIN WFDefinitionActivity ON WFDefinitionActivity.WFDefinitionActivity = WFActivity.WFDefinitionActivity
LEFT JOIN WFActivityContact ON WFActivityContact.WFActivity = WFActivity.WFActivity
LEFT JOIN contact contact2 ON contact2.contact = WFActivityContact.Contact
INNER JOIN authuser ON authuser.authuser = contact2.authuser
LEFT JOIN projectroletype ON projectroletype.projectroletype = authuser.projectroletype
INNER JOIN WFWorkflow ON wfactivity.wfworkflow = wfworkflow.wfworkflow
INNER JOIN cmdocument ON wfworkflow.cmdocument = cmdocument.cmdocument
INNER JOIN cmdocumentdefn ON cmdocument.cmdocumentdefn = cmdocumentdefn.cmdocumentdefn
WHERE 1=1
AND WFActivity.IsStarted = 1 --Activity Started
AND WFActivity.isclosed = 0 --Activity waiting for Outcome
AND WFActivityContact.ContactType = 1 --Activity Owner
) WorkflowActivityToAction ON WorkflowActivityToAction.[Process Workflow] = WorkflowOwnerMain.[Process Workflow]
AND WorkflowActivityToAction.Person = WorkflowOwnerMain.Person
AND WorkflowActivityToAction.Register = WorkflowOwnerMain.Register
) WorkflowOwnerMainSorted
ORDER BY
WorkflowOwnerMainSorted.[Class Seq]
,WorkflowOwnerMainSorted.[Register Seq]
,WorkflowOwnerMainSorted.[Process Workflow]
,WorkflowOwnerMainSorted.[Responsible Owner]
workflow4
primary
workflow4
relLayout7
primary
,pAuthUser,pAuthUser,System.String,,False,False,True
,pBusEntText,pBusEntText,System.String,,False,False,True
,pCompanyName,pCompanyName,System.String,,False,False,True
,pDatabaseName,pDatabaseName,System.String,,False,False,True
,pProjectText,pProjectText,System.String,,False,False,True
,pReportLogo,pReportLogo,System.String,RptLogo.bmp,False,False,True
,pUserID,pUserID,System.String,,False,False,True
,pCmDefnText,pCmDefnText,System.String,,False,False,True
,vDiscipline3,vDiscipline3,System.String,,False,False
,vDiscipline2,vDiscipline2,System.String,,False,False
,vDiscipline1,vDiscipline1,System.String,,False,False
,vDiscipline,vDiscipline,System.String,,False,False
,pCmDefn,pCmDefn,System.String,_x0032_0,False,False
,pBusEnt,pBusEnt,System.String,_x0031_,False,False
,pProject,pProject,System.String,_x0032_,False,False
,vReportCode,vReportCode,System.String,DOC-0013,False,False
,vReportVersion,vReportVersion,System.String,AO,False,False
,sPrevProcessWorkflow,sPrevProcessWorkflow,System.String,,False,False
,sPrevResponsibleOwner,sPrevResponsibleOwner,System.String,,False,False
,nPrevOverDue,nPrevOverDue,System.Int32,,False,False
,nPrevInProgress,nPrevInProgress,System.Int32,,False,False
,sPersonToAction,sPersonToAction,System.String,,False,False
,nTotalOverdue,nTotalOverdue,System.Int32,,False,False
,nTotalInProgress,nTotalInProgress,System.Int32,,False,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0.2,0.4,12.19,0.76
Arial,9,Bold| Italic
2e320612db154613abe1e0d423bdd738
0,0,0,0
lblPageHdrBndReportName
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial,8.25,Italic
ba6dd119f35d4cd294860908afa799ae
0,0,0,0
lblPageHdrBndParameters
Business Entity: {pBusEntText} - Project No. {pProjectText} - Register: {pCmDefnText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial,8.25,Italic
d0b2baf1dfc3481381f515f1c8724808
Right
0,0,0,0
StdPageHeaderCompanyName
{pCompanyName}
[64:82:94]
Expression
5535779a0e8d4a91870127c089e66bd1
pageHdrBnd
ExceptFirstPage
Transparent
0,75.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial,7,Italic
bd4975fd07b1455c95ab9e4cab91ed36
0,0,0,0
StdPageFooterText
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial,7,Italic
4f1f6b4da91c4203b2e89ce6d3d6d235
Right
0,0,0,0
StdPageFooterPageNumber
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
329caf2975e0417db74fc8386012ff1f
StdPageFooterLine
Black
8bdcaf907c33446b83b89404e65369e3
StdPageFooter
Transparent
0,3.05,27.7,3.4
True
Transparent
0,0.2,3,2
88400dc686684855818144f06284ee4c
{pReportLogo}
StdReportTitleProjectionLogo
True
Transparent
3.2,0.8,18.4,0.6
Arial Unicode MS,12,Regular,Point,False,0
68ffc8967f5b492b952d3d7622af7bcb
0,0,0,0
StdReportHeaderReportName
{ReportName}
[64:82:94]
Transparent
3.2,0.2,15.2,0.4
Arial Unicode MS,8,Italic,Point,False,0
43474e90c20a4e0a9d2d425c945d0bdb
0,0,0,0
StdReportHeaderCompanyName
{pCompanyName}
[64:82:94]
Expression
Transparent
3.2,1.4,24.4,0.6
Arial Unicode MS,8,Regular,Point,False,0
aaa54edda8ef496c826a1a534157ef0f
0,0,0,0
Text20
Business Entity : {pBusEntText}
[64:82:94]
Expression
Center
Transparent
3.2,2.55,24.4,0.6
Arial Unicode MS,8,Regular,Point,False,0
2a467f9770d94417b08a7161d10af8ac
0,0,0,0
Text22
Register: {pCmDefnText}
[64:82:94]
Expression
Center
Transparent
3.2,1.95,24.4,0.6
Arial Unicode MS,8,Regular,Point,False,0
7c3f92c8c2324d6298dc49b2dc6fcc36
0,0,0,0
Text21
Project No : {pProjectText}
[64:82:94]
Expression
Center
0,0,27.6,0.0254
85, 109, 124
Black
db76a6074ba14ae982e20eb34ed7b904
HorizontalLine1
Black
b57b780f822d42ccb1a76f9d42fba4da
StdReportTitle
Left;Silver;1;Solid;False;4;Black
White
0,7.25,27.7,0.8
All;Silver;1;Solid;False;4;Black
White
0,0.4,6.6,0.4
Arial,8
46b665170f324a3ba4db5a8b15d2780a
True
0,0,0,0
lblDiscipline1
Discipline
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0.4,2.2,0.4
Arial,8
a78e718b7b1a4d58a1a2991bf977d8ae
Center
True
0,0,0,0
lblTotal
Total
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
8.8,0.4,2.2,0.4
Arial,8
f73707ad58994c4b950d3ce4cb0f4430
Center
True
0,0,0,0
lblRevisionFiles
Revision Files
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
11,0.4,2.2,0.4
Arial,8
8c3a2f413d0a406cb89859ae7f83fa81
Center
True
0,0,0,0
lblSubmitted
Submitted
Black
Expression
Center
Top;Transparent;1;Solid;False;4;Black
Transparent
14.4,0.4,13.3,0.4
Arial,8
60859405a41047fea3d7711936c6e0ac
Center
True
0,0,0,0
Text4
Black
Expression
Center
Top;Transparent;1;Solid;False;4;Black
Transparent
14.4,0.4,13.3,0.2
Arial,8
57a490ede7e9431393911dc4a00a7b7f
True
0,0,0,0
Text6
Black
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
14.4,0.4,5.5,0.4
Arial,8
652a3904f97745e085f8e7f8c52f537b
Center
True
0,0,0,0
Text50
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
0,0,13.2,0.4
Arial,8,Bold
835e652ae19a431a8ea10b270c181a26
True
0,0,0,0
Text56
{dsSubmittal.Description}
Black
Expression
Center
12f09d566d314d1db2a117d8fbd2ccf5
hdrBndLayout0
True
if(dsClosed.Discipline.Length > 1) {
vDiscipline3 = dsSubmittal.Discipline + " - " + dsSubmittal.DisciplineDescription;
} else {
vDiscipline3 = "No Discipline";
}
Left;Silver;1;Solid;False;4;Black
White
True
0,8.85,27.7,0.41
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0,2.2,0.4
Arial,8
ebe8c4c817f041388fa5af14047bfce0
Center
True
0,0,0,0
txtTotal
{dsSubmittal.Total}
Black
Expression
Center
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
8.8,0,2.2,0.4
Arial,8
d2785877f1ab4f31b5592a99a72f1bc7
Center
True
0,0,0,0
txtRevisionFiles
{dsSubmittal.Revision_Files}
Black
Expression
Center
Left, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
11,0,2.2,0.4
Arial,8
a28278ca733a4adab583b82653ecbcdb
Center
True
0,0,0,0
txtSubmitted
{dsSubmittal.Submitted}
Black
Expression
Center
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
0,0,6.6,0.4
Arial,8
6202e4283ba74c63a0fd5b510a221dbd
True
0,0,0,0
txtDiscipline
{dsSubmittal.Discipline}
Black
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
14.4,0,13.3,0.4
Arial,8
585d1da74b6c45c0b403560e98c74a8c
Center
True
0,0,0,0
Text5
Black
Expression
Center
dsSubmittal
ddfd3061bb9e4df5ac54444f73836ac0
dataBndLayout2
White
0,10.06,27.7,0.4
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0,2.2,0.4
Arial,8
65a3cce2714c48fd88ee3a93964f9b36
Center
True
0,0,0,0
Text24
{Sum(dsSubmittal.Total)}
Black
Expression
Center
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
8.8,0,2.2,0.4
Arial,8
b4f918e40e954122b0cc87e6db3a801e
Center
True
0,0,0,0
Text25
{Sum(dsSubmittal.Revision_Files)}
Black
Expression
Center
Left, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
11,0,2.2,0.4
Arial,8
684ba27105344d3496b5a5d74a0bc606
Center
True
0,0,0,0
Text26
{Sum(dsSubmittal.Submitted)}
Black
Expression
Center
Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
4,0,2.6,0.4
Arial,8
087f18c043ab4166974e6de97cbba814
Center
True
0,0,0,0
Text2
Total
Black
Expression
Center
ftrLayou0
f851467aa2ea4e78bb6fed8e8d209dc6
True
1,1,1,1
LayoutZero
Landscape
21
29.7
A4
Arial,100,Bold
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
56ada7d2b9d040de87bc0e14b747dd7d
0,0,0,0
Text79
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
eeec739980324a9cbcf25f6560c1eec9
0,0,0,0
Text80
Business Entity: {pBusEntText} - Project No. {pProjectText} - Register: {pCmDefnText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
57215266f54844e48827cc8008d68d8d
Right
0,0,0,0
Text81
{pCompanyName}
[64:82:94]
Expression
8b197be77a64414483d2f8d9cdd335e7
PageHeaderBand3
ExceptFirstPage
Transparent
0,75.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
4eda1b3c651346179de6f42d3a08228a
0,0,0,0
Text82
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
6a210948489a4432ace5bf4c66666361
Right
0,0,0,0
Text83
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
f29478054a72471483d6b983012f3f39
HorizontalLinePrimitive3
Black
daea915abaf34564949b44461ad14238
PageFooterBand3
Left;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
Right;Silver;1;Solid;False;4;Black
Transparent
8.8,0.42,2.2,0.4
Arial Unicode MS,8
cfae23817e064d4fa841b0d29896cdae
Center
True
0,0,0,0
lblCLosed
Closed
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
11,0.42,2.2,0.4
Arial Unicode MS,8
351353ff825043de836d912ac3725a15
Center
True
0,0,0,0
lblZeroToThreeDays1
0-3 days
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
13.2,0.42,2.2,0.4
Arial Unicode MS,8
4833041dcf1b4f0d98ac2b31c3529e8d
Center
True
0,0,0,0
lbl4FourToSevenDays1
4-7 days
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
15.4,0.42,2.2,0.4
Arial Unicode MS,8
4eafa43da1494bd6bb72bd13541a75b3
Center
True
0,0,0,0
lblGtSevenDays1
>7 days
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
0,0.42,6.6,0.4
Arial Unicode MS,8
cdcd3e30d54e402cbff17a319a9d518f
True
0,0,0,0
lblDiscipline
Discipline
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
0,0,11,0.4
Arial Unicode MS,8,Bold
5d264a438ccb441db97297876a2af11c
True
0,0,0,0
txtCmDefnDescription
{dsClosed.cmdefndescription}
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
6.6,0.42,2.2,0.4
Arial Unicode MS,8
d9059a7f1ab14d2195ba6a011930c862
Center
True
0,0,0,0
lblRaised
Raised
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
[216:216:216]
11,0,6.6,0.4
Arial Unicode MS,8
57f7133e4ac04716aed1bb8b47eec457
Center
True
0,0,0,0
lblBasedOnClosedPublishedDate
KPI - Turn Around Time
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
19.8,0.42,2.2,0.4
Arial Unicode MS,8
cbc99b8affd34b79838d2b9b747008b6
Center
True
0,0,0,0
lblOverDue1
Overdue
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
22,0.42,2.2,0.4
Arial Unicode MS,8
a1362283575e4044a5e0aa18d836c3cf
Center
True
0,0,0,0
lblOverdue
Rejected
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
17.6,0.42,2.2,0.4
Arial Unicode MS,8
390d4d7c8d674b1eba89f827138ffc29
Center
True
0,0,0,0
lblOutstanding1
Outstanding
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
White
17.6,0,6.6,0.4
Arial Unicode MS,8
3c9679af7b52424f9555c8b06b43b912
Center
True
0,0,0,0
Text9
Black
Expression
Center
7e4c67b5027141bcac6e5d568a953eb4
hdrBndSubmittal2
True
if(SumD(dsClosed,dsClosed.Overdue) > 0){
this.txtFtrOverDue1.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
}
if(SumD(dsClosed,dsClosed.Rejected) > 0 ) {
this.txtFtrRejected1.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
} else {
this.txtFtrRejected1.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black);
}
this.txtFtrOverDue1.Border = new Stimulsoft.Base.Drawing.StiBorder(((Stimulsoft.Base.Drawing.StiBorderSides.None | Stimulsoft.Base.Drawing.StiBorderSides.Right)
| Stimulsoft.Base.Drawing.StiBorderSides.Bottom | Stimulsoft.Base.Drawing.StiBorderSides.Top), System.Drawing.Color.Silver, 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black), false);
White
0,4.69,27.7,0.4
Top, Left, Right;Silver;1;Solid;False;4;Black
White
True
0,0,6.6,0.4
Arial Unicode MS,8
54724e163a014dea88875c93ca55c2be
True
0,0,0,0
Text3
{dsClosed.Discipline}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
dsClosed.Rejected,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,Top_x002C__x0020_Right_x002C__x0020_Bottom
Arial Unicode MS,8
d51e0414799943b5a2e016cad0188371
Center
True
0,0,0,0
txtRejected1
{dsClosed.Rejected}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
19.8,0,2.2,0.4
dsClosed.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,All
Arial Unicode MS,8
73dffb6721a84d31b100339ddad88dba
Center
True
0,0,0,0
txtOverdue
{dsClosed.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
17.6,0,2.2,0.4
Arial Unicode MS,8
1decee74f92342a3ace328e58df27782
Center
True
0,0,0,0
Text34
{dsClosed.Outstanding}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
15.4,0,2.2,0.4
Arial Unicode MS,8
57ca23192ed9467d9c149625e68a0b7f
Center
True
0,0,0,0
Text39
{dsClosed.gtSevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
13.2,0,2.2,0.4
Arial Unicode MS,8
06b3326b34244d169ddaf1003f01b589
Center
True
0,0,0,0
Text43
{dsClosed.fourTosevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
11,0,2.2,0.4
Arial Unicode MS,8
4384fbb152c040ed8f10c42f6a4b8f23
Center
True
0,0,0,0
Text48
{dsClosed.zeroTothreeDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
8.8,0,2.2,0.4
Arial Unicode MS,8
5b75069380f44106818fd0c17a71e1cb
Center
True
0,0,0,0
Text51
{dsClosed.Closed}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
6.6,0,2.2,0.4
Arial Unicode MS,8
7fdab7f7d157418a91703fe68f735c50
Center
True
0,0,0,0
Text53
{dsClosed.Raised}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
dsClosed
db5412eebef64b1b920857c035c025b5
DatadsClosed
Transparent
0,5.89,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
True
6.6,0,2.2,0.4
Arial Unicode MS,8
50b73c3f8fd84a79987570d12d16f64e
Center
True
0,0,0,0
txtFtrRaised1
{Sum(dsClosed.Raised)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
8.8,0,2.2,0.4
Arial Unicode MS,8
5fbb266659ff48a4b65e0f054f92551b
Center
True
0,0,0,0
txtFtrClosed1
{Sum(dsClosed.Closed)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
11,0,2.2,0.4
Arial Unicode MS,8
040e17a37f454aceb9251753379db699
Center
True
0,0,0,0
txtFtrZeroToThreeDays1
{Sum(dsClosed.zeroTothreeDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
True
13.2,0,2.2,0.4
Arial Unicode MS,8
c887ea37c75b4a2e8cd848affa1aa458
Center
True
0,0,0,0
txtFtrFourToSevenDays1
{Sum(dsClosed.fourTosevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
True
15.4,0,2.2,0.4
Arial Unicode MS,8
b0f3dffadf6246ac82c40f6b8ae8c59a
Center
True
0,0,0,0
txtGtFtrSevenDays1
{Sum(dsClosed.gtSevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
4,0,2.6,0.4
Arial Unicode MS,8
9f97663d6a5c4d4c910227ad54868e84
Center
True
0,0,0,0
lblFtrTotal
Total
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
Arial Unicode MS,8
3279de0a4e0443218c8da16d820f3ecb
Center
True
0,0,0,0
txtFtrRejected1
{SumD(dsClosed.Rejected)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
True
17.6,0,2.2,0.4
Arial Unicode MS,8
631dcc34a111495d9ce5fbe70dde417a
Center
True
0,0,0,0
txtFtrOutstanding1
{Sum(dsClosed.Outstanding)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
19.8,0,2.2,0.4
Arial Unicode MS,8
636677d988d74e4ca552d1dfe780f242
Center
True
0,0,0,0
txtFtrOverDue1
{Sum(dsClosed.Overdue)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,4,0.4
Arial Unicode MS,8
c05d5379eb544381abea36ec8e41fefe
Center
True
0,0,0,0
Text54
Black
Expression
Center
1b8e20b6647d408293ada6d38cc364e0
ftrBndClosed
b3c660500d2f448b8e188f766c9cb8d8
True
1,1,1,1
LayoutOne
Landscape
21
29.7
Letter
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
7d4e6f53fe974c638405a1c0e1cb2204
0,0,0,0
Text7
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
3017ec2d3a124785b226c4f2ba844799
0,0,0,0
Text8
Business Entity: {pBusEntText} - Project No. {pProjectText} - Register: {pCmDefnText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
9fdb9b182bf940b384dfb5af12c04a6d
Right
0,0,0,0
Text10
{pCompanyName}
[64:82:94]
Expression
5fd9167400024a108130983f63d4b636
PageHeaderBand1
ExceptFirstPage
Transparent
0,75.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
edc18107bc1c45cb87b23f4ad8567755
0,0,0,0
Text17
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
87e51266638547198b31b59271a173b4
Right
0,0,0,0
Text18
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
320c6d1bf23b4e7cb04bcd231b7552e2
HorizontalLinePrimitive1
Black
75647b62a9f04674967d29eeafb694e2
PageFooterBand1
Left;Silver;1;Solid;False;4;Black
Transparent
0,3.05,27.7,0.85
Right;Silver;1;Solid;False;4;Black
Transparent
8.8,0.42,2.2,0.42
Arial Unicode MS,8
7d65eedbcec2492489f9ddacde339239
Center
True
0,0,0,0
lblSubmitted2
Submitted
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
0,0,6.6,0.42
Arial Unicode MS,8,Bold
8cd403eb1b6c4711aa16e125752b71c0
True
0,0,0,0
txtCmDefnDescription2
{dsOutstanding.cmdefndescription}
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0,2.2,0.42
Arial Unicode MS,8
71f59204487f48ba8f06a16113cdc92c
True
0,0,0,0
Text44
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
8.8,0,2.2,0.42
Arial Unicode MS,8
b688cc60e71441f89fa1ade2c501936b
True
0,0,0,0
Text45
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
13.2,0,2.2,0.42
Arial Unicode MS,8
f9caed1296794f4b913475845a023255
True
0,0,0,0
Text46
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
15.4,0.42,2.2,0.42
Arial Unicode MS,8
11176aeec2804b08a9493e58462d8fc0
Center
True
0,0,0,0
lblOverDue2
Overdue
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
17.6,0.42,2.2,0.42
Arial Unicode MS,8
0c5684576f914cb99cdaa2eac860c15a
Center
True
0,0,0,0
lblZeroToThreeDays2
0-3 days
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
19.8,0.42,2.2,0.42
Arial Unicode MS,8
42564e10eb1c4d318efd9cf81932e1bb
Center
True
0,0,0,0
lblFourToSevenDays2
4-7 days
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
22,0.42,2.2,0.42
Arial Unicode MS,8
238dcd60bbc2404a925b048709627444
Center
True
0,0,0,0
lblGtSevenDays
>7 days
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
[216:216:216]
17.6,0,6.6,0.42
Arial Unicode MS,8
e478bf5e007e4830bb44010ed7ddce4b
Center
True
0,0,0,0
Text52
Under Review
Black
Expression
Center
Top, Left, Right;Silver;1;Solid;False;4;Black
White
11,0.42,2.2,0.42
Arial Unicode MS,8
7ec1e644856d433da445ba126e27d75b
Center
True
0,0,0,0
lblResponded2
Responded
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
11,0,2.2,0.4
Arial Unicode MS,8
4680e9554c6c4d10b76f488ed3a0ae92
True
0,0,0,0
Text58
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
13.2,0.42,2.2,0.42
Arial Unicode MS,8
220cfc02e7634b2f80b31bd5ce0e2aaf
Center
True
0,0,0,0
lblOutstanding2
Outstanding
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
6.6,0.42,2.2,0.42
Arial Unicode MS,8
7d2d71bfef2a4773bad2dd18d92e1c67
Center
True
0,0,0,0
lblTotal2
Total
Black
Expression
Center
Right;Silver;1;Solid;False;4;Black
Transparent
0,0.42,6.6,0.42
Arial Unicode MS,8
e36f53d3288b40eb8c011a5bb40e71dc
True
0,0,0,0
lblDiscipline2
Discipline
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
15.4,0,2.2,0.42
Arial Unicode MS,8
9e1b09a9bc6f465b90d9ab63dc9adae5
Center
True
0,0,0,0
Text33
Black
Expression
Center
834cafaa1116440e92bc90ec568ee851
hdrBndLayout2
True
if(SumD(dsOutstanding,dsOutstanding.Overdue) >0 ) {
this.txtFtrOverdue2.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
} else {
this.txtFtrOverdue2.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black);
}
this.txtFtrOverdue2.Border = new Stimulsoft.Base.Drawing.StiBorder(((Stimulsoft.Base.Drawing.StiBorderSides.None | Stimulsoft.Base.Drawing.StiBorderSides.Right)
| Stimulsoft.Base.Drawing.StiBorderSides.Bottom), System.Drawing.Color.Silver, 1, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black), false);
Left;Silver;1;Solid;False;4;Black
Transparent
0,4.7,27.7,0.4
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
0,0,6.6,0.4
Arial Unicode MS,8
3aa86224e250425897caad4da6539355
True
0,0,0,0
txtDiscipline2
{dsOutstanding.Discipline}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
13.2,0,2.2,0.4
Arial Unicode MS,8
7cd86815fa8e446690792690edfbc838
Center
True
0,0,0,0
txtOutstanding2
{dsOutstanding.Outstanding}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
15.4,0,2.2,0.4
dsOutstanding.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,All
Arial Unicode MS,8
4f0ce7333c8e4e26afc96cfda97c4c34
Center
True
0,0,0,0
txtOverdue2
{dsOutstanding.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
17.6,0,2.2,0.4
Arial Unicode MS,8
a4deced746704199aa571c43a8148572
Center
True
0,0,0,0
txtZeroToThreeDays2
{dsOutstanding.zeroTothreeDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
19.8,0,2.2,0.4
Arial Unicode MS,8
5633e2e3d005416c9491c6f9296eefc0
Center
True
0,0,0,0
txtFourToSevenDays2
{dsOutstanding.fourTosevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
Arial Unicode MS,8
73988988eca145edb5327651922ad2ab
Center
True
0,0,0,0
txtGtSevenDays2
{dsOutstanding.gtSevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
Transparent
True
6.6,0,2.2,0.4
Arial Unicode MS,8
223befa824d94c3488e19bd9a4011cd3
Center
True
0,0,0,0
txtTotal2
{dsOutstanding.Total}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
8.8,0,2.2,0.4
Arial Unicode MS,8
0161ce78943447928c5b30ac38e41aa9
Center
True
0,0,0,0
txtSubmitted2
{dsOutstanding.Submitted}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;DarkGray;1;Solid;False;4;Black
White
True
11,0,2.2,0.4
Arial Unicode MS,8
45907b0c47ad47be87a82b4cee385c8b
Center
True
0,0,0,0
Text13
{dsOutstanding.Responded}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
dsOutstanding
62b927ffa08d42a08a60bc875cb5addb
DatadsLayout2
Transparent
0,5.9,27.7,0.4
All;DarkGray;1;Solid;False;4;Black
Transparent
True
6.6,0,2.2,0.4
Arial Unicode MS,8
b1c2611ca872443cbeb9f1f4d9493d8b
Center
True
0,0,0,0
txtFtrTotal2
{Sum(dsOutstanding.Total)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
8.8,0,2.2,0.4
Arial Unicode MS,8
52de21d6dfb74eabb3bc0d71c3fc10e7
Center
True
0,0,0,0
txtFtrSubmitted2
{Sum(dsOutstanding.Submitted)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
13.2,0,2.2,0.4
Arial Unicode MS,8
5bf5379361db4b15b6436cef3f8464b7
Center
True
0,0,0,0
txtFtrOutstanding2
{Sum(dsOutstanding.Outstanding)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
15.4,0,2.2,0.4
Arial Unicode MS,8
b8058fa7e7374e7fa125ffd2d63b6682
Center
True
0,0,0,0
txtFtrOverdue2
{Sum(dsOutstanding.Overdue)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
17.6,0,2.2,0.4
Arial Unicode MS,8
ba78d145679c42019cd02c1173cb94e7
Center
True
0,0,0,0
txtFtrZeroToThreeDays2
{Sum(dsOutstanding.zeroTothreeDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
19.8,0,2.2,0.4
Arial Unicode MS,8
48b27dff090d428e9ddfc51913c94b91
Center
True
0,0,0,0
txtFtrFourToSevenDays2
{Sum(dsOutstanding.fourTosevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;DarkGray;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
Arial Unicode MS,8
319cbf96a240432caad2155629467353
Center
True
0,0,0,0
txtFtrGtSevenDays2
{Sum(dsOutstanding.gtSevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
11,0,2.2,0.4
Arial Unicode MS,8
d3a634af0db94e4692edde89490a1b5f
Center
True
0,0,0,0
Text12
{Sum(dsOutstanding.Responded)}
Black
Expression
Center
Top, Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
4,0,2.6,0.4
Arial Unicode MS,8
757c238e8c9d42429dceaca2665ac043
Center
True
0,0,0,0
Text74
Total
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,4,0.4
Arial Unicode MS,8
cdb5007f99814f6caf5472f40c5d4537
Center
True
0,0,0,0
Text77
Black
Expression
Center
d96df93472664e26ae4faa35d1b9d1b6
ftrBndLayout2
ef779409bf214da68ae087b4e51d48db
True
1,1,1,1
LayoutTwo
Landscape
21
29.7
Letter
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
2af2f198902d4ccf8531560d3dc19630
0,0,0,0
Text11
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
f4f3e3a6ae184951b1d750ac85f5bb9f
0,0,0,0
Text14
Business Entity: {pBusEntText} - Project No. {pProjectText} - Register: {pCmDefnText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
cd717217e8194ba598a6e6809098f02f
Right
0,0,0,0
Text15
{pCompanyName}
[64:82:94]
Expression
eb93776b7de9438e80e842061b85ec91
PageHeaderBand2
ExceptFirstPage
Transparent
0,18.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
53986069ddf246ba970587885055814f
0,0,0,0
Text19
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
2d9239fa664f44298e51e8ffe49a0ed0
Right
0,0,0,0
Text23
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
31ea4210236d414fb400a085d80e0ae9
HorizontalLinePrimitive2
Black
44c0eecbb2b046a7a35c59c24353cca5
PageFooterBand2
Left;Silver;1;Solid;False;4;Black
Transparent
0,3.05,27.7,0.8
Left, Right, Bottom;Silver;1;Solid;False;4;Black
White
0,0.4,6.6,0.4
Arial Unicode MS,8
029370244915466abe089c71ece28caf
True
0,0,0,0
Text59
Originator
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0.4,2.2,0.4
Arial Unicode MS,8
0630e8062b424f3592ed19c1ffe2654f
Center
True
0,0,0,0
lblTotal3
Total
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
8.8,0.4,2.2,0.4
Arial Unicode MS,8
adc8bdf9a14f45e083b1ef3792a59631
Center
True
0,0,0,0
lblSubmitted3
Submitted
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
13.2,0.4,2.2,0.4
Arial Unicode MS,8
3e909793d9af46cf9ab17924663bcbff
Center
True
0,0,0,0
lblOutstanding3
Outstanding
Black
Expression
Center
Top, Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
0,0,6.6,0.4
Arial Unicode MS,8,Bold
8092096be1d44f55a09bb88543e68ac8
True
0,0,0,0
txtCmDefnDescription3
{dsOriginator.cmdefndescription}
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
6.6,0,2.6,0.4
Arial Unicode MS,8
73dd3c0e2803499989ee87ddf801bcb3
True
0,0,0,0
Text64
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
9.2,0,2.6,0.4
Arial Unicode MS,8
98afb83e92eb479790c6dc3f89c5f1f4
True
0,0,0,0
Text65
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
14.4,0,3.2,0.4
Arial Unicode MS,8
6d1c8d67b83c4f41a6d34ceaf3a710cb
True
0,0,0,0
Text66
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
15.4,0.4,2.2,0.4
Arial Unicode MS,8
e372d27a714f416faa22319a811f7bf2
Center
True
0,0,0,0
lblOverDue3
Overdue
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
17.6,0.4,2.2,0.4
Arial Unicode MS,8
4d7f057ee12d4274b9986e7659a78ba5
Center
True
0,0,0,0
lblZeroToThreeDays
0-3 days
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
19.8,0.4,2.2,0.4
Arial Unicode MS,8
05acdb7b5c8a40f9ac9e8fd5a8a8d864
Center
True
0,0,0,0
lblFourToSevenDays
4-7 days
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
22,0.4,2.2,0.4
Arial Unicode MS,8
c63cb0a6481e4a80a61bdbf0e8e3e415
Center
True
0,0,0,0
lblGtSevenDays3
>7 days
Black
Expression
Center
Top, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
20.6,0,2.6,0.4
Arial Unicode MS,8
ae42e0867cda424093fdc21e00bfe2e7
True
0,0,0,0
Text73
Black
Expression
Center
Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
11,0.4,2.2,0.4
Arial Unicode MS,8
83bd7663db0d42ecad7dcd43e8b868a6
Center
True
0,0,0,0
lblResponded3
Responded
Black
Expression
Center
Top, Bottom;Silver;1;Solid;False;4;Black
Transparent
11.8,0,2.6,0.4
Arial Unicode MS,8
9daa6578533448b1bd62c4078bebc8d1
True
0,0,0,0
Text76
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
[216:216:216]
17.6,0,6.6,0.4
Arial Unicode MS,8
97f3d91f02b64a32bb4c69e41d733493
Center
True
0,0,0,0
Text55
Under Review
Black
Expression
Center
dc1793b81d6a4d35923c8f1a011d6450
hdrLayout3
True
if(SumD(dsOriginator,dsOriginator.Overdue) >0 ) {
this.txtFtrOverdue3.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
} else {
this.txtFtrOverdue3.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black);
}
Transparent
0,4.65,27.7,0.4
Top, Left, Right;Silver;1;Solid;False;4;Black
Transparent
True
0,0,6.6,0.4
Arial Unicode MS,8
True
89eaa1b2c1574ede89118475c4a109e8
True
0,0,0,0
DatadsOriginator_Originator
{dsOriginator.Originator}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;Silver;1;Solid;False;4;Black
Transparent
True
6.6,0,2.2,0.4
Arial Unicode MS,8
True
458e3ebef1de49c4a3c43a8fd87c899b
Center
True
0,0,0,0
txtTotal3
{dsOriginator.Total}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
True
8.8,0,2.2,0.4
Arial Unicode MS,8
True
95a1e71fc4754e1e88fb8e8d9fbbbdfe
Center
True
0,0,0,0
DatadsOriginator_Submitted
{dsOriginator.Submitted}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
True
13.2,0,2.2,0.4
Arial Unicode MS,8
True
f0d243aa6b024e1dbbaa39da6291b202
Center
True
0,0,0,0
txtOutstanding3
{dsOriginator.Outstanding}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Left, Right;Silver;1;Solid;False;4;Black
White
True
15.4,0,2.2,0.4
dsOriginator.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,All
Arial Unicode MS,8
True
4f0154ef9e0b4f4c88ff146ce2fd5989
Center
True
0,0,0,0
txtOverdu3
{dsOriginator.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
True
19.8,0,2.2,0.4
Arial Unicode MS,8
True
8f67f676ffde46bdbe586db5ce4323a1
Center
True
0,0,0,0
txtFourToSevenDays3
{dsOriginator.fourTosevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
Arial Unicode MS,8
True
e1e2939aaf5f4674a5f18aee9b674c19
Center
True
0,0,0,0
txtGtSevenDays3
{dsOriginator.gtSevenDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Left, Right;Silver;1;Solid;False;4;Black
White
11,0,2.2,0.4
Arial Unicode MS,8
True
3352f82d3fca4c2cb5376f8d37dff6fd
Center
True
0,0,0,0
txtResponded3
{dsOriginator.Responded}
Black
Expression
Center
Top, Left, Right;Silver;1;Solid;False;4;Black
White
True
17.6,0,2.2,0.4
Arial Unicode MS,8
True
7e80322ca72a42c78fa3e167b426b8e3
Center
True
0,0,0,0
Text72
{dsOriginator.zeroTothreeDays}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
dsOriginator
520f6dfcc9e84d54b33b74ad5ab39473
DatadsOriginator
Transparent
0,5.85,27.7,0.4
All;Silver;1;Solid;False;4;Black
Transparent
True
6.6,0,2.2,0.4
Arial Unicode MS,8
b7841840f2a84692a7dca194c6b706a3
Center
True
0,0,0,0
Text1
{Sum(dsOriginator.Total)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
8.8,0,2.2,0.4
Arial Unicode MS,8
0e9ceee49b0348cd9c7faeb00807e76d
Center
True
0,0,0,0
Text36
{Sum(dsOriginator.Submitted)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
13.2,0,2.2,0.4
Arial Unicode MS,8
a6f978a92055400fb88cc2bc3b903fde
Center
True
0,0,0,0
txtFtrOutstanding
{Sum(dsOriginator.Outstanding)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
White
True
15.4,0,2.2,0.4
Arial Unicode MS,8
9a3258f9dc5a426eb6735abb303b5763
Center
True
0,0,0,0
txtFtrOverdue3
{Sum(dsOriginator.Overdue)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
17.6,0,2.2,0.4
Arial Unicode MS,8
591af2a83e2a4fd5b16aa73be09d0c56
Center
True
0,0,0,0
txtFtrZeroToThreeDays3
{Sum(dsOriginator.zeroTothreeDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
19.8,0,2.2,0.4
Arial Unicode MS,8
8525bb53d45c4873be156e44e2bbfd2c
Center
True
0,0,0,0
txtFtrFourToSevenDays3
{Sum(dsOriginator.fourTosevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
True
22,0,2.2,0.4
Arial Unicode MS,8
404b986a055d47a1b3877668b29fd3e8
Center
True
0,0,0,0
txtFtrGtSevenDays3
{Sum(dsOriginator.gtSevenDays)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
11,0,2.2,0.4
Arial Unicode MS,8
642dae5fa75e4cabac0bb163b3cac61c
Center
True
0,0,0,0
txtFtrResponded3
{Sum(dsOriginator.Responded)}
Black
Expression
Center
Top, Left, Bottom;Silver;1;Solid;False;4;Black
Transparent
4,0,2.6,0.4
Arial Unicode MS,8
8e362b6671674264bcc0579e4a5ec189
Center
True
0,0,0,0
Text78
Total
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,4,0.4
Arial Unicode MS,8
7855592635b8475a92ee80181b5b7058
Center
True
0,0,0,0
Text84
Black
Expression
Center
bd3420ed971c4e35a8730a1cfd844c3c
FooterBand1
2382e61b8a7e44d182e5264b96522191
1,1,1,1
LayoutThree
Landscape
21
29.7
Letter
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
2af2f198902d4ccf8531560d3dc19630
0,0,0,0
Text16
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
f4f3e3a6ae184951b1d750ac85f5bb9f
0,0,0,0
Text27
Business Entity: {pBusEntText} - Project No. {pProjectText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
cd717217e8194ba598a6e6809098f02f
Right
0,0,0,0
Text28
{pCompanyName}
[64:82:94]
Expression
eb93776b7de9438e80e842061b85ec91
PageHeaderBand4
ExceptFirstPage
Transparent
0,18.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
53986069ddf246ba970587885055814f
0,0,0,0
Text29
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
2d9239fa664f44298e51e8ffe49a0ed0
Right
0,0,0,0
Text30
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
31ea4210236d414fb400a085d80e0ae9
HorizontalLinePrimitive4
Black
44c0eecbb2b046a7a35c59c24353cca5
PageFooterBand4
Left;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,6.6,0.42
Arial Unicode MS,8,Bold
8092096be1d44f55a09bb88543e68ac8
True
0,0,0,0
Text35
Workflow Tracker by Activity Owner
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
6.6,0,6.8,0.42
Arial Unicode MS,8
73dd3c0e2803499989ee87ddf801bcb3
True
0,0,0,0
Text37
Black
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
13.4,0,4.4,0.42
Arial Unicode MS,8
98afb83e92eb479790c6dc3f89c5f1f4
True
0,0,0,0
Text38
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
0,0.42,6.6,0.42
Arial Unicode MS,8,Bold
f56ef580d595447f86136931b9d05fa9
True
0,0,0,0
lblProcessWorflow4
Process Workflow
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.6,0.42,6.8,0.42
Arial Unicode MS,8,Bold
84ad4b8dc85946198f483a05ca7871c7
True
0,0,0,0
lblPerson4
Person
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
13.4,0.42,2.2,0.42
Arial Unicode MS,8,Bold
7e055b36e2464ad081148b5b829ccb62
Center
True
0,0,0,0
lblProgress4
In Progress
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.6,0.42,2.2,0.42
Arial Unicode MS,8,Bold
f32bd7fab7fb4d3f976a0d0a1c5d3b0a
Center
True
0,0,0,0
Text42
Overdue
Black
Expression
Center
dc1793b81d6a4d35923c8f1a011d6450
hdrLayout4
True
if(SumD(dsOriginator,dsOriginator.Overdue) >0 ) {
this.txtFtrOverdue4.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
}
Transparent
0,4.69,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
0,0,6.6,0.42
Arial Unicode MS,8
cfef2c8ce5524060b6f616581348490a
True
0,0,0,0
txtProcessWorkflow4
{dsLayout4.Process_Workflow}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.6,0,6.8,0.42
Arial Unicode MS,8
202cd1ec740b4a5094f645a7f108e77c
True
0,0,0,0
txtPerson4
{dsLayout4.Person}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
13.4,0,2.2,0.42
Arial Unicode MS,8
7a9e68f408184b85b83dd66682a5423d
Center
True
0,0,0,0
txtProgress4
{dsLayout4.In_Progress}
Black
DataColumn
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.6,0,2.2,0.42
dsLayout4.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,Left_x002C__x0020_Right_x002C__x0020_Bottom
Arial Unicode MS,8
1c88088d0b994312a0a11df7c3c0218e
Center
True
0,0,0,0
Text41
{dsLayout4.Overdue}
Black
DataColumn
Center
dsLayout4
DatadsLayout4
Transparent
0,5.91,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
13.4,0,2.2,0.42
Arial Unicode MS,8
38014ede7f1947fbab26d5d35614b2c2
Center
True
0,0,0,0
txtFtrProgress4
{Sum(dsLayout4.In_Progress)}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.6,0,2.2,0.42
Arial Unicode MS,8
c49c62b911d2441897099374b246edb1
Center
True
0,0,0,0
txtFtrOverdue4
{Sum(dsLayout4.Overdue)}
Black
Expression
Center
Left, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
10.8,0,2.6,0.42
Arial Unicode MS,8
20e7c4fdaf824dbe9dc1c2876f3702c6
Center
True
0,0,0,0
Text69
Total
Black
Expression
Center
FooterBand2
1428496a622145e1b5c481719ba663b6
1,1,1,1
LayoutFour
Landscape
21
29.7
Letter
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
2af2f198902d4ccf8531560d3dc19630
0,0,0,0
Text57
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
f4f3e3a6ae184951b1d750ac85f5bb9f
0,0,0,0
Text60
Business Entity: {pBusEntText} - Project No. {pProjectText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
cd717217e8194ba598a6e6809098f02f
Right
0,0,0,0
Text61
{pCompanyName}
[64:82:94]
Expression
eb93776b7de9438e80e842061b85ec91
PageHeaderBand5
ExceptFirstPage
Transparent
0,18.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
53986069ddf246ba970587885055814f
0,0,0,0
Text62
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
2d9239fa664f44298e51e8ffe49a0ed0
Right
0,0,0,0
Text63
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
31ea4210236d414fb400a085d80e0ae9
HorizontalLinePrimitive5
Black
44c0eecbb2b046a7a35c59c24353cca5
PageFooterBand5
Left;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,6.2,0.42
Arial Unicode MS,8,Bold
d7fb88b51365419f89d73020fbda4440
True
0,0,0,0
Text31
Workflow Tracker by Activity Owner Company
Black
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
6.2,0,10.6,0.42
Arial Unicode MS,8
70e00ad6a2224ceda53633498d0a9bc2
True
0,0,0,0
Text32
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
0,0.42,6.2,0.42
Arial Unicode MS,8,Bold
f996b0df4cbc44659bb1b4680d8ceaad
True
0,0,0,0
Text40
Process Workflow
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.2,0.42,6.2,0.42
Arial Unicode MS,8,Bold
c977481708fb4ad6a212c415f5c7ade7
True
0,0,0,0
lblCompany5
Company
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
12.4,0.42,2.2,0.42
Arial Unicode MS,8,Bold
12b30b8bc1dd4172b9e12f32d9392cd8
Center
True
0,0,0,0
lblProgress5
In Progress
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
14.6,0.42,2.2,0.42
Arial Unicode MS,8,Bold
0a45abb37a22443abbc66d1250c3bee0
Center
True
0,0,0,0
lblOverdue5
Overdue
Black
Expression
Center
18061646eefb4454a6e6e58ed9767196
HeaderBand1
True
if(SumD(dsLayout5,dsLayout5.Overdue) > 0 ) {
this.txtFtrOverdue5.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
}
Transparent
0,4.69,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
0,0,6.2,0.42
Arial Unicode MS,8
762748ca53d94dcbadb705e15ac195bc
True
0,0,0,0
txtWorkflow5
{dsLayout5.Process_Workflow}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.2,0,6.2,0.42
Arial Unicode MS,8
6c72b68267c546909adc90ac04df6198
True
0,0,0,0
txtCompany5
{dsLayout5.Company}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
12.4,0,2.2,0.42
Arial Unicode MS,8
adb20ea7ce774e8f95eca006ed3d5d8a
Center
True
0,0,0,0
txtProgress5
{dsLayout5.In_Progress}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
14.6,0,2.2,0.42
dsLayout5.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,Left_x002C__x0020_Right_x002C__x0020_Bottom
Arial Unicode MS,8
804ddbdc352448fba6849b0d3c9f8a2c
Center
True
0,0,0,0
txtOverDue5
{dsLayout5.Overdue}
Black
Expression
Center
dsLayout5
DatadsLayout5
Transparent
0,5.91,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
12.4,0,2.2,0.42
Arial Unicode MS,8
d6ad5dc2b8484d47a39ac0c0f4b21ad9
Center
True
0,0,0,0
Text75
{Sum(dsLayout5.In_Progress)}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
14.6,0,2.2,0.42
Arial Unicode MS,8
503f1a27c6f447a083ad273c2ea4f1ba
Center
True
0,0,0,0
txtFtrOverdue5
{Sum(dsLayout5.Overdue)}
Black
Expression
Center
Left, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
9.8,0,2.6,0.42
Arial Unicode MS,8
e8e5c6c27f554a5e9b1a0ae203beee81
Center
True
0,0,0,0
Text70
Total
Black
Expression
Center
d7bd1f3e87584ce2bd74b3db0af98e32
FooterBand3
b2e6f4adefc3404fbd0fc44b028692c7
1,1,1,1
LayoutFive
Landscape
21
29.7
Letter
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
2af2f198902d4ccf8531560d3dc19630
0,0,0,0
Text94
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
f4f3e3a6ae184951b1d750ac85f5bb9f
0,0,0,0
Text95
Business Entity: {pBusEntText} - Project No. {pProjectText}
[64:82:94]
Expression
Transparent
20.32,0.25,7.37,0.41
Arial Unicode MS,8.25,Italic
cd717217e8194ba598a6e6809098f02f
Right
0,0,0,0
Text96
{pCompanyName}
[64:82:94]
Expression
eb93776b7de9438e80e842061b85ec91
PageHeaderBand6
ExceptFirstPage
Transparent
0,18.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
53986069ddf246ba970587885055814f
0,0,0,0
Text97
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
2d9239fa664f44298e51e8ffe49a0ed0
Right
0,0,0,0
Text98
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
31ea4210236d414fb400a085d80e0ae9
HorizontalLinePrimitive6
Black
44c0eecbb2b046a7a35c59c24353cca5
PageFooterBand6
Left;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
Top;Silver;1;Solid;False;4;Black
Transparent
0,0,6.2,0.42
Arial Unicode MS,8,Bold
331d74bd3a774bad95cdd8b6b560ab74
True
0,0,0,0
lblWorkflowTracker
Workflow Tracker by Workflow Owner
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
6.2,0,6.8,0.42
Arial Unicode MS,8
8dee45efe3f04657a34b7c670161f7c7
True
0,0,0,0
Text47
Black
Expression
Center
Top;Silver;1;Solid;False;4;Black
Transparent
13,0,2.2,0.42
Arial Unicode MS,8
b7571477ec09488fa2d46d48e4c76bd2
True
0,0,0,0
Text49
Black
Expression
Center
Top, Right;Silver;1;Solid;False;4;Black
Transparent
15.2,0,2.2,0.84
Arial Unicode MS,8
673fd276f8044817996a8d30fe6a0825
True
0,0,0,0
Text67
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
0,0.42,6.2,0.42
Arial Unicode MS,8,Bold
8f65f124d40e415b968f311a72c7176d
True
0,0,0,0
lblProcessWorkflow6
Process Workflow
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.2,0.42,6.8,0.42
Arial Unicode MS,8,Bold
74acbc7a18d940888f54d44d7208abb9
True
0,0,0,0
lblResponsibleOwner
Responsible Owner
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
13,0.42,2.2,0.42
Arial Unicode MS,8,Bold
1203770d891c4d66a16856fbcaf19f8a
Center
True
0,0,0,0
lblProgress6
In Progress
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.2,0.42,2.2,0.42
Arial Unicode MS,8,Bold
919886f4973f49c8a5ef5432db71e247
Center
True
0,0,0,0
lblOverdue6
Overdue
Black
Expression
Center
87a036000e264ef4a7bd70ce2725f170
HeaderBand2
True
if(SumD(dsLayout6,dsLayout6.Overdue) > 0 ) {
this.txtFtrOverdue6.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
}
Transparent
0,4.69,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
0,0,6.2,0.42
Arial Unicode MS,8
36fe056a567b44379b5a34ae7e701545
True
0,0,0,0
txtProcessWorkflow6
{dsLayout6.Process_Workflow}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
6.2,0,6.8,0.42
Arial Unicode MS,8
77173fc446284d92a27534994a8b744d
True
0,0,0,0
txtPerson6
{dsLayout6.Person}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
13,0,2.2,0.42
Arial Unicode MS,8
bfb4391bc6954957bc23b0aaa0cb8605
Center
True
0,0,0,0
txtProgress6
{dsLayout6.In_Progress}
Black
DataColumn
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.2,0,2.2,0.42
dsLayout6.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,Left_x002C__x0020_Right_x002C__x0020_Bottom
Arial Unicode MS,8
e248465d79a74c2b80c49f44a5289e9b
Center
True
0,0,0,0
txtOverdue6
{dsLayout6.Overdue}
Black
DataColumn
Center
dsLayout6
DatadsLayout6
Transparent
0,5.91,27.7,0.42
All;Silver;1;Solid;False;4;Black
Transparent
13,0,2.2,0.42
Arial Unicode MS,8
cca1ea1f1f6d447a874274557f3b326b
Center
True
0,0,0,0
Text68
{Sum(dsLayout6.In_Progress)}
Black
Expression
Center
All;Silver;1;Solid;False;4;Black
Transparent
15.2,0,2.2,0.42
Arial Unicode MS,8
a7b15d906f7c4135a7d9a107b943d576
Center
True
0,0,0,0
txtFtrOverdue6
{Sum(dsLayout6.Overdue)}
Black
Expression
Center
Left, Right, Bottom;Silver;1;Solid;False;4;Black
Transparent
10.4,0,2.6,0.42
Arial Unicode MS,8
12f051b875134d7c95187ae2b82c1456
Center
True
0,0,0,0
Text71
Total
Black
Expression
Center
803d841e82da4268b88c7f80539dd054
FooterBand4
df78136a00a64b9eabd77a711867be06
1,1,1,1
LayoutSix
Landscape
21
29.7
Letter
True
Arial,100
[50:0:0:0]
None;Silver;1;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
0b54732b0ac6419f9927eefcf39652de
0,0,0,0
Text100
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
f4623488769a44dca5463ab6cfdd6530
0,0,0,0
Text103
Business Entity: {pBusEntText} - Project No. {pProjectText}
[64:82:94]
Expression
d0722a5001ca4d96a41f1f95099d1c95
PageHeaderBand9
ExceptFirstPage
Transparent
0,75.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
1932bc347c9a4079ac770582105bc762
0,0,0,0
Text149
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
c0f85ca7ae7047b782b551cc87b62512
Right
0,0,0,0
Text150
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
41c2c53ef27e453cbfff51282ad8d340
HorizontalLinePrimitive12
Black
b6862b455285494cb6288c01ec8eb5d5
PageFooterBand8
Bottom;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
None;Silver;1;Solid;False;4;Black
White
0,0,27.7,0.42
Arial Unicode MS,8,Bold
3ee923c78b21457c85bc6db4c92bfec3
True
0,0,0,0
Text104
Workflow Tracker by Workflow Responsible Owner & Current Activity to action
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
0,0.42,6.2,0.42
Arial Unicode MS,8,Bold
6986def397c6427faadcc3df5f76875f
True
0,0,0,0
Text105
Process Workflow
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
6.2,0.42,6.6,0.42
Arial Unicode MS,8,Bold
35a23413fe094f18a23afbd8b147feb3
True
0,0,0,0
Text106
Responsible Owner
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
12.8,0.42,1.8,0.42
Arial Unicode MS,8,Bold
1db1d455cf1b45ebadf9db8deaa2e376
Center
True
0,0,0,0
Text107
In Progress
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
14.7,0.42,1.8,0.42
Arial Unicode MS,8,Bold
21763fe245db4d1f895dcb8b618866d2
Center
True
0,0,0,0
Text108
Overdue
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
17.4,0.42,4.8,0.42
Arial Unicode MS,8,Bold
5e2d9d125708425094f60eb1b0c55379
True
0,0,0,0
Text126
Current Activity to action
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
22.2,0.42,5.5,0.42
Arial Unicode MS,8,Bold
3adfe88c6a614618a01e0a7805b657d0
True
0,0,0,0
Text127
Person to action
Black
Expression
Center
Bottom;White;1;Solid;False;4;Black
White
True
16.5,0.42,0.3,0.42
Arial Unicode MS,8,Bold
4913df0d32674e62962ae1506fe8b1cf
Center
True
0,0,0,0
Text128
Red
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
aa6c7b3a53474b4ea20adf504f3b4152
HeaderBand7
True
White
0,4.69,27.7,0.42
None;Silver;1;Solid;False;4;Black
Transparent
True
0,0,6.2,0.42
Arial,8
4b17d6fb18964ebcab2a5a916da692e3
True
0,0,0,0
Text129
{dsLayout7Combined.Process_Workflow}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
6.2,0,6.6,0.42
Arial,8
2d5f092375074610a64f422d43d6e535
True
0,0,0,0
Text130
{dsLayout7Combined.Responsible_Owner}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
12.8,0,1.8,0.42
Arial Unicode MS,8
566dd12b99034f26949b36b886d813c4
Center
True
0,0,0,0
txtGrpInProgress
{dsLayout7Combined.In_Progress}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
14.7,0,1.8,0.42
dsLayout7Combined.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,None
Arial Unicode MS,8
720d3b500ec948d29709cd4330a55f6d
Center
True
0,0,0,0
txtGrpOverdue
{dsLayout7Combined.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
16.8,0,5.4,0.42
Arial Unicode MS,8
597ea9db311d462c9fd293a4dde6126b
True
0,0,0,0
Text133
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
22.2,0,5.5,0.42
Arial Unicode MS,8
894390d76c404fd28eaac9ae1a2a280d
True
0,0,0,0
Text134
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
16.5,0,0.3,0.42
Arial Unicode MS,8,Bold
93de92661a0e4e86a25d986c876b4cc8
Center
True
0,0,0,0
Text135
Red
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
{dsLayout7Combined.Process_Workflow}{dsLayout7Combined.Responsible_Owner}
2bfdde0ad9424ef3807b9573ce4ddce3
GroupHeaderBand4
{dsLayout7Combined.sequenceNo}
Ascending
Min
if(txtFtrTotalOverdue7.TextValue!= "0" ){
this.txtFtrTotalOverdue7.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
} else {
this.txtFtrTotalOverdue7.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black);
}
/*if(dsLayout7Combined.Overdue > 0){
txtExclamation.Enabled = true;
} else {
txtExclamation.Enabled = false;
}*/
None;Silver;1;Solid;False;4;Black
Transparent
0,5.91,27.7,0.42
None;Silver;1;Solid;False;4;Black
Transparent
True
0,0,6.2,0.42
False
Arial Unicode MS,8
True
b37f9a4b5a204412a3b93989d1383f31
True
0,0,0,0
txtProcessWorkflow
{dsLayout7Combined.Process_Workflow}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
6.2,0,6.6,0.42
False
Arial Unicode MS,8
True
f934086230fa4c8e828f36269a5291fd
True
0,0,0,0
txtResponsibleOwner
{dsLayout7Combined.Responsible_Owner}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
12.8,0,1.8,0.42
False
Arial Unicode MS,8
True
e7171862bfe84f04b76e9aab1ff306de
Center
True
0,0,0,0
txtInProgress
{dsLayout7Combined.In_Progress}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
17.4,0,4.8,0.42
Arial Unicode MS,8
True
7b2c2046d58e4d918ab3697a7e0ad359
True
0,0,0,0
txtCurrentActivityToAction
{dsLayout7Combined.Current_Activity_to_Action}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
txtExclamation.Height = txtCurrentActivityToAction.Height;
None;Silver;1;Solid;False;4;Black
Transparent
True
22.3,0,5.4,0.42
Arial Unicode MS,8
True
499bfb4a5d3a499dbe642a631444574c
True
0,0,0,0
txtPersonToAction
{dsLayout7Combined.Person_to_Action} - {dsLayout7Combined.sequenceNo}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
16.4,0,0.4,0.42
Arial Unicode MS,8,Bold
True
95c48779adc64ea1859607b1d8dc8244
Center
True
0,0,0,0
txtExclamation
!
Red
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
22.2,0,0.2,0.42
Arial Unicode MS,8,Bold
True
a2d9b031c85b46228817281b046899d3
Center
True
0,0,0,0
Text142
Red
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
None;Silver;1;Solid;False;4;Black
Transparent
True
14.7,0,1.8,0.42
False
Arial Unicode MS,8
True
7a18f780b0824000beac71bad45b474e
Center
True
0,0,0,0
txtOverdue7
{dsLayout7Combined.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
DataColumn
dsLayout7Combined
974e6d7d40ae4060a39ee3dc30c7d0f2
dsLayoutSeven
ASC
sequenceNo
ASC
Responsible_Owner
ASC
Process_Workflow
ASC
Responsible_Owner
None;Silver;1;Solid;False;4;Black
Transparent
0,7.13,27.7,0.48
None;Silver;1;Solid;False;4;Black
Transparent
True
10.8,0,2.2,0.42
Arial Unicode MS,8
0ceb7cfd480f47b7955561c22133da66
Center
True
0,0,0,0
Text143
Total
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Bottom;Black;1;Double;False;4;Black
Transparent
True
12.8,0,1.8,0.42
Arial Unicode MS,8
aec8924b53b24a00b76c7da959f62dd3
Center
True
0,0,0,0
Text144
{nTotalInProgress}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
None;Silver;1;Double;False;4;Black
Transparent
True
17,0,5.6,0.42
Arial Unicode MS,8
8777dbda08f54323a7b832867a9a3cfa
True
0,0,0,0
Text145
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
22.6,0,5.1,0.42
Arial Unicode MS,8
69fac78b5c9b4721a87dc2fa7c5e700c
True
0,0,0,0
Text146
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Top, Bottom;Black;1;Double;False;4;Black
Transparent
True
14.7,0,1.8,0.42
Arial Unicode MS,8
176512e9af8249d99da73ec171e5ffb6
Center
True
0,0,0,0
txtFtrTotalOverdue7
{nTotalOverdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
75d1a4c4edb04870b1b7fe2d835ed354
FooterBand6
Transparent
0,8.41,27.7,1.78
Transparent
0,1.15,3.2,0.36
Arial Unicode MS,7,Bold| Italic
36a82996fa04437c89f42f16b9c25612
0,0,0,0
Text148
End of Report
[64:82:94]
Expression
478bd02b46f84e7f9127510f1deb7737
ReportSummaryBand1
False
99a878ce770245ba8bff9a114a479201
True
1,1,1,1
Layout7 (Disabled)
Landscape
21
29.7
Letter
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,27.7,1.85
Transparent
0,0.2,12.19,0.76
Arial Unicode MS,9,Bold| Italic
126a1f221b524276983c1da82c57a043
0,0,0,0
Text85
{ReportName}
[64:82:94]
Transparent
True
0.05,1.07,27.11,0.41
Arial Unicode MS,8.25,Italic
1a8d53be75894682b6b2be579f5b767a
0,0,0,0
Text86
Business Entity: {pBusEntText} - Project No. {pProjectText}
[64:82:94]
Expression
af2bb3351631483a812dd2beb2dad711
PageHeaderBand7
ExceptFirstPage
Transparent
0,18.55,27.7,0.45
Transparent
True
0,0,16.76,0.41
Arial Unicode MS,7,Italic
603c9d5ce5644de09d878243c8734e72
0,0,0,0
Text101
Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.versionno})
[85:109:124]
Expression
Transparent
25.6,0,2.1,0.41
Arial Unicode MS,7,Italic
4775576310f44beaa273316094786b43
Right
0,0,0,0
Text102
{PageNofM}
[85:109:124]
Expression
0.01,0,27.69,0.0254
85, 109, 124
Black
4b9dbf2dd8cc452b99b7d44d8b615c1a
HorizontalLinePrimitive7
Black
a518361dd73649e1b21604f003045b47
PageFooterBand7
Bottom;Silver;1;Solid;False;4;Black
White
0,3.05,27.7,0.84
None;Silver;1;Solid;False;4;Black
White
0,0,27.7,0.42
Arial Unicode MS,8,Bold
e9d6ae5c25c8415d861fe840641700d9
True
0,0,0,0
Text87
Workflow Tracker by Workflow Responsible Owner & Current Activity to action
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
0,0.42,6.2,0.42
Arial Unicode MS,8,Bold
57f3e287e97546c3a4b2c902d6f24764
True
0,0,0,0
Text88
Process Workflow
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
6.2,0.42,6.6,0.42
Arial Unicode MS,8,Bold
8ba5b9b56e7346c7a9595933817d81b2
True
0,0,0,0
Text89
Responsible Owner
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
12.8,0.42,1.8,0.42
Arial Unicode MS,8,Bold
e12bfd644b6142aeb52056870c86a812
Center
True
0,0,0,0
Text90
In Progress
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
14.7,0.42,1.8,0.42
Arial Unicode MS,8,Bold
c60fe711c3d14f548f158be11f56fc4d
Center
True
0,0,0,0
Text91
Overdue
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
16.8,0.42,4.7,0.42
Arial Unicode MS,8,Bold
346c49ab72f14e1a8b6690cba8c18ce9
True
0,0,0,0
Text92
Current Activity to action
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
21.6,0.42,6.1,0.42
Arial Unicode MS,8,Bold
e330a0ffad4b46868a823851c3ef50da
True
0,0,0,0
Text93
Person to action
Black
Expression
Center
Bottom;Silver;1;Solid;False;4;Black
White
16.4,0.42,0.4,0.42
Arial Unicode MS,8,Bold
6f2bb6c30b994b8683a2c0e87152b378
Center
True
0,0,0,0
Text99
Black
Expression
Center
97b6cc79e23f46818fc8ec1919520ae6
HeaderBand3
True
if(txtTotalOverdueRSB.TextValue!= "0" ){
this.txtTotalOverdueRSB.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Red);
} else {
this.txtTotalOverdueRSB.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black);
}
Transparent
0,4.69,27.7,0.42
Transparent
True
0,0,6.2,0.42
Arial,8
True
0,0,0,0
DatadsMasterLayout7_Process_Workflow
{dsMasterLayout7.Process_Workflow}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
6.2,0,6.6,0.42
Arial,8
True
0,0,0,0
DatadsMasterLayout7_Responsible_Owner
{dsMasterLayout7.Responsible_Owner}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
12.8,0,1.8,0.42
Arial,8
Center
True
0,0,0,0
DatadsMasterLayout7_In_Progress
{dsMasterLayout7.In_Progress}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
True
14.7,0,1.8,0.42
dsMasterLayout7.Overdue,NotEqualTo,_x0030_,,Numeric,Red,Transparent,Arial_x0020_Unicode_x0020_MS_x002C_8.25_x002C_Regular_x002C_Point_x002C_False_x002C_0,True,False,,,None
Arial,8
Center
True
0,0,0,0
DatadsMasterLayout7_Overdue
{dsMasterLayout7.Overdue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
dsMasterLayout7
DatadsMasterLayout7
if(dsDetailsLayout7.Overdue > 0)
{
txtExclamationMD.Enabled = true;
} else {
txtExclamationMD.Enabled = false;
}
Transparent
0,5.91,27.7,0.42
Transparent
True
16.8,0,4.7,0.42
Arial,8
True
0,0,0,0
DatadsDetailsLayout7_Current_Activity_to_Action
{dsDetailsLayout7.Current_Activity_to_Action}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
True
21.6,0,6.1,0.42
Arial,8
True
0,0,0,0
DatadsDetailsLayout7_Person_to_Action
{dsDetailsLayout7.Person_to_Action}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
None;Silver;1;Solid;False;4;Black
Transparent
True
16.4,0,0.4,0.42
Arial Unicode MS,8,Bold
True
53cb7204be17458b8ac961f61a5682cf
Center
True
0,0,0,0
txtExclamationMD
!
Red
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
relLayout7
dsDetailsLayout7
DatadsDetailsLayout7
Transparent
0,7.13,27.7,2.2
Transparent
0,1.57,3.2,0.36
Arial Unicode MS,7,Bold| Italic
05ff66539dcd44fd99e49aca03f117ad
0,0,0,0
Text109
End of Report
[64:82:94]
Expression
Top, Bottom;Black;1;Double;False;4;Black
Transparent
True
12.8,0,1.8,0.4
Arial,8
1f72d8deccc04f1cba93642f13995a52
Center
True
0,0,0,0
txtTotalInProgressRSB
{SumD(DatadsMasterLayout7, dsMasterLayout7.In_Progress)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Top, Bottom;Black;1;Double;False;4;Black
Transparent
True
14.7,0,1.8,0.4
Arial,8
9f6bd40382474b69ab3898f5d2fb2e2e
Center
True
0,0,0,0
txtTotalOverdueRSB
{SumD(DatadsMasterLayout7, dsMasterLayout7.Overdue)}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
786002b9b00547219b5bfc1a69eaf2ee
ReportSummaryBand2
5005b23d2e364369b9af8b1459ee8adc
1,1,1,1
Layout7MasterDetail
Landscape
21
29.7
Letter
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0,19.61,16
False
90275c0fac254c089a07140e7492ed4b
0,0,0,0
RichText2
False
__LP___x005C_rtf1_x005C_ansi_x005C_ansicpg1252_x005C_deff0_x005C_deflang1033__LP___x005C_fonttbl__LP___x005C_f0_x005C_fnil_x005C_fcharset0_x0020_Arial_x0020_Unicode_x0020_MS_x003B___RP____LP___x005C_f1_x005C_fswiss_x005C_fprq2_x005C_fcharset0_x0020_Tahoma_x003B___RP____RP___x000D__x000A___LP___x005C_colortbl_x0020__x003B__x005C_red13_x005C_green13_x005C_blue13_x003B___RP___x000D__x000A__x005C_viewkind4_x005C_uc1_x005C_pard_x005C_cf1_x005C_ul_x005C_f0_x005C_fs16_x0020_DSR_x0023__x005C_ulnone_x005C_tab_x005C_tab_x005C_tab_x005C_ul_x0020_Who_x005C_ulnone_x005C_tab_x0020__x0020__x0020__x005C_ul_x0020_When_x005C_ulnone_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x005C_tab_x005C_ul_x0020_Revision_x005C_ulnone_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x005C_ul_x0020_Comment_x005C_ulnone_x005C_par_x000D__x000A__x005C_cf0_x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_31-May-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AA_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Draft_x0020_layout._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_16-Jun-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AB_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Fix_x0020_borders_x002C__x0020_Concat_x0020_Discipline_x0020_Code_x0020_and_x0020_Discipline_x0020_Description_x0020_separated_x0020_with_x0020_a_x0020_dash._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_16-Jun-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AC_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Display_x0020__x0022_No_x0020_Discipline_x0022__x0020_when_x0020_Discipline_x0020_is_x0020_NULL._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_16-Jun-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AD_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Put_x0020_Based_x0020_on_x0020_Closed_x0020_Date_x0020_-_x0020_Published_x0020_Date_x0020_in_x0020_Layout_x0020_1_x0020_and_x0020__x0022_Under_x0020_Review_x0022__x0020_in_x0020_Layout_x0020_2_x0020_and_x0020_3_x0020_AND_x0020_display_x0020_Register_x0020_Name_x0020_instead_x0020_of_x0020_Code._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_16-Jun-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AE_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Display_x0020_Register_x0020_Name_x0020_on_x0020_top_x0020_of_x0020_Discipline_x0020__x0028_Layout_x0020_1_x0020_and_x0020_2_x0029__x002C__x0020_Originator_x0020__x0028_Layout_x0020_3_x0029__x002C__x0020_Display_x0020_CmDocument.Code_x0020__x002B__x0020__x0027__x0020_-_x0020__x0027__x002B__x0020_Cmdocument.Description_x0020_parameter_x002C__x0020_Busent.Shortname_x0020__x002B__x0020__x0027_-_x0027__x0020__x002B__x0020_Busent.Name_x0020_parameter._x0020__x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_17-Jun-2022_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_AF_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Left_x0020_aligned_x0020_Discipline_x0020_and_x0020_display_x0020_red_x0020_when_x0020_overdue_x0020_is_x0020_greater_x0020_than_x0020_zero_x0020_for_x0020_Overdue_x0020_and_x0020_Rejected_x0020_columns._x005C_line_x0020_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_21-Jun-2022_x005C_tab_x0020_AG_x0020__x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Added_x0020_Layouts_x0020_4_x002C_5_x0020_and_x0020_6._x0020_Replaced_x0020__x0022_Based_x0020_on_x0020_Closed_x0020_Date_x0020_-_x0020_Published_x0020_Date_x0022__x0020_with_x0020__x0022_KPI_x0020__x0020_-_x0020__x0020_Turn_x0020_Around_x0020_Time_x0022_._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_22-Jun-2022_x005C_tab_x0020_AH_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Layout_x0020_4_x002C_5_x002C_6_x0020_bold_x0020_header_x0020_column._x0020_Updated_x0020_datasources_x0027__x0020_SQL_x0020_for_x0020_Layout_x0020_4_x0020_and_x0020_6_x0020_adding_x0020_ProjectRole_x0020_and_x0020_Authuser_x0020_for_x0020_Global_x0020_Project_x0020_Role_x0020_after_x0020_Person_x0020_name_x005C_line_x0020_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_23-Jun-2022_x005C_tab_x0020_AI_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Corrected_x0020_labels_x0020_for_x0020_Layout_x0020_4_x002C_5_x002C_6_x0020_-_x0020_Worfklow_x0020_Traker_x0020_by_x0020__x0028_Activity_x0020_Owner_x005C_lang3081_x005C_f1_x005C_fs18_x0020__x002C__x0020__x005C_lang1033_x005C_f0_x005C_fs16_x0020_Activity_x0020_Owner_x0020_Company_x005C_lang3081_x005C_f1_x005C_fs18_x0020__x002C__x0020__x005C_lang1033_x005C_f0_x005C_fs16_x0020_Workflow_x0020_Owner_x0029_._x0020_Updated_x0020_SQL_x0020_for_x0020_Layouts_x0020_4_x0020_to_x0020_6._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_23-Jun-2022_x005C_tab_x0020_AJ_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Disiplay_x0020__x0027_No_x0020_Discipline_x0027__x0020_if_x0020_there_x0020_is_x0020_no_x0020_Discipline._x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_29-Jun-2022_x005C_tab_x0020_AK_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Sort_x0020_Layout_x0020_4_x0020__x0022_Workflow_x0020_by_x0020_Activity_x0020_Owner_x0022__x0020_by_x0020_name_x0020_ASC_x002C__x005C_par_x000D__x000A__x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Sort_x0020_Layout_x0020_6_x0020__x0022_Workflow_x0020_Tracker_x0020_by_x0020_Workflow_x0020_Owner_x0022__x0020_by_x0020_name_x0020_ASC_x002C__x005C_par_x000D__x000A__x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020__x0020_Added_x0020_Layout_x0020_7_x0020__x0022_Workflow_x0020_Tracker_x0020_by_x0020_Workflow_x0020_Responsible_x0020_Owner_x0020__x0026__x0020_Current_x0020_Activity_x0020_to_x0020_action_x0022__x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020__x0020_06-Jul-2022_x005C_tab_x0020_AL_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020_Added_x0020_Layout_x0020_7_x0020__x0028_SQL_x003B__x0020_datasource_x0020_and_x0020_footer_x0020_along_x0020_with_x0020_text_x0020_components_x0029__x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020_19-Jul-2022_x005C_tab_x0020_AM_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020_Modified_x0020_Layout_x0020_7_x0020__x0028_started_x0020_with_x0020_Master-Detail_x0020_BUT_x0020_it_x0020_didn_x0027_t_x0020_work_x0020_so_x0020_updated_x0020_the_x0020_report_x0020_using_x0020_one_x0020_datasource_x0020_only_x0020_and_x0020_manually_x0020_coded_x0020_Process_x0020_Duplicates_x0029__x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020_20-Jul-2022_x005C_tab_x0020_AN_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020_Added_x0020__x0022__x0021__x0022__x0020_to_x0020_Current_x0020_Activity_x0020_Column_x0020_when_x0020_row_x0020_is_x0020_Overdue_x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020_21-Jul-2022_x005C_tab_x0020_AN_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020_Grouped_x0020_by_x0020_Process_x0020_Workflow_x0020_and_x0020_Responsible_x0020_Owner_x005C_par_x000D__x000A_SRI-PGRP-4619_x005C_tab_x005C_tab_x0020_PLR_x005C_tab_x0020_25-Jul-2022_x005C_tab_x0020_AO_x005C_tab_x0020__x0020__x0020__x0020__x0020__x0020__x0020_Converted_x0020_back_x0020_to_x0020_Master-Detail_x0020_as_x0020_Grouped_x0020_Databand_x0020_doesn_x0027_t_x0020_have_x0020_sorting_x005C_par_x000D__x000A__x005C_par_x000D__x000A__x005C_par_x000D__x000A_Notes:_x0020__x005C_par_x000D__x000A_Layout_x0020_1_x0020__x0020_-_x0020__x0020_dsCLosed_x005C_par_x000D__x000A_Layout_x0020_2_x0020__x0020_-_x0020__x0020_dsOutstanding_x005C_par_x000D__x000A_Layout_x0020_3_x0020__x0020_-_x0020__x0020_dsOriginator_x0020__x0020__x005C_par_x000D__x000A_Layout_x0020_4_x0020_-_x0020__x0020_Workflow_x0020_Tracker_x0020_by_x0020_Activity_x0020_Owner_x005C_par_x000D__x000A_Layout_x0020_5_x0020_-_x0020__x0020_Workflow_x0020_Tracker_x0020_by_x0020_Activity_x0020_Owner_x0020_Company_x005C_par_x000D__x000A_Layout_x0020_6_x0020_-_x0020__x0020_Workflow_x0020_Tracker_x0020_by_x0020_Workflow_x0020_Owner_x005C_par_x000D__x000A__x005C_cf1_x0020_Layout_x0020_7_x0020_-_x0020__x0020_Workflow_x0020_Tracker_x0020_by_x0020_Workflow_x0020_Responsible_x0020_Owner_x0020__x0026__x0020_Current_x0020_Activity_x0020_to_x0020_action_x005C_par_x000D__x000A__x005C_par_x000D__x000A_Layout_x0020_7_x0020_is_x0020_converted_x0020_to_x0020_Master-Detail_x0020_as_x0020_Group_x0020_Header_x0020_with_x0020_Databand_x0020_doesn_x0027_t_x0020_follow_x0020_its_x0020_sorting._x005C_ul_x005C_par_x000D__x000A__x005C_par_x000D__x000A___RP___x000D__x000A_
False
4adbb4b728e94a1d802879f27d440957
1,1,1,1
ModificationHistory
27.94
21.59
Letter
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Submittal Tracking Report
7/28/2022 1:58:28 PM
8/15/2014 3:05:38 PM
This lists packages for a nominated project
C:\Users\PioRapirap\OneDrive - Projection Group\Desktop\Workspaces\Reports\DOC-0013\20222507 (AO)\DOC-0013-AO.mrt
a13dbc8a9b56407fbf832aebcdd47314
Submittal Tracking Report
Centimeters
2014.3.0
CSharp
Left, Right;Silver;1;Solid;False;4;Black
[222:235:246]
Arial,8
bgOdd
Black
WhiteSmoke
deleteMe
White