InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:25:42 GMT20http://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxSum(IIF(ReportItems!Test.Value Like "2011 Pass",1,0)) Im using a textbox in the header so there are scope issues if I use the Fields collection.Thanks Ten CenturiesMon, 17 Dec 2012 10:18:40 GMTSSRSnewBhttp://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxThanks is worksMon, 17 Dec 2012 10:16:42 GMTSSRSnewBhttp://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxSum(IIF(ReportItems!Test.Value Like "2011 Pass",1,0)) Im using a textbox in the header so there are scope issues if I use the Fields collection.ThanksMon, 17 Dec 2012 10:14:56 GMTSSRSnewBhttp://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxD'oh... never mind <post deleted>Mon, 17 Dec 2012 08:30:44 GMTgwade-730283http://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxDoes this do it?=Sum(iif(ReportItems!Test.Value = "Pass", 1, 0))CheersGazMon, 17 Dec 2012 07:16:30 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1396832-150-1.aspxI have a dataset column in a table region and I want to count on a condition with an expression in the header textbox but expression returningcould this be a scope problem since the textbox is not bound to dataset. Even though textbox is bound to the dataset.=Count(ReportItems!Test.Value = "Pass") just counts all the rows - this is in a textbox in the header of the reportFri, 14 Dec 2012 15:50:25 GMTSSRSnewB