Home Forums Reporting Services Reporting Services 2008 Development Adding too Many Blank Rows RE: Adding too Many Blank Rows

  • April 2, 2014 at 9:12 am

    #1702515

    The solution was:

    =IIF((Count(Fields!Title.Value, "SSC1") < 1 AND RowNumber("SSC1") = 0) OR

    (Count(Fields!Title.Value, "SSC1") < 2 AND RowNumber("SSC1") = 1) OR

    (Count(Fields!Title.Value, "SSC1") < 3 AND RowNumber("SSC1") = 2), false, true)

    This would make this row visible if the dataset returned less than 3 rows.