title: SSRS - Is it possible to filter a field value but still return other values as null or blank space?
body: <p>In my file there are accounts and every account has strings we refer to as flags. Some have multiple flags, causing the account to appear in the report multiple times. I've been tasked with creating a report that shows all account numbers, with no duplicates, looking for for a specific flag.</p>
  <p>IE, looking for Flag2:</p>
  <pre><code>Current report:
  
  Account-A - Flag1
  Account-A - Flag2
  Account-B - Flag1
  Account-C - Flag2 
  
  Desired result:
  
  Account-A - Flag2
  Account-B -
  Account-C - Flag2
  </code></pre>
  <p>Does SSRS have a function that would allow me to accomplish this?</p>