title: How to create drop-down list in SSRS based on WHERE clause below?
body: <p>At my organization we using UI third party tool that communicates with SQL database. I have access to a database, but not to the tool. </p>
  
  <p>Based on a stored procedure below user able to choose from drop-down list <code>DairyStatus</code> <code>"Open"</code>, <code>"Closed"</code>, or <code>"Both"</code></p>
  
  <p><a href="https://i.stack.imgur.com/6O8yH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6O8yH.png" alt="enter image description here"></a></p>
  
  <pre><code>ALTER Procedure
  AS
  @ShowOpen bit = 0,
  @ShowClosed bit = 0
   SELECT
   FROM 
   WHERE 
                AND
                          (
                          (CASE WHEN (@ShowOpen = 1) THEN
                                CASE WHEN (tblNoteRecipients.CompletedDate IS NULL and tblNoteRecipients.IsDiary = 1) or tblNoteRecipients.UserGUID is null THEN 1 ELSE 0 END
  
                          ELSE
                                1
                          END = 1)
                    AND
                          (CASE WHEN (@ShowClosed = 1) THEN
                                CASE WHEN (tblNoteRecipients.CompletedDate IS NULL) THEN 0 ELSE 1 END
                          ELSE
                                1
                          END = 1)
                    OR    ((@ShowOpen = 1) AND (@ShowClosed = 1))
                          )
  </code></pre>
  
  <p>So my question is how can I make same drop-down list in SSRS?
  What would be the data-set in order to populate this drop-down list?</p>