SQLTeam.com | Weblogs | Forums

SQL Server Report Builder Expression error

Could someone please tell me what is incorrect with this expression. I get a ')' expected error. Thank you!

=IIF((Sum(Fields!OwnerOccupied.Value)+Sum(Fields!Vacant.Value)+Sum(Fields!NoRentalUnits.Value)=Sum(Fields!NoUnits.Value), Nothing, "No Match"), "DataSet1")

Get rid of the second ( after IIF and the one after No Match"

=IIF(Sum(Fields!OwnerOccupied.Value)+Sum(Fields!Vacant.Value)+Sum(Fields!NoRentalUnits.Value)=Sum(Fields!NoUnits.Value), Nothing, "No Match", "DataSet1")