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 2pt true true All Changes in Process 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