title: SSRS: Passing/Setting parameter to Dataset using Expression
body: <p>I am using <strong>Microsoft SQL Server Report Builder 3.0</strong>. I have created a <strong>Stored Procedure</strong> (<em>stored_procedure1</em>) in the database which has a <strong>Parameter</strong> (<em>parameter1</em>). Here, <em>stored_procedure1</em> returns <em>result1</em>.</p>
  
  <p>Then, I used <em>stored_procedure1</em> to create a <strong>Dataset</strong> (<em>dataset1</em>) in the <strong>Microsoft SQL Report Builder 3.0</strong>. Next, I created a <strong>Table</strong> (<em>table1</em>) in <strong>Microsoft SQL Report Builder 3.0</strong> with 2 rows and 2 columns (total 4 cells). </p>
  
  <p>I would like to fill each element of <em>table1</em> with <em>result1</em> from dataset1. Hence, I set expression of each cell of <em>table1</em> as follows:</p>
  
  <p><strong><em>=Sum(Fields!result1.Value, "dataset1")</em></strong></p>
  
  <p>When I run this report, it works perfectly and asks me to enter <em>parameter1</em>. However, I want to use single <strong>Dataset</strong> (<em>dataset1</em>) with different values of <em>parameter1</em> for each cell of the table. Hence, I want to pass/set <em>parameter1</em> with unique <em>parameter_value</em> for each expression of table cells. Say I want to set <em>parameter1 = parameter_value1</em> for first cell. </p>
  
  <p>For example, if I need to set <em>parameter_value = 5</em>, I did something like </p>
  
  <p><strong><em>=Sum(Fields!result1.Value, "dataset1"), Parameters!parameter1.Value = 5</em></strong></p>
  
  <p>I also tried following:</p>
  
  <p><strong><em>=Sum(Fields!result1.Value, "dataset1") &amp; Parameters!parameter1.Value = 5</em></strong>.</p>
  
  <p>It doesn't work.</p>
  
  <p>In summary, I coudln't pass or set parameter value together with an expression.
  Can we set/parameter value.</p>
  
  <p>I would like to thank you in advance.</p>