title: Pass field from one dataset to another dataset as parameter In SSRS 2008 R2
body: <p>I have a scenario where one of my data-set returns multiple records. Now I have implemented grouping in my report so as to display each record from this data set on a different page.</p>
  
  <p>Now I have an another dataset which loads some data using fields from dataset1 as parameter. That means I need to assign the fields from dataset1 to dataset2 as parameter for each record.</p>
  
  <p>For a single record, we can assign the values from dataset1 to a report parameter and then use it for our dataset.</p>
  
  <p><em>But in this case, parameter always holds the value 1st record and passes it for every page or group.</em></p>
  
  <p>How can I achieve this?</p>