group sum

I have a table with groups. I have a detail field (textbox66) that has the
following expression:

=iif(Fields!endDate.Value = Nothing, 1, iif(Fields!endDate.Value <
dateadd("d", 14, Parameters!startDate.Value), 0, 1))

I need to have a field in the group footer sum this column. How do I do
this? If I do =Sum(ReportItems!textbox66.value) in a group footer field, I
get the following errors:

Aggregate functions can be used only on report items contained in page
headers and footers.

AND

Report Item expressions can only refer to other report items within the same
grouping scope or a containing grouping scope.

Robert
Thu Oct 06 23:46:27 CDT 2005

Just use this expression for the group footer:
=Sum(iif(IsNothing(Fields!endDate.Value), 1, iif(Fields!endDate.Value <
dateadd("d", 14, Parameters!startDate.Value), 0, 1)))

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


"SharinDenver" <SharinDenver@discussions.microsoft.com> wrote in message
news:CC1EE200-443F-45B8-95CA-08FEFF2941C6@microsoft.com...
>I have a table with groups. I have a detail field (textbox66) that has the
> following expression:
>
> =iif(Fields!endDate.Value = Nothing, 1, iif(Fields!endDate.Value <
> dateadd("d", 14, Parameters!startDate.Value), 0, 1))
>
> I need to have a field in the group footer sum this column. How do I do
> this? If I do =Sum(ReportItems!textbox66.value) in a group footer field,
> I
> get the following errors:
>
> Aggregate functions can be used only on report items contained in page
> headers and footers.
>
> AND
>
> Report Item expressions can only refer to other report items within the
> same
> grouping scope or a containing grouping scope.