title: Pass one table field as a parameter to another table in SSRS report
body: <p>I am new in SSRS report. I am using SQL Server 2008 R2. I have created one SSRS report which have two tables, First table has only one column and second table has multiple columns. Now I want to pass first table column as a parameter to the second table to get result for second table.</p>
  
  <pre><code>First Table:
  Column: Assined_To
  
  Second Table:
  Columns: Assined_To,
           Status,
           Start_date,
           End_Date
  </code></pre>
  
  <p>As per first table "Assined_to" value, I have to show second table.
  I have done lots of googling for this but did not get any solution.
  link I got:
  "<a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c7e4d614-c4e2-4013-88c0-6aaa947af34f/want-to-pass-one-report-column-values-to-another-report-as-a-parameter-ssrs?forum=sqlreportingservices" rel="nofollow">http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c7e4d614-c4e2-4013-88c0-6aaa947af34f/want-to-pass-one-report-column-values-to-another-report-as-a-parameter-ssrs?forum=sqlreportingservices</a>"</p>
  
  <p>Can we do it?
  Please give your valuable suggestion for the same. Thanks in advance.</p>