You'll have to use some formulas - one to suppress the value on the report and another to get correctly run your totals.
I assume there is a unique field that identifies a "job" and that you are either grouping or sorting on it. I also assume that the record where you want to display the price is always the first one for the job.
On the report, right-click on the price field and select Format Field. Click on the formula button next to "Suppress" and enter something like this:
{table.JobID} = previous({table.JobID})
For the total, create a price formula that looks something like this:
If {table.JobID} = previous({table.JobID}) then 0 else {table.Price}
Use this formula in your sum instead of summing the price field.
-Dell
IP Logged
It worked!!! Thank you so much for being such a BIG help!!!!! 