In a table count rows RRS feed

  • Question

  • I am wondering if I can get a bit of help

    If I have a data source that connects to a database.  
    in one data set I am querying and creating a table in my report.
    One column in the report has rows of unique values.
    In another column I would like to count the number of rows (from the other column) and put the number in that row.
    I am trying to create an expression for that cell.  However it seems like using counts and countrows cause errors.
    something like this:
    =CountRows( (Fields!reason_text.Value, "DataSet3") = (Fields!reason_text.Value) )

    It seems like count does not work in expression.

    Is there a way to do what I am trying to do?



    Tuesday, June 8, 2010 10:48 PM