Showing inactive users in reports module

Question

Good afternoon, 
 I have a question regarding the reports module in Sugar. My coworker would like to show results from an inactive user (the user is set to inactive as this employee no longer works for our company). However, her data did not get reassigned to another user as we want to keep the revenue line items on her name. 
 Is it possible to also run a report containing the inactive users? By filtering on employeestatus is inactive, we don't see a dropdown list with inactive employees (see screenshot below).

Maybe there is a very simple answer to this matter, I also checked the Sugar reports manual, but haven't found an answer yet. 
 
 Thank you in advance for your answer(s)!

Maike Mak · Accepted Answer

Hi Maike, 
 In order to include a specific inactive user, you need to add a filter that would identify them by something other than their user name. For instance, you could have a filter group with an 'OR' condition to either match on the list of your desired active users or an inactive user where their last starts with the appropriate text: 
 
 If you wanted multiple, specific inactive users in the report, you could add multiple filters to this grouping on the report. One potential issue is that the individual's last name may not be unique enough to only return the desired user (e.g. filtering on 'Smith' brings back 'Gina Smith' and 'Barry Smithson'). In that case, you could add a sub-grouping to filter on first and last name. In the following example filtering, I am filtering on any potential users selected from the active list as well as two additional users regardless of their status based on a matching first & last name:

Maike Mak · Answer

Maybe you are mixing up two fields: 
 - Employee Status (used to set if a user is shown on the employees module) 
 - Status (user has a license or not) 
 
 On the filter use Revenue Line Item -> Assigned User -> Field: Status = Inactive 
 this works fine on my side:

Result:

Bests 
 Bj&ouml;rn

Maike Mak · Answer

Set the filter to "Is one of" and also check the "run-time" 
 
 Now on executing the report you can choose what to display (active or inactive or both ) 
 
 Bests 
 Bj&ouml;rn