title: SSRS Multiple Dataset Errors
body: <p>I have a simple SSRS report that displays data from one table. What I want to do is have a distinct list from that table displayed in a drop down list for the user to select. If I only use one dataset I can get it to display, but it displays values from the column multiple times. </p>
  
  <p>Example</p>
  
  <pre><code>Bob
  Bob
  Bob
  Cathy
  Cathy
  </code></pre>
  
  <p>If I create a second dataset that will list distinct values I get the following error message:</p>
  
  <blockquote>
    <p><em>An Error occurred during local report processing. The definition of the report is invalid. The Variable expression for the report 'body' refers directly to the field without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.</em></p>
  </blockquote>
  
  <p>I"m trying to follow the example I found here:
  <a href="http://msdn.microsoft.com/en-us/library/aa337400.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa337400.aspx</a> </p>
  
  <p>The second dataset is only for the parameter list. I don't understand why it's causing problems with the actual report. </p>