title: RDLC report footer with value from "Current Record"
body: <p>I don't know if its possible or not, but thought I'd ask.  Many times reports need data grouping to have anchored to the bottom of the report some summary information, such as invoices.  You don't want the totals shifting UPwards based on only 2 detail lines vs another with 20.  I've tried working with using the Tablix bound to the data source for the output but couldn't get it quite right... It would either shift up, or force break and appear at top of following page.</p>
  
  <p>So, if anyone has some ideas to help resolve that, that too would be great.</p>
  
  <p>My second approach was to just use a simple report page footer.  However, the overall "Report" page is not technically "BOUND" to any datasource.  So, if I put a textbox in the footer and want it to show something, I can't pick "the most recent row from the datasource associated with the Tablix", it always requires an aggregate, such as </p>
  
  <pre><code>=First(Fields!SomeField.Value, "SomeDataSource" )
  =Sum( ...
  =Last( ...   
  etc...
  </code></pre>
  
  <p>I just want it to have whatever was the most recent... so I tried to use report variables to create one and was thinking to have it get updated per row being processed, so it always had whatever the "latest" value was and I could just dump that value at the bottom of the report.</p>
  
  <p>Any suggestions to either would be great.  Thanks.</p>