c# datatable is populated, need help printing particular data to a report

Question

what can I do on the reporting side, not the sql, or the c# part of the problem?

my query returns four rows, grouped by the field payment_type, then puts the results into a datatable that's connected to my report in c#.

What can I do on the report side to pull a specific row out of the datatable where payment_type="Cash" without modifying any existing sql queries or creating any new datatables?

the solution should be limited to working with the report editor only. modifying the sql query itself or creating a new datatable with the a subset of the data in my controller class cannot be part of the solution.

Answer 1

DataTable.Select can take simple expressions like "columnname operator value":

DataRow[] rows = MyDataTable.Select("payment_type = 'Cash'");
if(rows.Length > 0)
{
    DataRow rowYouWant = rows[0];
}

Answer 2

DataView's RowFilter property,

dt.DefaultView.RowFilter = "payment_type='Cash'";

Answer 3

There happens to be a bunch of functions available in the reporting services related to aggregating, limiting and/or rendering results from the dataset in a report.

Here's a good list of examples: http://msdn.microsoft.com/en-us/library/ms157328.aspx#ReportFunctions

Here's my solution to the situation as well.

=FormatCurrency(Sum(IIF(Fields!pay_type.Value = "Cash", Fields!empCurBal.Value, 0.0)))