Sum Reportitems

I want to do is display the sum of textboxes in a group so I can have a subtotal for every group.

I tried these things:



Sum(ReportItems!txtbudget.Value).

I can't use Fields collection because the textbox value is from custom code so there are no Fields.



I searched for options on this and one option was supposed to be adding a field to the dataset. I tried this and I get "An error occured on the report server" when building the report before I even reference the field in the report.



I even wrote code to do the sum and passed in the ReportItem. I then get the error about the grouping scope.



I want the payroll sum to be the subtotal of each column. The budget values along with some other columns are from custom code that makes database calls (which was a workaround for another problem).













Object
Object Title
Budget
Current Spent
YTD Spent







4100
EMPLOYEES
$10,000.00
$11,307.45
$40,000

4105
EMPLOYEES - TEMPORARY
$2,000.00
$506.00
$7,000

4200
EMPLOYEE BENEFITS
$13,000.00
$2,354.74
$30,000


Payroll