title: How to try and display users that do no have entries for latest week in database
body: <p>Good day,</p>
  
  <p>i have a table with user activity information in.</p>
  
  <p>the table basically is as follow:</p>
  
  <pre><code>Eventdate,     UserId,       Activity
  2013-09-09     SusanM        Support Call
  2013-09-09     BrandonP      Meeting
  2013-09-09     MumbaM        Administration
  2013-09-16     SusanM        Support Call
  2013-09-16     BrandonP      Meeting
  </code></pre>
  
  <p>so as you can see everyone has updated there work for the 9th, but user MumbaM has not yet logged his entry for the 16th.
  is it possible to show on report if i select the date for the 16th MumbaM, even if he has no entry in the database? is there a way to right an sql query to based on the previous userid entries to include Mumbam for the 16th.</p>
  
  <p>So I would like the report for the 16th to display as follow:</p>
  
  <pre><code>2013-09-16     SusanM        Support Call
  2013-09-16     BrandonP      Meeting
  2013-09-16     MumbaM        no update yet
  </code></pre>