The detail row is grouped - because there are negative and positive values for quantity.

The Iif statement on the Total column is :=

=iif(sum(Fields!ADJUST_QTY.Value*Fields!ASTD_TOTAL_COST.Value) > 0, sum(Fields!ADJUST_QTY.Value*Fields!ASTD_TOTAL_COST.Value),0)

Which gives a correct...

Why oh why didn't I see that??!!!!

As ever - the things you work on for days - have a simple solution......... usually staring you in the face every time you...

Aha.... I see what you mean. And yes, that's the way to go. Thanks.

I'll tell the person who speced the report that it has to be the Bruno way or...

Bruno,

Thanks - but - either I'm missing something here - but your solution gives me a column of red - where the duplicated fields are hidden. I only want the...

I finally resolved it.....

The problem was that somebody (unbeknownest to me!!!) had installed SQL Server Personal Eddition (as they had trouble reading the Standard editoin CD - ).

It's...

Still haven't resolved this issue.

I read somewhere about licensing.....

I'm using SQL Server standard addition with a single server license.

When I installed Reporting Services 2005 - I created a separate instance...