Home Forums Reporting Services Reporting Services How to you add summary (count) expressions for fields in a table report? RE: How to you add summary (count) expressions for fields in a table report?

  • January 25, 2011 at 3:23 pm

    #1278222

    jamey8420 (1/21/2011)

    This is what you are trying to duplicate:

    group 3 footer ="Total Products sold by " & {employeename} & "is: " & count(products_sold),employeename")

    you could do something like this:

    ="Total Products sold by " + Fields!employeename.Value + " is: " + Count(Fields!products_sold.Value)

    HI Jamey,

    Thanks for responding.

    I thought that also. But in Group footer 3, I want to count the number of rows in group footer 3 not report wide. I think, from looking at the numbers, Count(Fields!products_sold.Value) gives me a count of the field!products_sold) for the report and not just a count summary expression for the records that appear in group 3.

    Thanks again.

    Things will work out.  Get back up, change some parameters and recode.