Post reply

Count is returning a count of all rows

  • December 14, 2012 at 3:50 pm

    #286217

    I 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 returning

    could 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 report

  • December 17, 2012 at 7:16 am

    #1569137

    Does this do it?

    =Sum(iif(ReportItems!Test.Value = "Pass", 1, 0))

    Cheers

    Gaz

  • December 17, 2012 at 8:30 am

    #1569162

    D'oh... never mind <post deleted>

  • December 17, 2012 at 10:14 am

    #1569211

    Sum(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

  • December 17, 2012 at 10:16 am

    #1569212

    Thanks is works

  • December 17, 2012 at 10:18 am

    #1569214

    Sum(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 Centuries

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply