title: How to make an SSRS parameter = a field from another dataset
body: <p>I am writing an SSRS report to create an invoice.</p>
  <p>In my report, I have a dataset whcih runs the following query:</p>
  <pre><code>select Customer, Name, BillAddress, BillCity, BillState, BillZip from ARCM where ARCM.Customer = @BillCustomer and ARCM.CustGroup = 1
  </code></pre>
  <p>As you can see, I have a parameter called '@BillCustomer'.</p>
  <p>I have another dataset which runs this query:</p>
  <pre><code>select Co, Customer, Invoice, TransDate, DueDate, PayTerms, CustRef  from ARBH
  Where Invoice = @Invoice
  </code></pre>
  <p>How can I change my report so that @BillCustomer does not need to be manually entered when I run the report however, it gets its value from the Customer field in the second dataset?</p>
  <p><img src="https://i.stack.imgur.com/18lSF.png" alt="Example" /></p>