"Michael C" wrote:

>
> I am using an IIF statement to sum a group of detail records that spans more
> than 1 page. The sum looks like this:
>
> Sum(IIf(Fields!MySwitch.Value = 'A', Fields!MyValue.Value,0))
>
> Im doing the sum in the table1_group1 footer and it works fine if all the
> data in the group remains on the same page, but once it is expanded to 2 or
> more pages I get #Error. Any suggestions?
>