Termination reasons in mixed report

Summary

Need to include termination reason in a report containing active and terminated staff

Content

Hi

I have a report that shows current staff and all terminations in the last calendar year in the same report,  I need the leaver reason to populate for those who have left.  But the report isn't pulling the termination reason, just the change reason from the beginning of the line of data for that assignment

Thanks

Stuart Skene

Version

13.18.10 (11.13.18.10.0)

Code Snippet

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160">
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Worker Assignment Real Time"" withinHierarchy="true">
      <saw:columns>
         <saw:column xsi:type="saw:regularColumn" columnID="c53997de86d5a5b77">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Business Unit"."Business Unit Name"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="c0e5b09462abe77bd">
            <saw:columnFormula>