title: How to get specific row from Dataset in RDLC report
body: <p>I have three textboxes. Each text box will show a value which get from first row, second row and third row of "MyDataset" Dataset. </p>
  
  <p>My Dataset contain about these</p>
  
  <pre><code> ____SEQ_NO____|____USER__
        1        |  Beckham
        2        |  Cantona
        3        |   Depay
  </code></pre>
  
  <p>So I created hidden tablix for binding Dataset and get values from each cell.
  My tablix include with </p>
  
  <p><strong>ROW1 Column</strong> for display USER from <strong>first row</strong> of dataset</p>
  
  <p><strong>ROW2 Column</strong> for display USER from <strong>second row</strong> of dataset </p>
  
  <p><strong>ROW3 Column</strong> for display USER from <strong>third row</strong> of dataset</p>
  
  <p>I try to use this expression for each Column.</p>
  
  <p><strong>For ROW1</strong> </p>
  
  <pre><code>        =Lookup(Fields!SEQ_NO.Value,1, Fields!USER.Value, "MyDataset") 
  </code></pre>
  
  <p><strong>For ROW2</strong> </p>
  
  <pre><code>        =Lookup(Fields!SEQ_NO.Value,2, Fields!USER.Value, "MyDataset") 
  </code></pre>
  
  <p><strong>For ROW3</strong> </p>
  
  <pre><code>        =Lookup(Fields!SEQ_NO.Value,3, Fields!USER.Value, "MyDataset") 
  </code></pre>
  
  <p>But It's wrong. I don't understand. Why it show only first row like result below.</p>
  
  <pre><code>  _SEQ_NO___|___ROW1__|___ROW2__|___ROW3___
        1     | Beckham |         |  
        2     |         | Beckham |           
        3     |         |         |  Beckham
  </code></pre>
  
  <p><strong>###### My Expected Result should be like below. #####</strong></p>
  
  <pre><code>  _SEQ_NO___|___ROW1__|___ROW2__|___ROW3___
        1     | Beckham |         |  
        2     |         | Cantona |           
        3     |         |         |  Depay
  </code></pre>
  
  <p>If this is a correct. My three textbox can refer each specific row by this expression</p>
  
  <pre><code> **For Textbox1**
  
           =ReportItems!ROW1.Value 
  
   **For Textbox2**
  
           =ReportItems!ROW2.Value 
  
   **For Textbox3**
  
           =ReportItems!ROW3.Value 
  </code></pre>