"Crandaddy" <Crandaddy@discussions.microsoft.com> wrote in message
news:D47D0112-ECD7-4601-BEB5-98AFC5EC1CDB@microsoft.com...
> When I preview a report using a matrix, I get the following warning:
>
> "The value expression for the textbox 'Measures_Act_Amt' references a
> field
> outside an aggregate function. Value expressions in matrix cells should
> be
> aggregates, to allow for subtotaling."
>
> The report data looks fine, but I want to make sure I'm not doing
> something
> wrong. The expression in the value for this text box is:
> =Sum(Fields!Measures_Act_Amt_Signed.Value). Isn't Sum an aggregate
> function
> by definition?
>
> Also, I'm trying to put column heading labels over the row groupings, and
> it's unreliable at best. I saw a "Sleazy" hack posted to put a table into
> the
> single cell that spans above the row grouping columns and size the table
> columns to match the matrix columns. However, usually this does not get
> displayed at all at run-time. On one report I got it working, but
> naturally
> if the other real column headings expanded vertically because of
> text-wrapping, then the table did not expand and the background colors
> were
> all off. Anyway, it's not a great solution and I was wondering how other
> people have handled this.
>
> Thanks in advance!
>
> --Crandaddy