I hav a report that has a table group =Fields!Location.Value
and in the cells I do this
=Avg(IIF(Fields!Contaminant.Value = "Element1", cDbl(Fields!Value.Value), cDbl(0)))
what I am getting is 1 row for each location then there is a pagebreak! what i want is the next location right below the first I looked through for all the page breaks with no luck. Any ideas?
View Complete Post