title: need a specific row out of a datatable in a report
body: <p>Currently I get 3 rows back from a query, although the report only displays one of those rows. I need all three in the datatable, but only one row to be rendered. How can I choose that row specifically in the report. I'd rather not create another datatable in my dataset just to accommodate this.</p>
  
  <pre><code>=FormatCurrency(Fields!tip.Value, "DailySystemFinancialDataSet_tipsCount"))
  </code></pre>
  
  <p>That's what the field looks like, but I want to make sure the row it prints is where Fields!pay_type = 'comp tip'.</p>
  
  <p>EDIT***</p>
  
  <p>Like I said, I don't need to be manipulating these table rows.. the data is collected and calculated, I just need to get a specific row out of the table in the dataset. Everything is already passed to the report, so I'm using the report editor in design mode (vs2008) and I'd like a solution that works within those constraints. Thanks again.</p>