250
THEN Left(Replace(Replace(CV.PrimaryDiscussion, char(13), ''), char(10), ''), 245) + ' [...]'
ELSE Replace(Replace(CV.PrimaryDiscussion, char(13), ''), char(10), '')
END AS [Summary]
,CV.[Lifecycle] AS [LCValue]
,CV.TypeShort + '.' + CV.Number + 'A' AS [SortBy]
FROM
viewer.ChangeView CV
UNION ALL
SELECT
'' AS [Number]
,'' AS [Lifecycle]
,'' AS [Priority]
,CASE
WHEN Coalesce(ChgRvw.[Response], 1) = 1 -- pending
THEN CASE
WHEN ChgRvw.[ParticipationCode] = 0 THEN 'MUST ACT: '
ELSE 'Can act: '
END + Grp.[Name]
ELSE Grp.[Name] + ' ' + CASE
WHEN ChgRvw.[Response] = 0 THEN 'approved'
WHEN ChgRvw.[Response] = 2 THEN 'held'
WHEN ChgRvw.[Response] = 3 THEN 'disapproved'
ELSE ''
END + ' on ' + Left(Convert(nvarchar, ChgRvw.ReviewedOn, 120), 10) + ' by ' + Rvwr.[Name] +
CASE WHEN Len(ChgRvw.[Comments]) > 0 THEN ' with comment: ' + Left(Replace(Replace(ChgRvw.[Comments], char(13), ''), char(10), ''), 100)
ELSE ''
END
END AS [Summary]
,CV.[Lifecycle] AS [LCValue]
,CV.TypeShort + '.' + CV.Number + 'B' + Right('000' + Cast(ChgRvw.Sequence AS varchar), 3) + Grp.Name AS [SortBy]
FROM
viewer.ChangeView CV
INNER JOIN [dbo].[ChangeApproval_View] ChgRvw ON ChgRvw.ChangeAction=CV.ItemId
INNER JOIN [dbo].[Department_View] Grp ON Grp.Id=ChgRvw.Department
LEFT JOIN [dbo].[Person_View] Rvwr ON Rvwr.Id=ChgRvw.Reviewer
) T1
WHERE
[LCValue]<=5 OR [LCValue]=7 OR [LCValue]=9
ORDER BY
[SortBy]
]]>
1.5in
1in
1in
4in
0.25in
true
true
Number
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Lifecycle
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Priority
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Summary
DimGray
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Number.Value
2pt
2pt
2pt
2pt
true
true
=Fields!Lifecycle.Value
2pt
2pt
2pt
2pt
true
true
=Fields!Priority.Value
2pt
2pt
2pt
2pt
true
true
=Fields!Summary.Value
2pt
2pt
2pt
2pt
After
true
true
DataSet1
0.5in
7.5in
0.53in
7.5in
0.7in
true
true
0.65in
0in
7.5in
2pt
true
true
All Changes in Process
0.25in
3.25in
1
2pt
2pt
2pt
2pt
true
true
PDXpert Product Lifecycle Manager
4in
0.25in
3.5in
2
2pt
2pt
2pt
2pt
true
true
=Globals!ExecutionTime
0.31944in
4in
0.20833in
3.5in
3
2pt
2pt
2pt
2pt
0.42708in
true
true
0.04167in
0in
7.5in
2pt
true
true
Page
=Globals!PageNumber
of
=Globals!TotalPages
0.16667in
4in
0.20833in
3.5in
1
2pt
2pt
2pt
2pt
0.5in
0.5in
0.5in
0.5in
0
System.Data.DataSet
/* Local Connection */
DataSet1
/* Local Query */
Number
Priority
Summary
Lifecycle
Report2