title: How do I set 1st row value from sql in ssrs report?
body: <p>I'm working on SSRS report.</p>
  
  <p>There are two main fields <code>CurrentMV</code> and <code>PreviousMV</code> both are having there different formulas but I'm taking PreviousMV as a value of CurrentMV using <code>=Previous(Sum(Fields!CurrentMV.Value))</code></p>
  
  <p>Now How can I set 1st field only from sql and rest of other as it is coming from expression?</p>
  
  <p>Because of I'm using <code>Previous function</code> 1st value is always coming null :(</p>
  
  <p>I have the field in reporting proc which can give me the values but How can I set both 1st values as well as <code>Previous function</code> ?</p>
  
  <p><img src="https://i.stack.imgur.com/stAWG.png" alt="enter image description here"> </p>
  
  <p>Using <code>Ian</code> posts in answer But ,
  I want to display only <code>1st field</code> from <code>Sum(Fields!PreviousMV.Value)</code> 
  and all preceding values by using <code>Previous(Sum(Fields!CurrentMV.Value))</code></p>
  
  <p>I tried like following and getting syntax error:</p>
  
  <pre><code>=First(Sum(Fields!PreviousMV.Value)) ,Previous(Sum(Fields!CurrentMV.Value)) 
  </code></pre>