One of the views that I'm pulling data from has direct deposit information and I'm pulling it in via a sub report.  The data is structured like this:

 

Check_Doc_No    Type    Amount

55003                     C          100.00

55003                     S          100.00

55004                     C          500.00

55005                     C          150.00

55005                     S          200.00

 

Some check_doc_no's will have a single row with either C (checking), or S (savings), some will have 2 rows (1 each), and some will be on the main report but not in the sub report (the employee gets a real paycheck).

 

The check_doc_no field is the field that links it to the main report. 

 

Is there a way to have the sub report total the amount fields for multiple check_doc_no fields so I only see a total when I run the report?

 

Thanks for any help, ideas, thoughts, etc.